Invisible accdb file

[carrick25]

I have a 2008.NET application which uses an Access 2007 database. its
installed on my PC which runs Vista in a sub folder to Program Files.
I have the config file set up to read the database from the
applciation folder (ie same location as the exe) and I have put msgbox
commands in the exe to confirm that is where its opening the database
and it is coming from the same folder as the application is running
from. It runs fine, the database opens and I can read and write to
it. Only problem is its completely invisible to every other
application.

I cant see the datbase file in windows explorer (ive set show hidden
files on)
I cant see if using a dir from the command prompt
Its not there if I try to open it from notepad or from an email
I've made changes to the db through the app then done a search for all
files on my PC altered today and nothing shows up with the same name,
even in a different folder.
I've moved the entire folder from program files to under a user folder
and it comes up with an error saying it cant find the file!

I suspect its some super Vista feature I am unaware off, but I
developed this application and I cant even keep track of the database
how can I expect my users to!

Any suggestions would be greatly appreciated

 

[Arvin Meyer [MVP]]

Vista redirects files all over the place. That's probably your problem. I
suggest building (or rebuilding) the file in a specific location that you
have full permissions to create and control. C:\Database has always worked
for me.

 

[carrick25]

One more thing, the above was with me logged in as my user account
(has admin priv) when I switch to THE Vista admin account and try the
exact same exe it says it cant find the file.

So Im guessing its somehow cached this accdb file away some where else
but I have not idea where. Ive done a search on all hard drives of
files altered today then checked the date modified of these files and
none are the one I am looking for.

When logged on as my user account I right click my application and
choose 'Run as Administrator' it says it cannot find the file. But
even when I give all users full access to the application folder it
still runs. So Im assuming when logged on as a mere mortal user even
with full rights to the folder because its under Program Files Vista
in its finite wisdom is sending me off somewhere else even when the
application still things its accessing a folder under program files.

 

[carrick25]

Vista redirects files all over the place. That's probably your problem. I
suggest building (or rebuilding) the file in a specific location that you
have full permissions to create and control. C:\Database has always worked
for me.

Thanks for the quick response. I will change my install to default to
c:\database I'd like to know what is going on in case some poor user
decides to change my default setting and put it under Program Files.
I hope someone is getting benefit out of this 'feature'