• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Problem with an Access database in Windows 7

#1
I recently upgraded from Windows XP (32-bit) to Windows 7 (64-bit) and am having problem with an Access database.

I use a shareware program called SlowGold (to slow down musical passages without changing the pitch). SlowGold stores info in an Access database. When you install Slowgold, it creates an empty slowgold.mdb file in the C:\Program Files (x86)\SlowGold. I used the program a little to very that it worked under Windows 7, which created a few records in the database.

I opened the original slowgold.mdb file with Access and see that it contains just a few records (the file size is 128KB). I then renamed the original file to end with '.old' and copied slowgold.mdb file from a backup to the SlowGold directory (and called it slowgold.mdb). The file from the backup is 260KB.

When I open the 260KB file with Access, Access shows only a record or two in each table (actually it shows the exact same data as slowgold.mdb.old). If I rename the 260KB file to something other than slowgold.mdb (i.e. slowgold_new.mdb) and open it with Access, it shows all of my data. If I rename it back to slowgold.mdb, it shows almost no data. It shows the same info after a reboot (cold start of Windows).

I have updated slowgold.mdb using Microsoft Access in the past. (I am careful to shut down the Slowgold program before opening the database in Access.) This is also the same release of Access that I was using prior to the Windows 7 upgrade.

Anyone have a clue as to why Access is showing the data for the 128KB file when I open the 260KB file? I have searched Google for this and came up empty.

I have another PC running Windows 7 and if I open the 260KB file on it (with a file name of slowgold.mdb) it shows all of my data.
 
#2
Re: Problem with an Access database in Windows 7 - Solved

I found a solution to my "problem" :).

Microsoft added code in Vista (if UAC is enabled) and kept it in 7 which doesn't let application programs write to sensitive areas in the directory structure (i.e. “c:\”, the “Program Files” and “Program Files (x86)” directory structures, and the “Windows” directory).

SlowGold stores its database file at "c:\Program Files (x86)\SlowGold". When it attempted to update the database, Windows wouldn't allow the update to occur in the “Program Files (x86)” directory. It copied the file to the VirtualStore directory "c:\User\yourusername\AppData\Local\VirtualStore\SlowGold". Even though I copied my "backup" database file to "c:\Program File (x86)\SlowGold" Windows intercepted all open requests to the file (at this location) and opened the file in the VirtualStore instead.

Here is a better explanation of the Virtual Store
Can I Delete from the Virtual Store? | PCMag.com
 

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,962
Messages
673,240
Members
89,015
Latest member
loxioalix