Recombine the split database

[hfsitumo2001]

I want modify my database that is already go live. What is the best way to recombine the split database, because I want to change the structure to have a table for A company name, and also I want to make it a multi languages.

Thank you,

Frank

 

[CJ_London]

Why do you need to recombine? Just take a copy of the BE an connect your development FE to that

 

[The_Doc_Man]

In theory, from the ribbon you can use the External Data tools to copy "stuff" from one database file to another easily. So there is where you would find the controls to copy stuff from point A to point B. Having said that, ...

Recombining a split database is certainly possible, but pretty much NEVER as efficient if you planned to have multiple users sharing it. The split isn't done for ease of development. It is done to minimize problems caused by file locking and attempting to share something that will be keeping LOTS of file locks open while in use. Reverting to a monolithic database INCREASES the odds that two people who inadvertently try to use the same form on the same record at the same time would crash you with an "unrecognizable database format" error. (Trust me, you REALLY don't want that to happen.)

 

[hfsitumo2001]

Yes but if there is a significant change in table and relationship, don't you think we should combine first then we revisit our design?

Thank you

Frank

 

[CJ_London]

Tables and relationships are all the back end. Unless you are into using ddl they cannot be managed from the front end.

combine them if you want but as a seasoned developer, once the app has gone live I would not recombine.

how to combine - create a new db and import all tables from the back end, then import all queries, forms, reports and modules from the front end