form won't update, what to check

[Richard]

Hi

Background,
fe unbound form-1 linked to BE mdb - works okay
fe unbound form-2 linked to BE mdb - works okay

Now - upgrade to sql server BE, mdb FE linked using odbc
1. fe unbound form-1 linked to BE sql server table 1 - works okay using
currentproject.connection and sql connection

2. fe unbound form-2 linked to BE sql server table 2
- currentproject.connection (no error, doesn't update)
- sql connection (data update okay)

question is how to check why the data in not updating using link tables.

Hope you understand what I am writing here... I am using adodb connectioin
and recordset to update

Many thanks in advance
Richard

 

[John W. Vinson]

2. fe unbound form-2 linked to BE sql server table 2
- currentproject.connection (no error, doesn't update)

Does the SQL table have a Primary Key? Does Access know what it is?

If so, does the SQL table have a "Timestamp" (also called a Rowversion) field?
You don't need to *do* anything with the field but it can often help Access
keep track.

 

[Richard]

Hi John

Thanks for taking time to respond.

The table has a Primary Key. funny that if I use sql connection, it updates,
and doesn't when I use jet (i assume it to be) when I use
currentproject.connection.

When I migrated it to sql table, it added the "Timestamp" field
automatically, I'm not sure if I removed it or not but does it make a
diffrence?

Many thanks
Richard