Access 2000 Problems
Results 1 to 2 of 2

Thread: Access 2000 Problems

  1. #1
    Registered User Backspace's Avatar
    Join Date
    Aug 2000
    Location
    Midwest, USA
    Posts
    148

    Exclamation Access 2000 Problems

    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)

  2. #2
    Registered User
    Join Date
    Jan 2001
    Location
    Scotland
    Posts
    468

    Post

    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!!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •