DB 'sharing'

Results 1 to 2 of 2

Thread: DB 'sharing'

  1. #1
    Join Date
    Dec 1969

    Default DB 'sharing'

    I have 2 Win2k IIS servers. Server 1 hosts a small site that queries an Access db for user authentication - (using DSN connection).<BR>Server 2 hosts a large site that is used by the same users as the site on server 1. How can I &#039;share&#039; the Access DB on server 1 so I can use it with the site on server 2?<BR>I&#039;ve shared the directory and mapped it as a network drive on Server 2. I can open and edit the DB on both servers and I&#039;ve tried both a DSN connection and a DSN-less connection. The DSN connection gives me the following error:<BR>The Microsoft Jet database engine cannot open the file &#039;(unknown)&#039;. It is already opened exclusively by another user, or you need permission to view its data.<BR><BR>The DSN-less connection gives me this error:<BR>Data source name not found and no default driver specified<BR><BR>Any tips would be greatly appreciated.<BR>Thanks<BR>Wally.

  2. #2
    Join Date
    Dec 1969

    Default RE: DB 'sharing'

    Its a common problem, see the info here should help (short version : if using UNC try using a mapped drive, otherwise check your NT perms)<BR><BR>http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269<BR><BR>regards,<BR><BR>Dave Kawliche<BR>http://AccessHelp.net<BR>http://1ClickDB.com

Posting Permissions

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