Largish MySQL DB with MS Access front end. Pass-through to local table
Posted on 2013-12-10
I am using MySQL 5.1.70 and ODBC MySQL driver 5.2a with Access 2010.
I have a relatively large backend database of contacts in MySQL which will be accessed by multiple users.
Local users are restricted in terms of which contacts they are allowed to see (dependent upon what groups they belong to) so I want to get the MySQL server to return only the relevant records not the entire record set.
I want to copy this data into a local table when the database opens.
So this is how I think it should work:
1. Create the SQL (I'm happy with this bit)
2. Create the connection string (also think this is fine)
3. Run the SQL to create a local recordset (DAO or ADO not sure it matters a lot).
4. Append the returned rows into table (not very clear how to achieve this.
If this makes sense then I would value some help with steps 3 and 4 please.