Offline use

[John]

Hi

We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?

Thanks

Regards

 

[Van T. Dinh]

Read up and read a lot (Access Help, Access books, Microsoft Web sites,
other sources ...) on Replication and try it on a *copy* of the database
first before trying to implement on the production database.

 

[John]

I tried that but find it unreliable. Ideally I do not want to mess with the
backend db where the data is. That is why I am asking the sql server
question which I presume supports syncing natively and presumably reliably.

Thanks

Regards

 

[Van T. Dinh]

Yes, SQL Server supports replication also.

Check the SQL Server B.O.L. on Replication.

After you read the B.O.L., I would suggest checking the SQL Newsgroups also
to see potential problems of what you are trying to do.

 

[Alex]

Hi John,

yes in SQL you can do replication, the type of replication you are
looking for is merge replication within SQL, it also is not perfect and
would require modification of your data structures.

Regards

Alex