My users want to have both Web and Access Front-ends to an Access Back-end
database.
I've tested this and when a bound form in the Access FE is open (which
will be the case 99% of the time) I cannot open the connection to the
database in ASP, getting the following error message "Microsoft JET
Database Engine (0x80004005) Could not
use ''; file already in use."
Is it possible to have the ASP and Access FEs working simultaneously to
the same back-end Access database?
Thanks
Paul
Um... something doesn't sound right here. I'm currently running an ASP
application from an IIS5 server with an Access 97 backend. For kicks, I
built a bound form and played with it, then launched the web app without
any problems. What you might do is check to see if in Access options you
have the 'open database exclusively' flag checked.