Access Database lock

[jgnasser]

I have a script in my database that accesses a table within the database but kind of opens the database anew and causes problems warning "you do not have exclusive access to the database, changes will not be saved etc". I tried to have it read the table by opening a recordset but it wasnt happy with that so as I look for other ways of having it access the table, I'm stuck with it. Is there a way in which access can be made not ot lock the database especially if I'm sure its just a single user database. I see the .ldb file created immediately you open the database thereby locking it from another procedure opening it.

 

[WayneRyan]

jg,

I think from what you are saying that you need to go to
Tools --> Options then go to the Advanced tab and uncheck
the Default open mode "Exclusive".

Wayne

 

[jgnasser]

Pat, here is the detail of why I'm doing that. I am using an ArcMap ActiveX which has a script to read a table within the database and use that to display points on a map within the access database. This code opens the database again using its interface IWorkspaceFactory and method OpenfromFile. These must be specific to ArcMap. My efforts to create a recordset and pass on to this have not succeeded even though I think that would be the right way round. Consequently, when this code runs, it locks the database in a way that you cannot edit anything else and even when you close the database, Access refuses to exit cleanly.