URGENT PROBLEM

[Guest]

Some how I lover looked this in testing of my web app for my company before
launching, now I have a big problem! Please help!!

I am using an ASP to read and make changes to an access database.
I use a DSNless connection.
Another program accesses the same database through DSN that is checked
Read-only and not Exclusive.

When the other program access the DSN I can no longer access the database
from the ASP, it says "file already in use".
I can open it using Access and make changes without a problem.
Please email me answers to (e-mail address removed) if it's not
too much trouble. I will try back here for the answers too.

 

[Douglas J. Steele]

ASP usually runs under the security context of IUSR_<computer name>. What
permission does that ID have on the folder where the MDB file exists?

 

[Guest]

In this case I was running under alternate credentials that had full rights
of the folder.
I decided to use a DSN to access the file and it seems to be working just
fine now that I am doing that. I am still confused as to why it wasn't
working before but it works this way. I really do appreciate your response.

 

[Douglas J Steele]

What connection string were you using for your DNS-less connection?