My scenario:
Developing a web app on an intranet
Specifics:
NT4 Network with NT4 IIS server and seperate NT4 fileserver plus exchange, domain controller servers etc.
Database residing on the fileserver with a copy of it on the IIS fortesting using a ODBC system DSN.
Problem:
I have been tasked with deveolping a medium sized MS Access 97 database with a back end that stores the data an Access front end for the boss to use, and a web based front end for all other users, theproblem is i obviousley need to have both the access and the asp to be able to use the data from the back end at the same time. Not a problem i thought(stupidly!) the back end works fine on its own – it just sits there, next got the the Access front runnig it works well, so i close the front end and try the asp through IE not a problem works well(seems to), so i open the front end again with the web page still up – fine, next open the asp page with the Access front end running thats where it decides not to play.
i get this error message:
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Microsoft Access Driver] Could not use ‘(unknown)’; file already in use.
/mandamags/index.asp, line 10
At themoment the front end just uses tables linked direclty so i thought i would use an ODBC connection but that didn’t want to play either i got this error message:
You cannot use ODBC to import from, export to, or link am external Microsoft Jet or ISAM database table to your database.
I’ve tried using ODBC to connect to the database on the file server but it doesn’t like that but i think i found a workaround for that at the MSDN.
So if anyone could help me with getting the asp and Access front to run at the same time either with or without using ODBC or any other method it would be apprecited greatly.
Cheers Iain