New table to a Back End??

[Guest]

I have a database that has a backend and all the queries, forms ect in and
front end. I have to add a table to this DB and I can't see a way to make it
a linked table like the others. I tried just creating it in the BE and
creating a query but it does not show on the list of tables I can choose.
Any thoughts on how to accomplish this?
Thanks

 

[Albert D. Kallal]

anytime you add a table to the back end, you the in the front end
go:

simply go to the tables tab, and go new table.

The choices are:

Datasheet view
Design view
Table wizard
Import table
Link Table

Since you want to link to the back end, choose the Link table option..and
browse to your back end.....

 

[Douglas J. Steele]

You need to go through File | Get External Data | Link Tables on the menu
(from within the FE, of course)

 

[Guest]

I did a little more searching and found another question exactly like mine.
The solution of File-Get External Data-Link Tables worked fine.

 

[Guest]

You were on the right track!

1- Create the table in the back-end (save/close)
2- Open the front-end and linked the table
File-Get External Data-Link tables
Browse to your back-end and select the new table.

it should then appear in your listing and be accessable to use in forms,
queries...

 

[Todos Menos [MSFT]]

in an ADP you make a table in the backend and it auto-magically shows
up on the frontends





much simpler idea than this MDB _BULLSHIT_

I have a database that has a backend and all the queries, forms ect in and
front end. I have to add a table to this DB and I can't see a way to make it
a linked table like the others. I tried just creating it in the BE and
creating a query but it does not show on the list of tables I can choose.
Any thoughts on how to accomplish this?
Thanks

in an

 

[Tony Toews [MVP]]

Text that A a r o n K e m p f wrote snipped.

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm