Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

Synchronize MS SQL linked table and a local table

I have a several tables linked to a MS SQL Server. How do I synchronize a MS SQL linked table and a local table?  I want to do this so when I am not going the have an internet connect I will still be able to view the data. I will not be editing or entering data into the local table.
0
seanlhall
Asked:
seanlhall
  • 2
1 Solution
 
thenelsonCommented:
Take a look at replication. This is what it is designed for.

References on replication:
Replication white papers
http://Support.Microsoft.Com/kb/190766/en-us

q&a: Replication in microsoft access
http://Msdn.Microsoft.Com/archive/default.Asp?Url=/archive/en-us/dnaraccessdev/html/odc_replicationinaccess95.Asp

about choosing a tool for replication
http://Office.Microsoft.Com/en-us/assistance/hp052167661033.Aspx

a list of vba commands for replication:
Http://Office.Microsoft.Com/en-us/assistance/hp030698321033.Aspx

how to make a database replicable
http://Support.Microsoft.Com/kb/208774/en-us

troubleshooting common replication errors
http://Support.Microsoft.Com/kb/304026/en-us

replication faq
http://Support.Microsoft.Com/kb/282977/en-us

also, have a look at the "tsi synchronizer":
Http://Www.Trigeminal.Com/replication/synch.Asp?1033

Using the synchronize method:
Database.Synchronize pathname, exchange

the synchronize method syntax has the following parts.

Database an object variable that represents a database object that is a replica.

Pathname a string that contains the path to the target replica with which database will be synchronized. The .Mdb file name extension is optional.

Exchange optional. A constant indicating which direction to synchronize changes between the two databases, as specified in settings.  

Example:

Sub sendchangetoreplicax()

   dim dbs as database

   ' opens the replicable database
   set dbs = opendatabase("yourdatabase.Mdb")

   ' sends data or structural changes to the replica.
   Dbs.Synchronize "yourreplica.Mdb", _
      dbrepexportchanges

   dbs.Close

end sub
0
 
seanlhallAuthor Commented:
This answer lead me to the make table query which what I was looking for. Thanks.
0
 
thenelsonCommented:
You're welcome.  Glad to help.

Happy Computing!

Nelson
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now