Click to See Complete Forum and Search --> : Access 2000 Problems


Backspace
April 16th, 2001, 10:04 AM
Ok here is the problem (not even our programmer is much help) I have a access program (database) that worked fine with access 97, I converted the database friday to 2000 and now everything that is linked to a .dbf file gives me this error "The Microsoft Jet database engine cannot open the file 'G:\DBASE\OWNEROP.DBF'. It is already opened exclusively by another user, or you need permission to view its data." Ok again I stress nothing changed on the network, and it still works fine with the 97 version. Any help with this issue is greatly appriciated, (the database resides on an NT 4 server)

Lowland
April 17th, 2001, 09:09 AM
Access files are.mdb, .dbf is fox-pro?? or some other, so...
Your ODBC set-up on you server is not guiding the client to the data. You have to set up the relationship (name it, configure it etc., etc., under ODBC on you NT box) It ain't that difficult, but you should seek help if you are uncertain
The error message you are getting is generic - Access assumes you did the ODBC link stuff, so when it can't get through decides it must be permission problems. Wel, it would, wouldn't it.

Good luck!!