unsplit database

[rgreene]

I used the database splitter to split my database but now I need to do some testing on it and I don't want to use the REAL thing. So I copied the database but I'm still linked to the REAL data. How do I "unsplit" or bring everything back into 1 database?

Thanks,
Rick

 

[doss]

Hello.

You can make a copy of your backend, and put it on your desktop and name it so that you know it's the testing copy.

Then open up the copy of the front end where it shows the database window. Go to tools and select Linked Table Manager. Check the box for prompt for new location and check all the tables listed. then say okay.

It will then promt you to select the new location of the tables to be linked. Click on your backend copy.

I think that should pretty much be it..... Hope that helps.

 

[hi there]

i recently came into the same situation described in this thread. i have a follow up question to this. is there any way to get both the FE and BE into a single application (unsplit)? so basically i'll only have one .MDB file?

thanks for any suggestions everyone.

 

[rgreene]

I just ended up copying and pasting all my query's, forms, reports, etc.. into the proper areas in the BE database. Then I renamed it to mdb. Everything seems OK. Not exactly what I wanted to do but it was the only thing I could think of to accomplish what I wanted.

 

[hi there]

yeah i was thinking along the same lines. importing the tables into the FE might also be another option. either way i have to make sure all my ControlSources for forms, queries, and reports are properly set.

thanks for the response rgreene. it was helpful.

 

[ChrisO]

Another thing to consider is where the Table relationships are FE or BE. I think they should be in the BE, I've never tried them in the FE, so it might be easer in the long run to import everything to the BE.

Regards
Chris

 

[hi there]

Thanks everyone.

 

[Acme]

After reading, it sounds like once you split a database, the best practice is to create a copy of each for staging and remap them, but in the end, there is no real need to unsplit the fe and be once split, unless you plan on distributing the application that way to begin with. Is that right?

 

[psyc0tic1]

Isn't it easier to right-click on the linked tables and choose to convert it to a local table?

I have done that plenty of times for testing.

 

[gemma-the-husky]

Once you have a split database, I can see no good reason to re-combine it. There are a few things that work differently in split and non-split databases, which is another reason to be consistent.

 

[bastanu]

Please feel free to download and use my free FUZE utility (http://forestbyte.com/ms-access-utilities/fba-fuze/) that does just that.

Cheers,
Vlad

 

[plog]

Ahhhhhhhh, its the thread that won't die.

Talk to you all in October 2020.

 

[isladogs]

Once you have a split database, I can see no good reason to re-combine it. There are a few things that work differently in split and non-split databases, which is another reason to be consistent.

The only time I ever do this is to create a working DEMO version of my split databases in order for potential customers to 'try before they buy'.
When I do so, I right click and convert to local table as suggested by psycotic1

EDIT: sorry plog. Didn't read your contribution before posting. It was too recent!

 

[Mark_]

Ahhhhhhhh, its the thread that won't die.

Thread necromancy... Latest trend in bringing the dead back!!!

 

[The_Doc_Man]

Is that art from the cover or an illustration in some novel?

Or is it perhaps an MTG card about raising the dead from the graveyard to some other specified place?

 

[Mark_]

Nope... Google images, grab the first one that looked obviously "Undead" related, and I figured a necromancer dancing with a zombie fit well with tendency for some to bring long dead threads back!

 

[mloucel]

I don't know why you would want to but the easiest way to get the db back together again is to delete the links to the be tables and then use the file/get external data to import them.

HA.. you're a genius Pat, I just did it and it worked, now I have 2 copies, my screwup test all copy, and my splatted, when I update a form a query, etc, I do it in my screwup copy, once it works, I go to the split, import the updated modules, and voila, problem solved.

Thanks, for the lesson.

 

[isladogs]

If you ever need to do this again, I recommend an even easier method of unsplitting (aka splatting) mentioned earlier in this old thread.
Right click on each of the linked tables and select Convert to Local Table. If you have a lot of linked tables, you can loop through and convert using VBA.

 

[mloucel]

If you ever need to do this again, I recommend an even easier method of unsplitting (aka splatting) mentioned earlier in this old thread.
Right click on each of the linked tables and select Convert to Local Table. If you have a lot of linked tables, you can loop through and convert using VBA.

Holy CRACK Colin, it's been there all the time, and I have never seen it, darn, no wonder you are an MVP / VIP or should I say MID {Most Important Developer}
that is the easiest.

 

[plog]

Dang it. Missed it by 4 years.