Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication between SQL 7.0 and Access 200

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-06 : 15:01:33
Kashif writes "Hi, I guess, this has been answered somewhere, but since plenty of hours I could not find it. Is there any good tutorial for following situation :
- All Data is in SQL Server 7.0
- Plenty of Clients, all have Access 2000 DBs, most of them Login Remote (via ISDN) --> into NT 4.0 Server and have appropriate permissions
- I need Merge Replication
- All Queries/Forms/Reports/Makros are in Access 2000 DB, which will also be replicated

How is the procedure to get to this aim?

Access Replication and Synchronisation works fine.

Problem is Replication from SQL to Access, it wont create the initial tables and Of course also not sync the modified data... though I checked "...Some Subscribers are MS Jet 4.0...."

Is there any complete Tutorial for this or very similar situation? Any help would be appreciated highly, as I have been trying on this since several weeks.

Regards"
   

- Advertisement -