ASP.net Access DB Readonly ?? argh !!(Resolved).

[OptimusPrime]

I keep getting the following error when i try to run my asp.net application and can't figure out for the life of me whats going wrong as this only occours on my machine and the code runs perfectly fine on my colleagues ?

I do not have the database open and the database is not set to readonly

Is there a setting within XP that might be causing this problem ?

Any help greatly appreciated

Server Error in '/WebForm4ITrac1' Application.
--------------------------------------------------------------------------------

The Microsoft Jet database engine cannot open the file 'C:\VBNET\AccidentRecordingBeta\Solution\Database\Supplier.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\VBNET\AccidentRecordingBeta\Solution\Database\Supplier.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

[honeybee]

Make sure the database is actually not Read-Only. Also make sure if you or somebody else has opened it in Exclusive mode before the above code is executed. There might be a possibility you have already opened it in Exclusive mode earlier and are trying to create another connection to the database ...

.

[OptimusPrime]

Originally posted by honeybee
Make sure the database is actually not Read-Only. Also make sure if you or somebody else has opened it in Exclusive mode before the above code is executed. There might be a possibility you have already opened it in Exclusive mode earlier and are trying to create another connection to the database ...

.

check all these its none of them

i suspect it may have somthing to do with

1. IIS
2. User Permissions/Profiles
3. Jet Engine not functioning correctly

But

The Jet engine functions fine under windows operation but does not work within my asp.net project ?

IIS is functioning correctly, I have other asp.net projects working fine on my machine ?

But i could do with knowing what user permissions can have an effect on dataaccess/databases 2 try changing them see if this makes a difference

im gonna try reinstalling the jet engine then give it another go

[swatty]

I think you have a connection which is already open on this mdb.

[OptimusPrime]

Originally posted by swatty
I think you have a connection which is already open on this mdb.

nope its the first the software opens and it works fine on every other machine in the office (thats about 10) so im really stuck for answers now

and i dont really want to have to clear my machine down n start from scratch ??

[randem]

OptimusPrime,

Is this file actually on you machine and do the other PC's connect to this same database? Are the other PC's running XP?

If you open your .ldb file in notepad it will tell you how many users and what machine has it open.

[OptimusPrime]

i've sorted this problem out it was due to the user account for aspnet_client not being set up correctly


but if n e one experiences this problem check under


Start>Settings>Control Panel>User Accounts