Real-time update in SQL from ACCESS

I have an 2010 MS Access Database. I delete the SQL Table weekly and export it weekly to SQL via ODBC. I would love it if the SQL table is updated automatically. It becomes difficult when I am not in the office because having someone else directly on the server deleting the old table is an issue.
Michael FranzCFOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
A vastly better idea would be:
(1)  Do not delete either your local Access table, or the SQL Server table.
(2)  Link your SQL table into Access.
(3)  For your 'weekly process', run a delete query to delete all records in the linked table, then run an append query to insert all of your local Access table records into the linked SQL table.

>I would love it if the SQL table is updated automatically.
To state the obvious, if whatever form was doing the data entry was bound to a linked SQL Server table, it would update automatically.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Michael FranzCFOAuthor Commented:
I love the idea of delete and append. I know how to create the queries., but how do I link them.
0
Michael FranzCFOAuthor Commented:
Thansk for the help
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  -Jim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.