Re: Synching between Access and MSSQL

From: Reid (warrex_at_cox.net)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 12:17:24 -0500

Look at SQL Server replication. There are 3 types of replication - look
especially at "Transactional with Queued Updates" - it was new with SQL
Server 2000.

How long will the clients be disconnected, i.e. max number of days without
synching up? One of the replication parameters is specifying how many hrs
or days to cache data before disabling a subscription. I've resynched as
much as 10 days' worth. I was also burned - once - by accepting the default
(3 days, I think) and then not being able to resync beyond that.

I've always done replication SQL-to-SQL, native mode, but it supports 2 way
SQL-to-Access as well. You might consider MSDE on the Access client, since
native mode is faster and presumably more reliable.

Reid

"Trent" <notvalid@dontspam.com> wrote in message
news:uQUXSCbwEHA.2192@TK2MSFTNGP14.phx.gbl...
> Hi everyone,
> I am looking to create an MSSQL database that has an Access 2000 front
end.
> The client side Access app needs to download selected bits of data from
the
> SQL database and the clients would work offline with this data and later
> when they re-connect the data would then need to be synchronized back into
> the SQL database.
>
> Can anyone point me in the right direction to get started with this so I
do
> not have to re-invent it all?
> My code will be significantly more complex eventually to accomodate how I
> need to manipulate and validate data but if someone can get me started
with
> info on the best method for 1. grabbing specific data from the SQL
database
> directly into Access programmatically, and 2. Programmatically connecting
> back to the SQL database from Access to send back the changes, then I
would
> have a great place to build from.
>
> Any sample code for connecting to external databases?
> Preferably, the Access app should be able to test if it has access to the
> database first and then respond by either uploading the data if connected
or
> alternatively storing the data locally. I will have to setup flags in
> the data to monitor status and do comparitive checks to make sure it went
> through without a problem before altering local flags, etc.
>
> Thanks for any help.
>
>