Record Update Script ie: Trigger

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jwhiser (jwhiser_at_discussions.microsoft.com)
Date: 02/11/05

  • Next message: Cheval: "Re: Recommended Stretagy for Bi-Directional SQL DB Synchronization" 
    Date: Fri, 11 Feb 2005 09:27:02 -0800

    We have an application that has an Access DB backend. We have a SQL Server
    that collects data from another application. I am wanting to write a record
    to the SQL Server automatically whenever a record is added to the Access DB.
    I have visions of something similiar to a SQL Trigger only in an Access DB.
    HELP!!!

  • Next message: Cheval: "Re: Recommended Stretagy for Bi-Directional SQL DB Synchronization"

    Relevant Pages

    • Re: Migrating away from MS-Access
      ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
      (comp.databases.ms-access)
    • Re: Replication Suggestions
      ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
      (microsoft.public.sqlserver.replication)
    • Re: Best Practices for Data Access
      ... This approach also means you would have N backup strategies, N management strategies, N sets of stored procedures that cannot leverage the features of the backend--assuming the backend even supported SPs. ... While Oracle and SQL Server both support SPs, ... I need to design an smart client application that can run on mulitple and plugable backend like MS SQL, Oracle or MySQL. ...
      (microsoft.public.dotnet.framework.adonet)
    • RefreshLink error - 3078
      ... I'm in the process of converting an Access 97 backend to SQL Server 2005; ... I'm ready to link the backend data. ... I've created the DSN and started the linking process and get an error stating: ...
      (microsoft.public.access.conversion)
    • onchange moving to wrong record
      ... I have an Access 2000 front-end with a SQL Server 2000 backend. ... The OnChange event fires, ... instruct it to go to another record, no VBA code running that says to go to ...
      (microsoft.public.access.externaldata)