Split database new tables

[Guest]

Hi Everyone:
I have a split database. I added a new table, but I cannot link the table
to the front end. Is there a method to follow? I did try to re-link with the
Link Table Manager, but it doesn't pick up the new table.

Any advise would be appreciated.
Sophia

 

[tina]

try linking it manually the first time. from the database window, on the
menu bar, click on File | Get External Data | Link

hth

 

[Guest]

Thank you Tina!! I have been looking for a solution for a long time. Your
solution worked perfectly.
Sophia

 

[Guest]

Oops! I just noticed a problem with the two new tables that I linked from
the BE to the FE. In the FE, the subdatasheet is not linked, whereas it is
in the BE. The relationship exists. Any suggestions?
Sophia

 

[John Vinson]

In the FE, the subdatasheet is not linked, whereas it is
in the BE. The relationship exists. Any suggestions?

I'd suggest not using either datasheets or subdatasheets for user
interaction at all... use Forms (with subforms) instead.

John W. Vinson[MVP]

 

[Guest]

John: What is the reason for not using subdatasheets? Does it slow the DB
down?
Sophia

 

[Jeff Boyce]

Sophia (and John)

Pardon my instrusion...

Access tables store data, Access forms display data (for add/edit/...).

If you or your users are working directly in the tables, someone might
mistake it for a spreadsheet and attempt to do things that would not be wise
(or even possible, if you were using a form to better manage user
interaction with the data).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

John: What is the reason for not using subdatasheets? Does it slow the DB
down?

Yes, often drastically. I also emphatically agree with Jeff's
criticism of the use of table datasheets for editing; they are NOT
designed nor are they appropriate for that purpose. Forms are much
more flexible, can be made much more user-friendly, and they are much
safer.

John W. Vinson[MVP]

 

[Guest]

Thanks for your comments. I was not using the table for editing or data
entry. It is just that I find it easier to look at the table and it's
subdatasheet to see if the correct data is being gathered or to check
relationship issues before I create a query, forms and reports. I'm in the
process of adding new tables (data) to my db and I am trying to relate it to
previous tables (data) already collected.

It still leaves the unresolved issue about why the BE shows the
subdatasheet, whereas the FE doesn't. But I guess it doesn't matter, or does
it?
Sophia