Can't update database...

[vanillapod]

Hi, i've got an access dbase on a sever being accessed by users using asp. Anyway the users can view data but when they try to insert or update an error msg saying about the dbase is opened exclusively, i've checked the database and its set for no locks and opening as shared, the DSN is not set to exclusive and all files are NOT read only. So whats can be going on? Any help would be helpfull
Cheers
Gary

p.s.This error occurs even when there is only one user trying to use the system!

 

[BeckahC]

Is the database set to single user mode? BeckahC

 

[vanillapod]

how do you mean??

 

[BeckahC]

Oh, I should have asked first... are you using a SQL Server database?

If so, there is an option that can be turned on or off that makes the database run in "single user mode" when this is turned on, only one user can use the database at a time... this option must be turned on for certain types of database maintenance and such, but must be turned off when being used regularly in a multi-user environment. BeckahC

 

[vanillapod]

Nope no such luck! its an access database - wish it wasn't!

 

[BeckahC]

Well... I'm a little rusty on access... but I'm pretty sure there is a max. nu,ber of users allowed on at once... and certain types of table updates do lock the tables from update by another user, if they try to update at the same time... Are other multiple people trying to update the same table at once? I think this could cause the same type of error? BeckahC

 

[vanillapod]

Nope no other users! There will be but not until i get it up and running. Microsoft says: (but there's no linked tables being updated.

If you access a local Microsoft Access database that is linked to a table where the table linked to is in an Access database on a network server, you receive the following error message

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet
Database engine cannot open the file '******'. It is already opened
exclusively by another user, or you need permission to view its data.

 

[BeckahC]

Have you checked the permissions on the file itself, on the folder that it's in, etc.? Also, Have you asked around in the Access forum? There might be more people there who could help figure this out... I wish I could be of more help. BeckahC

 

[vanillapod]

Cheers anyway BeckahC i'll go ask in the access forum, i don't know why this is happening all the permissions are set to allow access / update etc.

Cheers
Gary

 

[BeckahC]

Ok, hope everything works out alright! BeckahC

 

[iowtech]

Just a thought, what sort of cursor type and lock type are you using in your recordset?

Have you tried connecting through OLEDB rather than ODBC?

 

[vanillapod]

Hey iowtech
how'd i do that?? I guess it'd be something to do with my connect string / dsn?
Cheers
Gary

 

[iowtech]

To use oledb use a connection string along the lines of:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb

The cursor type and lock type can be set as properties of your recordset or as parameters of the .open method.