Update SQL records from Access Table

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I am trying to create a solution in which a table in
Access 2000, when modified, will update the corresponding
records in a SQL table.

The background:
I am creating an Access front end for four users that
calls on an ODBC database I'll call Table1. I have
written a pass-through query that returns each persons
unique records back into Access on a separate table called
Test.

What I need help with:
Now that I have Test, I want any changes made to Test to
be reflected in Table1 in SQL. There is a unique ID for
each record in Table1 which is returned into the Test
table in Access.

Thanks
 
If you have a form in Access, you can use the AfterUpdate Event to execute
queries against the SQL table. But, reacting to an entry in just the table
is not possible.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top