BE & FE Relations

[Ron]

You go into your BE and you normalize some tables that have been giving you
some problems with queries. Now how do you get those new tables to link with
your database? When you go into the database manager on your front end it
only allow you to select the tables you had before; not any of the new tables
you generated.

OK you do all of this normalization thru your front end and you are in the
same position only the tables you originally had can be linked. No problem
you can always go to your BE and link thru there. . . No you can't, the link
table manager is greyed out completely. So how do you get your newly
normalized tables so you can use them?? Its unfornuate that everybody isn't
knowledgeable enough to know they should have 3 normal normalized their
tables first.

 

[Jeanette Cunningham]

Ron,
You can do an import from the File menu, but instead of choosing import you
choose link instead. Complete the process and the front end will show those
tables in the front end as linked tables.

Jeanette Cunningham

 

[Jeff Boyce]

Ron

Are you saying you have new tables, or that you have (previously existing)
tables with new structure?

If the former, check Jeanette's response.

If the latter, you can use Tools | Database ... | Linked Table Manager. Put
a checkmark beside the tables you want re-linked. If you've moved the
back-end location, check the checkbox at the bottom of the window.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Amy Blankenship]

Ron

Are you saying you have new tables, or that you have (previously existing)
tables with new structure?

If the former, check Jeanette's response.

If the latter, you can use Tools | Database ... | Linked Table Manager.
Put
a checkmark beside the tables you want re-linked. If you've moved the
back-end location, check the checkbox at the bottom of the window.

My front end always just seems to "see" new fields when I add them to the
backend. I've never done anything special for this.

 

[Ron]

Yes Amy you will see new Fields within the structure of a Table, but you
won't see a new Table within your backend directly

 

[Ron]

I took one table and made two tables from it

 

[Ron]

That would probabley work except where do you find the File Menu in Access2007

 

[Amy Blankenship]

That would probabley work except where do you find the File Menu in
Access2007

I haven't installed 2007, but I think it's a big round windows logo in the
corner now.

 

[Tom Ventouris]

If you created new tables in the back end, you will need to import links to
the front end.- - A2007

1. Open the FE
2. Click on the External Data Tab
3. Select Access
4. You will have two options, to import or link.
5. Select "Link to the data source be creating a linked table"
6. Browse to the BE
7. Open it and select the new tables.
8. Click on Link/Import

Linked tables will be created in the FE.
They will be linked, but you will see the new tables in the Link list the
next time you run the Linked Table Manager.

 

[Larry Linson]

Yes Amy you will see new Fields within the structure
of a Table, but you won't see a new Table within
your backend directly

No, you didn't "see the Tables within the backend directly". You don't use
the Linked Table Manager to link to new tables, you use it to maintain the
links. You use File | Get External Data | Link, and Amy's correct, the
Access 2007 equivalent starts with the big round button up at the top left.

Larry Linson
Microsoft Office Access MVP