Hi,
I have set up a bit of code to copy an exisiting table and change the name slightly:
DoCmd.CopyObject , "TblDetail_" & PWyr, acTable, "TblDetail"
(Where PWyr is an integer which is set earlier)
TblDetail is stored in the back end of my database, and this code is running in the front end. TblDetail is a linked table in the front end.
When running the code, it all seems to work fine. The new table appears with the correct name & data in it.
It has the linked symbol by it, so I thought it had worked perfectly, storing the table in the back end and automatically creating a link to it in the front end.
This is how it acts, anyway. You are unable to open the table in design mode as it tells you its stored somewhere else, and you can succesfully refresh the link etc
BUT.... If you go into the back end, the table doesn't seem to be there...
Any ideas?
I have set up a bit of code to copy an exisiting table and change the name slightly:
DoCmd.CopyObject , "TblDetail_" & PWyr, acTable, "TblDetail"
(Where PWyr is an integer which is set earlier)
TblDetail is stored in the back end of my database, and this code is running in the front end. TblDetail is a linked table in the front end.
When running the code, it all seems to work fine. The new table appears with the correct name & data in it.
It has the linked symbol by it, so I thought it had worked perfectly, storing the table in the back end and automatically creating a link to it in the front end.
This is how it acts, anyway. You are unable to open the table in design mode as it tells you its stored somewhere else, and you can succesfully refresh the link etc
BUT.... If you go into the back end, the table doesn't seem to be there...
Any ideas?