jinx_uk_98
Board Regular
- Joined
- Jul 3, 2005
- Messages
- 105
Hi there,
I want to create a database that connects to a MYSQL database to run some reports. Normally I would do this trough Get External data and use a ODBC connection.
The problem is this database is going to be saved to a shared folder where anyone can open and run the access reports at anytime. The users won't necessary have ODBC drivers installed.
Is there anyway I can code the connection settings and refresh tables instruction in VBA? or maybe there is a better solution entirely.
Basically my user need to run up to date reports from a MYSQL database, ideally using access as the report with have a field that converts some text to a barcode
Many thanks
Kev
I want to create a database that connects to a MYSQL database to run some reports. Normally I would do this trough Get External data and use a ODBC connection.
The problem is this database is going to be saved to a shared folder where anyone can open and run the access reports at anytime. The users won't necessary have ODBC drivers installed.
Is there anyway I can code the connection settings and refresh tables instruction in VBA? or maybe there is a better solution entirely.
Basically my user need to run up to date reports from a MYSQL database, ideally using access as the report with have a field that converts some text to a barcode
Many thanks
Kev