CODEWITHSUNDEEP
.netsql-serverms-accessms-access-2003
FunMatters
FunMatters

Reputation: 601

Is it possible to do a Trigger in Access that will insert a new row in a table in SqlServer Database?

I have an Access 2003 Database and want to add a trigger upon new row in Files Table to insert a new row with new info to another table in SqlServer 2008 database?

Is this possible after all? Or are there any other better methods/tools to accomplish this? I would appreciate some code snippets to get started.

Thanks for your sincere help!

Upvotes: 0

Views: 1463

Answers (2)

FunMatters
FunMatters

Reputation: 601

In the end I have created a windows service that will check for new rows in the Access Files table, by holding an index on the last rowID primary key. New rows are read and its data is sent to the Sql Server database.

Triggers would have been a better approach, but db is on Access 2003. The service runs twice a day and so far seems working as expected.

Upvotes: 0

paramosh
paramosh

Reputation: 2258

MS Access doesn't support triggers. But if you insert/update data on the form, you are able to use events and VBA. This article should help you: Optimizing Microsoft Office Access Applications Linked to SQL Server

Upvotes: 1

Related Questions