Matt_Hirst
Access Numpty
- Local time
- Today, 15:27
- Joined
- Nov 25, 2006
- Messages
- 15
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/datawarehouse and then when we have run a new set of criteria prompt for the location of the new tables?
I have looked at updating the links to the tables:
db.tabledefs(i).connect
This seems to point to what I need to update, however when I update it and then do:
db.tabledefs(i)refreshlink
I receive an error.
Now is this because I am trying to do it from the database that holds the links to the tables, i.e. should I split the front end forms from the linked tables??
I also tried the line:
db.tabledefs(i).updateable and it came back false, is this what is causing me problems?
Any help would really be appreciated.
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/datawarehouse and then when we have run a new set of criteria prompt for the location of the new tables?
I have looked at updating the links to the tables:
db.tabledefs(i).connect
This seems to point to what I need to update, however when I update it and then do:
db.tabledefs(i)refreshlink
I receive an error.
Now is this because I am trying to do it from the database that holds the links to the tables, i.e. should I split the front end forms from the linked tables??
I also tried the line:
db.tabledefs(i).updateable and it came back false, is this what is causing me problems?
Any help would really be appreciated.
regards,
Matt
