|
|
Posted by Ed Murphy on 11/15/06 16:37
Rick Brandt wrote:
> Jim Devenish wrote:
> If all updates and insertions are done in your Access app via forms then you can
> link to the SQL Server tables and then use code in your forms that push
> identical updates to the SQL Server link.
But this risks making a mistake in the code. Before going down this
road, you should definitely evaluate migrating the back end from Jet
to SQL Server, thus allowing triggers.
Failing that, if near-real-time is acceptable, then create a stored
procedure that updates SQL to match Jet, and an Agent job to run that
procedure at some appropriate frequency.
Navigation:
[Reply to this message]
|