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.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…