I need to have a user edit records locally since the web based forms are lacking some features that the datagrid views in access have. The problem is linked tables are too slow. Pass through queries work great for speed but i don't know of a way of inserting a local table to mysql one. I'd like to do this from a stored pass through query if possible but if i can't, I guess vba would be fine. Any suggestions?
a little further info: Bascially all I want to do is this:
INSERT INTO mysql_web_table
SELECT *
FROM access_local_table;
a little further info: Bascially all I want to do is this:
INSERT INTO mysql_web_table
SELECT *
FROM access_local_table;
Last edited:
