Rayne
asked on
Access Best practise for updating linked table in ms sql server
There is an access db that has a table called [range1]. There is an identical table [range2] in sql server as well.
I set up the sql server as a linked odbc in my access.
I have a query that clears linked range2 table and copies all data from the [access] range1 table into that odbc linked table [range2].
How do I set up an trigger event so that anytime the table is updated or the database is closed, that macro runs to update sql server range 2 from range1 access table. For example – is an on close event for access application? That I can use here? Or any best practice that you gurus yourself use?
Thanks
I set up the sql server as a linked odbc in my access.
I have a query that clears linked range2 table and copies all data from the [access] range1 table into that odbc linked table [range2].
How do I set up an trigger event so that anytime the table is updated or the database is closed, that macro runs to update sql server range 2 from range1 access table. For example – is an on close event for access application? That I can use here? Or any best practice that you gurus yourself use?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.