Solved Updating Front End with New Tables

[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

 

[silentwolf]

Hi Pat,

Thanks
You mean with this Access Button shown in picture?

 

[silentwolf]

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

 

[silentwolf]

Yes indead lol