Remote Access database connection


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Remote Access database connection

  1. #1
    Join Date
    Aug 2005
    Location
    Hermosillo, Sonora, Mexico
    Posts
    103

    Remote Access database connection

    Actually I have a SQL Server in a remote pc with a public IP and can connect with no problems over the internet using ADO, just by giving the IP instead of the server name in the connection string ...
    Now I need to connect with an Access database in the same remote pc..
    Any help will be appreciated... Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Kent, England
    Posts
    29
    I'm prepared to be shot down in flames but I believe that Access is a file based RDBMS (whereas SQL Server is network based) so to connect to it over a network you must have permission to access the server/folder containing the database.

    Assuming you have access to the relevant folder you can use ADO to connect by using a connection string in the format of:
    Code:
    CnxString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
                  "Persist Security Info=False;" & _
                  "Data Source=" & strDbPath & _
                  ";Mode=Read"
    Where strDbPath is like "F:\MyDbFolder\MyData.Mdb" [using mapped drive F:] or "\\NetwokServer\SharedFolder\MyData.Mdb"
    Edit this to your particular requirements.

    Trevor

Similar Threads

  1. MS Access Database Connection
    By GavW in forum Java
    Replies: 0
    Last Post: 05-20-2005, 09:49 AM
  2. Replies: 0
    Last Post: 06-28-2001, 04:08 PM
  3. Secured Access database ado connection error
    By Bob Sharp in forum VB Classic
    Replies: 3
    Last Post: 02-12-2001, 12:59 AM
  4. Access 2000 DB via DSN-Less ASP Connection...
    By JimmyD in forum VB Classic
    Replies: 1
    Last Post: 01-24-2001, 07:13 PM
  5. Ado Connection
    By Sok Y. Kim in forum VB Classic
    Replies: 4
    Last Post: 10-30-2000, 12:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center