Connection string to remote Access db

Results 1 to 2 of 2

Thread: Connection string to remote Access db

  1. #1
    M Wynn Guest

    Default Connection string to remote Access db

    I want to use an OLEDB connection string to work with an Access 97 database. This works beautifully if the database is on my server&#039s hard drive:<BR> conn_temp.ConnectionString = Provider=Microsoft.Jet.OLEDB.3.51; Data Source = C:DBswebtest.mdb; User ID=admin; Password="<BR><BR>but if I try to connect to a database in a shared folder on another server (same connection string except for "Data Source= \myserverDBswebtest.mdb"), I get an error message "the file is open exclusively by another user or you do not have permission to view this data".<BR><BR>The database in question is NOT open by anyone, and the share and directory permissions give all users change access to the file.<BR><BR>Any suggestions?<BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Connection string to remote Access db

    I am having the same problem. Have you given the database IUSR permissions? If you find the answer, I would greatly appreciate a reply. Thanks!

Posting Permissions

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