Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Synchronizing changes between Access and SQL Server with JRO

Status
Not open for further replies.

BrunoDelFrate

Programmer
Jun 19, 2001
4
IT
Hello,
I need to synchronize a MS Access database (97 or 2000, it doesn't matter) with a SQL Server 7.0 publication.
I've tried the JetSQLSync routine located at
... but it does not work: I keep getting a "File not found" message for the SQL Server string.
Another approach is shown at in the JROJetSQLSync routine... but how am I supposed to specify the SQL server string if the Target argument of the Synchronize method must stay empty???

Thanks in advance for your help.
Bruno Del Frate
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top