Can't find linked table in BE -
03-30-2011
, 10:32 AM
Using Access 2010. I'm attempting to split a database into a frontend/
backend. There's some coding that creates tables on the fly, like
so:
DoCmd.CopyObject , "DepositBatchInfo_" & Me.txtBatchName, acTable,
"tblBatchInfoTemplate" (tblBatchInfoTemplate is on the BE)
The table DepositBatchInfo_x is getting created but it appears that
it's on the BE. But when I open the BE, the table is not there. I
can open the table in the FE and enter data. When I invoke the linked
table manager, the table is listed as being on the BE. The linked
table manager successfully links it.
I've double-checked and I'm using the correct BE.
Anyone else had this problem? Thanks for any help or advice. |