Hello.
Access is FE to an SQL server DB. To speed things up, I have users look up a primary record and any tables/records associated with that primary record are temporarily copied to local tables. When a user uses a form to delete/update/insert records in the local table, I use Form events to mirror the changes to the SQL server. It works well, but has a lot of coding (I have to worry about each event, etc.) Is there a reasonably fast way to do this with perhaps less coding? Appreciate suggestions / tricks. Thanks!
Access is FE to an SQL server DB. To speed things up, I have users look up a primary record and any tables/records associated with that primary record are temporarily copied to local tables. When a user uses a form to delete/update/insert records in the local table, I use Form events to mirror the changes to the SQL server. It works well, but has a lot of coding (I have to worry about each event, etc.) Is there a reasonably fast way to do this with perhaps less coding? Appreciate suggestions / tricks. Thanks!