I am assisting a colleague in upgrading a MS Access 2003 backend to SQL Server 2005. The database front-end will still be an Access 2003 mdb and they will be using ODBC links to the SQL Server backend.
I have been reading conflicting information about timestamp fields (which I believe the upsizing wizing automatically creates) Some sources say that a timestamp field is required in each SQL table as it makes it easier for Access to update data. Other sources say they are useless and can be deleted.
Could someone please tell me if there should be a timestamp field in every table on the SQL Server when using a mdb frontend?
Thanks for looking at my question.