dbTalk Databases Forums  

Can't find linked table in BE

comp.databases.ms-access comp.databases.ms-access


Discuss Can't find linked table in BE in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
emanning
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.