Posted by Rick Brandt on 11/11/06 19:24

Jim Devenish wrote:
>
> Thanks for that. I suggested to them that they provide a simple
> means, such as a View or a Stored Procedure, that I could use in the
> front-end to update the SQL tables when the information changed in
> the Access back-end. They said that 'their technical people' would
> prefer to set up a trigger on the Access back-end and so monitor any
> changes to a particular table.
>
> I was not so sure, although my knowledge of SQL Server is limited.
> You appear to confirm my doubts.
>
> By the way, you may have realised that I wrote and maintain the Access
> system!

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.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

• Next in forum: Re: Rolling up spans without breaks between them
• Prev in forum: Re: Trigger on an Access database?
• Thread view: Re: Trigger on an Access database?

[Reply to this message]