Frontend Local Tables 2

[ZOR]

If I can, how do I import tables into a front end to be as local tables? I tried Import, but that imported tables with the blue box/arrows denoting they were somewhere else. Thanks

 

[fiep]

ZOR,

Did you try:
DoCmd.TransferDatabase acImport, "Microsoft Access", <access file>, acTable, <remote tablename>, <local tablename>

Works for me.

W.

 

[JoeAtWork]

When you did the import, which MDB file did you choose to get the table from?

I suspect you had it import from itself. Import from the back-end MDB instead.

 

[ZOR]

Thanks both. You were correct JoeAtWork, I got them from the wrong place. Made so many progressive copies of things and picked wrongly. It threw me when I used the inport tables and not the link tables. Have a star, and fiep thanks for the code. I'll use that later I'm sure. Regards