Access Database: Open or closed??
Hello people!
I've got some asp pages linked to an Access database. Whenever the database is open and users access the pages the following messages comes up:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/mis/WebData/ResultsTopFrame.asp, line 7
I realise that the error message is coming up because the database is open. What i wanted to ask was is there a function or an if........than statement that can be used to determine if the database is already open and if so then redirect the user to another page?
Any help on this would be much appreciated. Thanks in advance peeps.
|
