add table to split database not shows up?!!

[siamandm]

Hi
i have a split database , i have added a table to the backend , and when i go to the front end and go to external data-->Linked table manager and choose the file which the table has been added but its not showing the new table to be add to my front end why is that please?

[HansV]

Have you tried closing and reopening the frontend?

[siamandm]

yes :(

[HansV]

And you can see the table when you open the backend?

[siamandm]

no still i can't see it ... even in the link manager dialog box i can't see the new table

[HansV]

Could you do the following?
- Create a copy of the backend database.
- Delete all tables from the copy except for the new table.
- If you had already entered records in the new table, you can delete them, so that the table is empty.
- Select Database Tools > Compact and Repair Database.
- Close the copy.
- Zip it.
- Attach the zip file to a reply.

[siamandm]

Hello
the link is here https://www.dropbox.com/s/z1oodqie51amq ... e.zip?dl=0" onclick="window.open(this.href);return false;

[HansV]

You have set a password on the zip file...

Added: got it, thanks.

[siamandm]

the password is : hans

[HansV]

I opened the backend, and I saw one table that has been added today: tblHLeave. I assume that is the one you meant.

Next, I opened the frontend, and did the following:
- Activate the External Data tab of the ribbon.
- Click Access in the Import & Link group.
- Click Browse...
- Select the backend database.
- Click Open.
- Select 'Link to the data source by creating a linked table'.
- Click OK.
- I see tblHLeave in the list:

S137.png

- I select this table and click OK.
- It appears in the list of tables:

S138.png

Could you try these steps again in your own database?

[siamandm]

i cant see the access button in the import and link group area?!!!

Capture.PNG

[siamandm]

sorry now i found it ..... in the new data source ....

[siamandm]

but its a pear like a local table ?!!!!

Capture.PNG

[HansV]

In your Access window, the data sources are collapsed into a single 'New Data Source' button, as you have found.

The 'Linked Table Manager' only shows tables that have already been linked. You cannot use it to create a new linked table.

[HansV]

Did you select 'Link to the data source by creating a linked table' in the Get External Data dialog? If you don't, you will import the table instead of creating a linked table.

[siamandm]

thanks a lot now is working as expected.

[siamandm]

my issue seems to never end....now there is no relationship between the new table and the main table which I created in the backend database...
i tried to create the link in the front end .. but its not allow me :(

[HansV]

Open the frontend.
Click Database Tools > Relationships.
Click Show Table.
Select tblHLeave and click Add, then click Close.
You should see that tblHLeave is already joined to Contacts on the ID field.

[siamandm]

thanks a lot , I found the issue was from the front end , i tried another version now i can see the relationship

thank again