 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / February 2007Vista Conversion
Hi all I have migraged a VB6 system to Vista, upgrading the Access DB to Office 2007 A single copy of the code addresses 7 instances of the database all kept in a common folder in C:\Program Files\BridgeResults\Databases. None of the accesses uses an Ado control One of the 7 instances produces results from an old copy of its database with a slightly different schema although I can see in the above folder the latest version I have completely failed to discover how the system is addressing this obsolete copy of thes database. I have single stepped the code and watched the connection string addressing the correct location. I have deleted all seven instances of the db and six excutions tell me the the DB is missing. However the seventh still runs using this old copy. The system has a parameter form which displays amongst other things the location of the database it is using. This indicates that it is reading the database from the now empty folder. My latest weeze was to execute a system wide search of the hard drives deleting all instances of the database found in the mahine and still the seventh instance runs Can any one suggest any diagnostic techniques to track this phantom database Roger Stenson Hi. I hope this helps. I ran into the same problem. Does your app write to any files under the c:\program files directory or its subdirectories? If so, chances are, your app is writing to another location. A new "feature" of Vista is the Virtual Store. In order to protect your Program Files directory, applications running in Vista that access files in the Program Files directory are actually re-routed to a "virtual store" folder. This means that no matter what you do to the files in your c:\program files directory, your app is actually using this other hidden dir. To see this directory, first set your folder options to show hidden and system files. Then, open windows explorer, and navigate to C:\Users\User_name\AppData\Local\VirtualStore. The virtual store folder may have a Program Files subdirectory. Look inside these folders, and you may find copies of your program's files. These are the files that Vista is telling your app to use, even though everything is pointing to the C:\Program Files folder. Kill the files in that Virtual Store folder, and your mystery data will go away. However, the next time you run your app, VISTA will put copies of the data files right back in the Virtual Store folder. To find out more, do a google search on "Virual Store" and "Vista." Good luck. - will f. > Hi all > I have migraged a VB6 system to Vista, upgrading the Access DB to Office [quoted text clipped - 22 lines] > database > Roger Stenson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.