New Database table in a split database

[Peter]

I have a split database but after talking to the users they want an extra
table added. Is it possible to add an extra table to the be and then link it
to the fe? If so how?

Thanks

 

[bcap]

PLEASE PLEASE PLEASE can people say what version! Although it's the same in
principle in Access 2007 and earlier versions, the user interface is quite
different, so the question has to be answered twice!

1. Either version: open the back-end database and create the table.

2(a) Access 2003 + earlier: open the front-end database to the database
window. Click Tables->New. Choose "Link Table". Navigate to the back-end
database and click OK. Find the new table in the list, click on it, and
click OK.

2(b) Access 2007: open the front-end database to the Ribbon, External Data
tab. In the Import group, click "Access". Use the Browse button to
navigate to the back-end database. Click the bottom radio button "Link to
the data source etc". Click OK. Find the new table in the list, click on
it, and click OK.

 

[Golfinray]

Go to file/get external data/link table and give it the location of the file.
It should link it for you.

 

[Peter Hibbs]

Peter,

If you want some code to add new fields, tables, relationships, etc,
etc to the back-end file then have a look at :-
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=185

Note that I am currently modifying the code to allow Rich Text,
Hyperlink and Attachments type fields to be added as well but the
current version will probably do what you want.

HTH

Peter Hibbs.

 

[Jeff Boyce]

It isn't clear from your description what the rationale is for "an extra
table"...

Given that Access is a relational database, and that "normalization" and
"relational database design" are not exactly common knowledge and talents,
it may be that your users are trying to dictate a "solution in search of a
problem."

What will having the new table allow them to do? And are they actually
working directly in the tables?!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Peter]

Dear Folk,
Thanks for your answers. I tried out the advice from
Goalfinray and it works well.

Thanks too Peter for your suggestion. Being a relatively new learner I am
not much with code. I would like to learn more about it but time is a
problem. Code would certainly make my database more flexibe and speedier.

Thanks too Jeff for your question. Being new at this I don't always know
what information to put in my questions. No they are not working directly in
the tables as I have hidden the database window. We are an agribusiness and
we need to keep records of the Lot and Plan numbers of our Customers'
properties cattle and sheep). If they only had one record each then I would
just add an extra field to the existing Customers table. However some
customers have multiple properties so I wanted to create an extra table
"Property Information" linked to the Customers table to store these records.
Through a form they will be able to enter and look up this information. I
will also make a couple of queries so that they can search by custome name or
property name for the information.

Thanks for your help fellows.

Peter