In the latest iteration of my database i need to repoint the linked tables to a new source location.
The steps i have been through are as follows:
Step 1 - Create an MS Access database with forms and tables
Step 2 - Test out functionality and sign off
Step 3 - Split database into Front End and Back End files
Step 4 - Store Back End on to shared folder and distribute Front End to limited number of in office users
Step 5 - In office users sign off functionality
Step 6 - Convert Back End tables to MySQL and uploaded to a database hosting site
Step 7 - Create an ODBC connection to the MySQL database
I now need to re-link the Front End to instead of pointing at the shared folder with the Back End file to the MySQL tables online and i'm a bit lost.
I tried:
Kind regards
Glen
The steps i have been through are as follows:
Step 1 - Create an MS Access database with forms and tables
Step 2 - Test out functionality and sign off
Step 3 - Split database into Front End and Back End files
Step 4 - Store Back End on to shared folder and distribute Front End to limited number of in office users
Step 5 - In office users sign off functionality
Step 6 - Convert Back End tables to MySQL and uploaded to a database hosting site
Step 7 - Create an ODBC connection to the MySQL database
I now need to re-link the Front End to instead of pointing at the shared folder with the Back End file to the MySQL tables online and i'm a bit lost.
I tried:
- External Data -> New Data Source -> Other Source -> ODBC Database
- Selected Link to the data source
- Select the Machine Data Source i created to connect to the MySQL Back End
- Selected All tables in the list and clicked OK
Kind regards
Glen