DB error.

with access

[natty]

hi all,

having a rather annoying problem with connecting to an access db

im getting this error.
'Description: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.'

i have done a bit of googling, and am coming to the conclusion that it is just that access has reached its max connections?
but most likely i am miles off the mark.

all that i can find on google are things talking about passwords. i am assured that the DB does not have any password business on it. and having had a look at it, i concur on that one.
which doesnt leave me with many options..
here is the connection string i am using..

strDBConn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & clientDBPath 
Set clientConnection = Server.CreateObject("ADODB.Connection")
clientConnection.Open strDBConn

clientDBpath is used in many other scripts, via an include, and none of them are dieing..
added the security info bit after having looked on google.

any ideas? or is this just access keeling over under the 'strain' of 12 connections?

tia

nat

[mrMister]

* What version of Access are you using?

* Are you properly closing and destroying the connection object each time?

eg. does your code have these lines

clientConnection.Close
Set clientConnection = Nothing

* Are any other applications (apart from your ASP app) using this database

* What happens when you remove the security info line...

eg, make your Connection String like this...

strDBConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & clientDBPath