Can't see table created in front end of database. How do I get it to appear?

[ayupchap]

Hi all,



So I needed to create a new table in a split database. That went fine but when I go to the front end I can not see it in the list or refer to it in anyway. How do I get it to appear?


Thanks for all your help

Scott

[June7]

Must set a link to the table. Can use the Linked Tables Manager.

If you intend to install the frontend on multiple user machines on your network, suggest you use UNC pathing.

[burrina]

Did you create it in the front end or back end? It needs to be in the front end! And of course is it hidden? Of course if this is another linked table, as has been suggested, you will have to use the Link Table Manager. Unless this table needs to be in the front end, then of course each copy will have to be updated as well.


HTH

[ayupchap]

OK so I did create it in the back end thinking that this was correct as that is where all my other tables are but this is not correct? If this is incorrect and doing it in the front end is right how do I ensure all the data is kept in the same database as I have made a multi-user database and reports are generated from the back end? Is this what June7 was saying about UNC pathing? I have never heard of that before?

[ranman256]

In the front end, you have link it in from the backend.mdb.

[ayupchap]

OK great so I made that now but unsure how to link it in from the backend? Can anyone be kind enough to give me some steps to allow me to do this?

[byterbit]

In Access 2003 it will be:
(from the front end)
1) files
2) get external data
3) link tables
4) browse to the MDB file with the data
5 ) highlight the table

In '07 and '10 the menus will look different ( why, Microsoft ?) but the essential process is the same

[June7]

Backend contains tables to hold data for permanent storage that must be shared by multiple users. This file resides on a network server.

Frontend links to backend tables. Frontend has queries, forms, reports, code. A copy of the frontend is installed on each user workstation.

Use the Linked Table Manager to establish links with backend tables. The Manager will link with drive letter pathing, example - R:\somepath\accessdb.accdb

Drive letter pathing requires every user to have the same drive mapped by Windows on their computer - as per the example, every user must have R:\ drive mapped. If user deletes this mapped drive then Access cannot find the backend.

Alternative to static drive path linking is UNC (Universal Naming Convention) pathing. This path link references the file server by its name, no Windows drive mapping is necessary. The path structure is like:

\\servername\folderpath\accessdb.accdb

I use VBA to manage linking with UNC, never figured out how to do it through the Manager, if it is even possible. Review http://forums.aspfree.com/microsoft-...ue-323364.html

[ayupchap]

Oh this is great thanks so much! I have just worked this all out now. Thanks so much for all of your help!