Synchronize with SQL Server

  • Thread starter Thread starter David
  • Start date Start date
D

David

Is there a simple way to keep a SQL Server database that was created by
upsizing an Access database synchronized with the original? I'd like to keep
the SQL data current with the data that's still being used in Access.
Thanks,
David
 
Well, if the ms-access user(s) will always have a connection to the sql
server, then why not just link the tables in ms-access to the sql ones. This
of course now means you don't store any data in ms-access, but all data is
now in sql server. (this is kind of the idea of up-sizing here).
I'd like to keep the SQL data current with the data that's still being
used in Access.
Click to expand...

as metnoend, you don't meny when, or how users will connect to sql server?
To keep the data current, or the same does hint that you need some kind of
conectin to sql server here?

Any reasone why you don't just link to the sql server tables, and forget
about the local ms-access talbes?
 
Back
Top