Link to new table in split database

[tazzzz]

Hello all,


I have a split database. I have created a table in back end db and try to link my front end db to this table. Going to External data\Linked table Manager(in front end db) doesn't show my new created table. Have any ideas why is this happening? Are there other solutions to link a new table with my front end db?
Thank you for the help.

[ItsMe]

I think it may be as easy as using the import Wizard by selecting Access and ticking the Link option. Another approach would be to use VBA and DAO table defs.

[tazzzz]

Thanks for this info. It worked.

[ItsMe]

Glad to hear. Yeah, the link manager is to update existing links. Good luck on your project.