The Microsoft Jet database engine

[Vera Cabanus]

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[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.



I created the ODBC and it checks O.K. when I click on verify in FP.
Running Windows XP PRO, FP2002, FP2002 ext., Access 2000.

I have two other webs with database that work just fine. Any help would be
greatly appreciated.

Vera


**********************************************
Y2000 Internet & WWW Services
Assisting businesses to get on the Internet
http://www.y2000.on.ca
http://www.Rent-And-Go.com

 

[Arvin Meyer]

If you transfered the database using a CD, it left the database as
read-only. You need to change file attributes. If the user (on an IIS web,
the user would be I_USR) does not have permissions to create and delete in
that folder. The database will create a lock and only allow 1 user.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[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.



I created the ODBC and it checks O.K. when I click on verify in FP.
Running Windows XP PRO, FP2002, FP2002 ext., Access 2000.

I have two other webs with database that work just fine. Any help would be
greatly appreciated.

Vera


**********************************************
Y2000 Internet & WWW Services
Assisting businesses to get on the Internet
http://www.y2000.on.ca
http://www.Rent-And-Go.com

 

[Vera Cabanus]

I believe this was from CD; so how do I change it? If there is a .lck file
in the web, should I just delete it?

I also tried to create a new dummy db web site and get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

Vera

**********************************************
Y2000 Internet & WWW Services
Assisting businesses to get on the Internet
http://www.y2000.on.ca
http://www.Rent-And-Go.com

If you transfered the database using a CD, it left the database as
read-only. You need to change file attributes. If the user (on an IIS web,
the user would be I_USR) does not have permissions to create and delete in
that folder. The database will create a lock and only allow 1 user.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[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.



I created the ODBC and it checks O.K. when I click on verify in FP.
Running Windows XP PRO, FP2002, FP2002 ext., Access 2000.

I have two other webs with database that work just fine. Any help would be
greatly appreciated.

Vera


**********************************************
Y2000 Internet & WWW Services
Assisting businesses to get on the Internet
http://www.y2000.on.ca
http://www.Rent-And-Go.com

 

[Arvin Meyer]

I believe this was from CD; so how do I change it? If there is a .lck file
in the web, should I just delete it?

Right-click on the file and choose properties. Uncheck Read-Only and close
the dialog.

I also tried to create a new dummy db web site and get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

There could be several reasons for that error. First, fix the read-only
problem and then see if the error persists. If it does, make sure there's a
unique index (primary key) in the query, so that the record can be updated.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access