Sync Access with SQL2005
-
Hi All I am writing an app that is a time tracking systray utility but the scope has grown. The Version 1 release used a local Access DB to store Data but now management want to sync it centrally to an SQL server so group wide reports can be pulled. In short I am looking for direction on the best way to tackle this. SQL Sample Table CustomerID (int) Identity = Y (i.e. Auto incrementing) CustomerName (Text 50) DeleteFlag (int) RecordTimeStamp (timestamp) MS Access CustomerID (int) I Get the SQL ID for the record and put here) CustomerName (Text 50) DeleteFlag (int) My first thought (well within the first 10) was to check the SQL timestamp and only add records that were newer that the last stored timestamp. Thoughts
When people make you see red, be thankful your not colour blind.
-
Hi All I am writing an app that is a time tracking systray utility but the scope has grown. The Version 1 release used a local Access DB to store Data but now management want to sync it centrally to an SQL server so group wide reports can be pulled. In short I am looking for direction on the best way to tackle this. SQL Sample Table CustomerID (int) Identity = Y (i.e. Auto incrementing) CustomerName (Text 50) DeleteFlag (int) RecordTimeStamp (timestamp) MS Access CustomerID (int) I Get the SQL ID for the record and put here) CustomerName (Text 50) DeleteFlag (int) My first thought (well within the first 10) was to check the SQL timestamp and only add records that were newer that the last stored timestamp. Thoughts
When people make you see red, be thankful your not colour blind.
japel wrote:
The Version 1 release used a local Access DB to store Data but now management want to sync it centrally to an SQL server so group wide reports can be pulled.
At that point why even use the Access database at all?
japel wrote:
SQL Sample Table CustomerID (int) Identity = Y (i.e. Auto incrementing) CustomerName (Text 50) DeleteFlag (int) RecordTimeStamp (timestamp)
Don’t forget to add a developerID to that list, wont be long and management will want to know who’s working on which projects.