Hello,
I have a database split between back end and front end.
The back end contains just one table which is linked to a linked table of the front end db.
The task I perform is that I open the back end db and I delete the table in and I import a txt file creating a new table that I name with the same name that the deleted table had.
What I would like to achieve is to run some code or macro in the front end db that performs the two tasks mentioned above but without opening the back end db. Can anybody help?
Thanks for your help in advance
J
I have a database split between back end and front end.
The back end contains just one table which is linked to a linked table of the front end db.
The task I perform is that I open the back end db and I delete the table in and I import a txt file creating a new table that I name with the same name that the deleted table had.
What I would like to achieve is to run some code or macro in the front end db that performs the two tasks mentioned above but without opening the back end db. Can anybody help?
Thanks for your help in advance
J