Confused about linked tables

[plantfinder]

I've successfully split a database. I now have a front and back end. They are linked fine. I've made modifications to forms, macros, queries, etc on the back end and they operate properly.

I now need a few new tables. I went into the back end and created the tables I need. I cannot find a way to link them to the front end. The link manager does not see the table I created in the back end and I even tried importing it into the front end but still, when I use the Link Manager, that table does not show up. Can someone please tell me the proper procedure for accomplishing this. I must be missing something.

Thanks

Mike

 

[genomon]

I've made modifications to forms, macros, queries, etc on the back end and they operate properly.

All these objects belong on the frontend.
Create the tables in the backend. Go to the frontend and click on "link tables". The backend tables are linked INTO the frontend, where all the reports, queries, forms, etc. are located; not the other way around.

"There is a very fine line between ‘hobby’ and ‘mental illness.’"

 

[JoeAtWork]

Remembering your past posts, I think you are talking about the Linked Table Manager. That wizard is for working with the tables you have already linked.

If you need to add some new linked tables, you can start the "New Table" function, and one of the choices is to "link". Just navigate to the backend database, then select the new tables you want to link.

 

[KenReay]

Or, see under file menu, file \ Get External Data \ Link

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[genomon]

No linked table manager; another way is to right-click in the database window (table tab) and click on "Get External Data"|"Link". Also remember, if you are linking with ODBC to SQL Server, etc., you will have to define a DSN.

"There is a very fine line between ‘hobby’ and ‘mental illness.’"