Access2000, ASP and DSN

[nigele2]

I have recently installed Windows2000 with Access2000. I have created DSNs for my database in the old Access97 format and the new Access2000 format.

The Access97 works fine but is read only (no probs). However the Access2000 db gives the following error relating to the connect

Error Type:
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

The database is certainly not open or being accessed. I have tried adding UID=admin to the DSN connect string and various other obvious combinatrions but no luck.

Any thoughts would be more than welcome

Thanks in advance

Nigel

 

[MontyBurns]

Nigel,

Have u checked your Win2K folder permissions? Sounds like the folder containing the Access 2000 db doesn't have the necessary permissions.

It may also be related to permissions set in IIS.

I'm a bit of a beginner at ASP, so I recommend you try an ASP Databases Forum (p2p.wrox.com do a good one).

HTH,
Burns

 

[nigele2]

Thanks Burns

I have put the mdbs and code in exactly the same dirs so as the Access97 works I think the permissions are OK. I had a look anyway and cannot see anything wrong.

I have received input saying that the Windows2000 ODBC is not reliable and that OLE-DB is a better route. Any thoughts? I am wondering if this is a fully paid up Bill Gates bug?

Nigel

 

[nigele2]

Thanks Burns - you were right - permissions and my DSN Problem is solved. Having looked at the directories, in desperation, I set the mdb file to all for everyone. It worked.

In the meantime I tried OLE as follows:

Conn = Server.CreateObject("ADODB.Connection"
Conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\e2connew.mdb;User Id=admin;Password=;"

This led to an error which said it couldn't find

C:\WINNT\system32\e2connew.mdb

I looked in IIS for a default Data Source path but no such luck.

Any thoughts?