Solved Updating Front End with New Tables (1 Viewer)

[silentwolf]

Hi again guys,

I have split the DB in Back End and Front End.
However when I do need to make some changes on the BackEnd new Tables how to I update it in the Front End?

I looked at the TableManager but the newly create Table is not showing what do I need to do?


Many thanks

Albert

 

[silentwolf]

Guys,
I got it!
Delete all Linked Tables and relink and it works.

Was just a little affraid of deleting it. )

All good

 

[jdraw]

??? Not sure I am following???
If you have added or changed tables in the Backend, you can reestablish/renew links from the front end by delete and relink. BUT, to use the table adjustments or new tables, you would have a need to modify the logic/processing in the front end as well. Perhaps that was part of your message.

 

[silentwolf]

Hi,
yes I had to add a new table in the backend.
Then I deleted all linked tables in the frontend and relinked the frontend with the backend tables.

As far es the Link in the frontend goes I had to pull the "new Table" into the databasewindow.

Is that ok? I hope so ..

 

[jdraw]

Right. But if it is a new table, how does your frontend use that new table?

 

[silentwolf]

Hi,

well I forgot a table which is linked to another table.
So I did enter that new Table in the Backend .. it is a lookup Table.

It seams to be working but I am not sure if there could be an issue?

Cheers

 

[Pat Hartman]

You don't need to delete existing tables to add a new table. Just link the new table using the New Data Source button rather than the Linked Table Manager.

When you make changes to a Jet or ACE BE the FE automatically picks up changes to existing tables. It does NOT automatically link new tables because it has no way to know if you want to link the table. Remember, multiple applications can be sharing the same BE. I'm not talking about multiple user's copies of the same FE. I'm talking about the OrderEntry application and the Purchasing application both sharing the same BE. Each app will need a different set of tables from the common BE.

 

[silentwolf]

Hi Pat,

Thanks
You mean with this Access Button shown in picture?

 

[Pat Hartman]

I can't tell. Try it. Your interface is different from mine.

 

[silentwolf]

Ok yes it is that one and I did try it works..)
Cheers!

 

[Pat Hartman]

Great

 

[silentwolf]

Yes indead lol