I am trying to connect to an table within an Access 97 mdb. (The user just told me that the table would be replicated) Anyway, I am using ADO connectivity (2.1) with inserts and updates and now I cannot connect to this table since it has been changed.

It works fine on the non replicated table but will not work otherwise. Even when I change to SQL updates alone (with no data there at start up) I keep getting a ODBC Access error. Anyone know of a way around this? What is the best connectivity to use to a replicated Access Database in VB??

Thanks again!!!