.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write
.exe file to Access read/write .exe file to Access read/write
.exe file to Access read/write
Go Back  Xtreme Visual Basic Talk > > > .exe file to Access read/write


Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2013, 07:00 PM
MrcToledo MrcToledo is offline
Newcomer
 
Join Date: Sep 2013
Posts: 2
Default .exe file to Access read/write


Good evening gentlemen,

I made a fairly basic inventory control program using VB6 and made it into a executable file. The program is supposed to read and write to an Access table, and does it fine while on the Visual Basic Studio.

I added the data file to the list of included files using the Package and Deployment Wizard, but the .exe program does not read from it nor write on it. Nevertheless I know it is reading and writing to something because you can log on the program and insert things in the inventory which will remain there despite not being written into the Access database file.

Can anyone help me discover from where is the program reading and writing ? And if I can recover this data somehow ?

Thanks in advance
Reply With Quote
  #2  
Old 09-19-2013, 03:27 AM
DrPunk's Avatar
DrPunk.exe file to Access read/write DrPunk is offline
Senior Contributor

* Expert *
 
Join Date: Apr 2003
Location: Never where I want to be
Posts: 1,403
Default

Is this running on Windows 7?

Sounds like it could be the VirtualStore issue.

Windows 7 protects files in certain folders from being changed. If those protected files get amended by a program (not running as Administrator, as is the default) then it amends of copy of that file in the User's VirtualStore folder, leaving the original file untouched.

You should find the file your program is editing somewhere around the c:\users\[username]\Appdata\local\VirtualStore folder. Note you might have to enable viewing hidden and system files to see the folder.

I suggest Googling about Windows 7 VirtualStore for more information about it.
__________________
There are no computers in heaven!
Reply With Quote
  #3  
Old 09-19-2013, 05:12 AM
dilettante's Avatar
dilettante.exe file to Access read/write dilettante is offline
Underclocked lifestyle

Forum Leader
* Guru *
 
Join Date: Feb 2005
Location: Michigan, USA
Posts: 4,524
Default

This is really an appcompat issue for legacy code running on a UAC system.

People used to get away with playing fast and loose and pretending they were on Win9x systems yet by making every user a member of either Administrators or Power Users. This allowed free ranging access to almost every filesystem location on the system, such a Program Files subfolders.

When Windows was hardened by UAC to help save users from this poor practice new vistualized filesystem and registry locations were deviced. A program that is not Vista Aware (as declared through its application manifest) is considered legacy.

When security violations occur now such legacy programs automatically have Virtualization appcompat shims applied. These will check the object (file, folder, registry object) and if virtualization applies to it then action is taken. The action taken is usually to divert the access to a copied item in the virtualstore, copying the item from its real location first if it hasn't been created by a prior virtualized security violation.


The filesystem virtualstore is at [LocalAppData]\VirtualStore. The special folder [LocalAppData] expands to different strings depending on:
  • Which version of Windows
  • Which drive is the system drive
  • What the user's profile name is (which may differ from the user's current display name)
  • What language is in use

If the user's profile name is Fred, the system drive is C:, the OS is Windows Vista or Windows 7, and the language is English then indeed the path looks like:

C:\Users\Fred\AppData\Local\VirtualStore

Eerily enough the legacy path:

C:\Documents and Settings\Fred\AppData\Local\VirtualStore

.. will still work since there is a junction point for this.

Quote:
A Junction Point is a physical location on a local hard disk that points to another location on that disk or another storage device. It is essentially a shortcut, thus the shortcut icon on Junction Point folders in Windows Vista.

For the most part, you can ignore Junction Points for everyday use of Windows Vista. The Junction Points are in Vista for backward compatibility of pre-Vista applications. Pre-Vista applications (applications written for XP and 2000) look for folders that are no longer used in Vista. Folders with the “My” prefix such as My Documents, My Pictures, and so on. There are also folders in your user profile that have been changed in Vista, and pre-Vista apps might be looking for the old folder structure during installation. If you don’t set the option to Show Hidden Files in Windows Explorer, you will rarely even see the Junction Point folders.
A lot has changed in the post-XP universe. A lot of the information about the details came out in the 2006-2007 timeframe and can be hard to find online anymore.
Reply With Quote
  #4  
Old 09-19-2013, 09:19 AM
MrcToledo MrcToledo is offline
Newcomer
 
Join Date: Sep 2013
Posts: 2
Default

Thank you very much DrPunk and dilettante, this was exactly the issue. I am very impressed with the solicitude presented by this community and the time taken to respond to my question so throughly, despite it being, I know see, badly formulated.

Thank you very much again.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write .exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write .exe file to Access read/write
.exe file to Access read/write
.exe file to Access read/write
 
.exe file to Access read/write
.exe file to Access read/write
 
-->