ACCESS2000 & DSN & ASP

[nigele2]

Using Windows2000 I transferred my Access97 db, set up a DSN and my ASP pages worked fine in read only mode - so far so good.

I migrated my db to Access2000, created a DSN but my ASP pages give the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/e2contacts/search02.asp, line 18

Any help most welcome

Thanks - Nigel

 

[nigele2]

Sorry to have troubled one and all. It was a permissions problem. I set ALL to everything and hey presto. Now I need to work backwards to see what the specific was.

 

[DSect]

FYI for future use:

http://www.localweb.com/jkc/devtips/kb/odb2.htm

^^ Has a list of most ODBC KB articles.