ODBC Microsoft Access Driver

[somersbar]

hello all,

im trying to connect to a microsoft access database from an ASP.NET web

form.
i keep getting the following error though:


ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use
'(unknown)'; file already in use. ERROR [IM006] [Microsoft][ODBC Driver

Manager] Driver's SQLSetConnectAttr failed ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file already in use.


i think its something to do with permissions and ive tried changing the

permissions on the folder that the mdb database is in (C:\Documents and

Settings\All Users\Documents), but im still getting an error.ive been
tryin to fix this for the past week but nothing i do seems to work.


any help would be appreciated.

 

[david epsom dot com dot au]

"already in use' suggests that you are trying
to connect to the database in exclusive mode.

I see in your code that ...

Of course, this will fail if you try to make more
than one connection.

Also, attempts to connect will fail if there
is ALREADY an LDB file, and you only have read
permission, or if you try to make a r/w connection
when you do not have permission to CREATE an
ldb file.

Test by trying to get your page to create
and delete a filt in the database folder, using
some other method (not using the ADO text ODBC,
because that uses the same ODBC driver as Access
uses).

(david)