MS Access Connection trouble

Results 1 to 4 of 4

Thread: MS Access Connection trouble

  1. #1
    SKnight Guest

    Default MS Access Connection trouble

    Using the following...<BR><BR> set conn = server.createobject ("adodb.connection")<BR> conn.open "ReqBook"<BR><BR>We continuously get the error message:<BR>"Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file &#039(unknown)&#039. It is already opened exclusively by another user, or you<BR>need permission to view its data."<BR><BR>Any suggestions?????

  2. #2
    Hema S Guest

    Default RE: MS Access Connection trouble

    Check out permissions on your database.

  3. #3
    SKnight Guest

    Default RE: MS Access Connection trouble

    Forgot to mention... identical copies of database and asp&#039s... runs flawlessly on one box but not another. Both running NT, IIS 4 SP 5, identical directory structure and DSN entries. Are database permissions copied with itself or must be set up on each server?

  4. #4
    Join Date
    Dec 1969
    Posts
    52

    Default RE: MS Access Connection trouble

    Make sure that you also have permissions for the directory holding the database file. You more than likely will need "Full" permissions.<BR><BR>If this doesn&#039t work, you might consider reinstalling ADO (from the MDAC - www.microsoft.com/data/download_21242023.htm) it is possible that it is out of sync with your updates.


Posting Permissions

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