Access 97 and Windows 2000

[Adishekar]

Hi,

We use an application which makes use of MS Access 97 database. Until now
we did not have any problem with that as we were using that application on
win98 but now when we switched over to windows 2000, i get an error message
when i run the application with user rights but the same application with
administrator rights works fine, no problem.

I have installed that application with local administrator login on windows
2000 professional. The error msg is "Error Opening Database Error number:
3024 Couldn't find file 'filename.mdb' ". I checked for the file and it is
in its respective application folder. I can open that file in MS Access but
not through the application.

I even tried installing it in a different folder and checked the folder and
file permissions but of no vain.

Any suggestions would be appreciated.

TIA

 

[TC]

If you can amend the source code of "the application", I'd display the
pathfilename that the application expects to be able to open - immediately
before it tries to open it. (Ie. put a msgbox or similar statement
immediately before the OpenDatabase call.) Then just see if that
pathfilename exists, and if so, whether non-administraor users can access it
with other programs (eg. Notepad - but don't edit it!).

HTH,
TC