Remote Database Access

Results 1 to 2 of 2

Thread: Remote Database Access

  1. #1
    Join Date
    Dec 1969

    Default Remote Database Access

    Please, what I should use to update Access db on second server the moment it is updated on first server. Servers are not on the same network.

  2. #2
    Join Date
    Dec 1969

    Default RE: Remote Database Access

    Since Access is a shared file database and not a server based database (like Oracle or SQL Server) you will have to be able to map a network drive between the two servers. That way you can set up a DSN (or do a DSN-less connection string) and open the "remote" database as though it were on the "local" machine.<BR><BR>Then, execute the same SQL statement against both databases from your app/web page.<BR><BR>Good luck.<BR>Joel

Posting Permissions

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