If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible to sync Access front end to Sql Server 2000 back end usingAccess?
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. |
#2
|
|||
|
|||
Possible to sync Access front end to Sql Server 2000 back end using Access?
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. wrote in message ... 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. |
#4
|
|||
|
|||
Possible to sync Access front end to Sql Server 2000 back end using Access?
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. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|