At work I have been asked to create a MS Access front end for a mysql system - all simple enough.
The MYSQL system is rather large, so you run a set of criteria and it outputs a data warehouse with 270 odd tables, you then alter the criteria and re-run creating another 270 tables.
What I need to know is how I can tell Access to point it's linked tables to one directory and then when we have run a new set of criteria prompt for the location of the new tables - how can I do this?
regards,
Matt
The MYSQL system is rather large, so you run a set of criteria and it outputs a data warehouse with 270 odd tables, you then alter the criteria and re-run creating another 270 tables.
What I need to know is how I can tell Access to point it's linked tables to one directory and then when we have run a new set of criteria prompt for the location of the new tables - how can I do this?
regards,
Matt