Trouble accessing Database

lizn

I've written a custom jsp that reads a database and seems to be erroring

java.sql.DriverManager.getConnection("jdbcdbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=Directory.mdb","","")

Here's the error I keep getting:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

I know my path is correct in the file and should open the database.

Any ideas on what could be wrong?

I'm running on windows with TS 6.5 SP 1 and Open Deploy 6

Migrateduser

You really probably should have put this in the Bit Bucket forum since it isn't strictly TeamSite related. Have you checked the permissions on the file? And have you made sure that no one else has it open?

I really wouldn't suggest using Access to backend any sort of multi-user system for reasons just like this. If possible, you should move your data into a real RDBMS like MSSQL or MySQL if you don't want to fork over licensing money. You could still use Access as a front end via ODBC if you were thusly inclined.