Relation in multiple backend

[amir0914]

Do not confuse display format from data type. When your tables were converted to SQL Server, the incorrect data type for dates was selected. Either change them manually or redo the conversion. The other alternative is to change the ODBC driver you are using to a newer one. The problem with this is that you have to install and use this driver on ALL user computers also so it is not easy to distribute unless you have an IT staff who can do it for you. When the old ODBC driver does not recognize a data type, it sometimes treats the data as text. This doesn't work because the dates won't sort or compare correctly when they are strings.

Great !!
What about the next question : "SSMA_TimeStamp",
Is the field really needed ?

 

[Pat Hartman]

Access is more efficient if you use it. It allows Access to compare the value of 1 field rather than all the fields in a record to determine whether a row has been updated since it was retrieved. Every time a record is updated, the "timestamp" changes so if the timestamp it has in memory is the same as the timestamp on the record to be updated, Access knows that there is no conflict.