New front-end & back-end table link

[cstanley]

Hello all,

There is a lot of info about the database splitting process, for which I am duly thankful as I am about to take the plunge. However, I can't seem to find the answer to a simple question - if I (as the developer) want to add a new table or modify the structure of an existing table, how do I do this in the front end and have it cascade back into the back end?


Thanks!


Chris

 

[jeremie_ingram]

When you spilt the database you essientially create two databases from the one. Open up the BE as any other database, and you can make all of the modifications you want.

 

[cstanley]

Tried that... but how do you get it back into the FE and then link the two? The linked table manager only lists the tables that were in the original split...

 

[jeremie_ingram]

You can always add a linked table to a database, even if its a FE/BE situation. Add any new table to the back end, then in your FE go to the TABLE selection window. You should see all of the linked tables in there, now select NEW and then LINKED TABLE.

Once you add the link, you cam manipulate it through the LINKED TABLE MANAGER.

Like I said, using the splitter only creates two seperate databases that have all the links set up for you. Besides that, they are not any different that any other database and can be manipulated in the same manner as any other MDB.

 

[Cosmos75]

You can always add a linked table to a database, even if its a FE/BE situation. Add any new table to the back end, then in your FE go to the TABLE selection window. You should see all of the linked tables in there, now select NEW and then LINKED TABLE.

Once you add the link, you cam manipulate it through the LINKED TABLE MANAGER.

This only applies for a FE that is an MDB and not an MDE file, right?