Possible to sync Access front end to Sql Server 2000 back end usingAccess?

[vegathena]

I work with Access front ends and a SQL Server 2000 backend.
Everything works just fine when we collect data in-house because it is
saved directly onto our SQL Server.

The problem now is that we are going to collect data outside of our
office, where we won't be able to connect to our SQL server. I can set
up the respective tables in Access so that the data is collected
within the Access database itself, but then I need to sync the data
collected on our laptops to our SQL Server database.

Is it possible to set up something within Access itself that would
allow me to sync the the Access data onto SQL Server?

Thank you in advance.

 

[PatHartman]

I can't give you details but this version of SQL Server supports replication
with Jet databases. However, SQL2005 does not support replication with Jet
so if you will be upgrading anytime soon, don't go down the replication
path.

I have a number of applications that run via Citrix and terminal Services.
That may be an option for remote users as long as they have an internet
connection.

 

[Tony Toews [MVP]]

The problem now is that we are going to collect data outside of our
office, where we won't be able to connect to our SQL server. I can set
up the respective tables in Access so that the data is collected
within the Access database itself, but then I need to sync the data
collected on our laptops to our SQL Server database.

Is it possible to set up something within Access itself that would
allow me to sync the the Access data onto SQL Server?

If records are simply to be appended to the SQL Server database then
once the folks are back at the office then you could put in some code
to link to the SQL server tables and append the records using queries.

If they are updates to data already there though that gets trickier.
What if someone else updated a record? Which update wins?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

(e-mail address removed) wrote in
m:

Is it possible to set up something within Access itself that would
allow me to sync the the Access data onto SQL Server?

If you're using SQL Server 2000 you can have a Jet 4 MDB participate
as a member of a replicated SQL Server database. I don't know the
details of how this works, but it's called heterogeneous
replication.

It was dropped in SQL Server 2005.