How To Unsplit MS Access Database?

In the previous posts we have discussed about How to Split Access Database into Front-End and Back-End. But in today’s topic we will discuss about the how to unsplit Access Database. So, just scroll down to this post and check out the complete ways to perform this unspliting of the Access Database without any trouble.

Practical Scenario:

Accidentally split the database using Access Database instead of SQL Server. Unfortunately, a backup was not done before the split and there are several program changes since last backup with a different file name.

I need to run the front end on three computers and the back end on one. If I try and access the _be from more than on computer I get a “file _be.accdb already in use” Is there a way to go back to the original or change to the SQL server with the split I have already done?

SOURCE: https://answers.microsoft.com/en-us/office/forum/office_2007-access/how-to-do-you-unsplit-a-database/9e863ae6-1e63-4df0-a83d-b85e8dac006e

If you are also willing for merging the front-end and back-end of access database, then go down to this post. But before that take a quick review over the Splitting Of Access Database.

Short Intro For Split Access Database:

Access Database can be split into either a front-end application or a back-end application. After this splitting procedure, back-end database contains tables and it gets stored on file server.  Whereas, the front-end database links contains all the forms, queries, reports, macros, and modules. This front-end split section is distributed to the workstations of the users.

Reasons For Spliting The Access Database

Here are the typical reasons for splitting the Access Database:

• To share your Access database with multiple users over the network.
• If you have numbers of users working on the same database and you haven’t installed Microsoft Visual Source Safe.
• When you don’t want the any of your users make design changes to tables.

Advantages Of Splitting Database:

By splitting the database, each individual user has their own copy of form, reports, macros, queries. Hence, the only data that must send across the network is data in tables. So, you need not to worry about any much trouble in your database.

you can also  check out our blog on how to split the access database into front and back-end , to get easy idea on splitting of your Access database. 

But what if you need to unsplit Access Database. Well if you don’t have any idea regarding such then this blog will surely gone help you. As, this article describes how to unsplit Access database manually.

How To ‘Unsplit’ The Access Database Manually?

Well its quiet easy to unsplit Access database. For this just follow down below mentioned steps.

Way 1#First of all open the back end (mdb with = the tables) and from the front end import all the objects. If in your front-end there is no table then it indicates there is no database relationship between form, queries, modules etc. and if there is no such relationship then you don’t need to do anything.

Way 2# Second option is, to import the tables from the back-end into front end. While doing so, make sure you have opened up your ‘advanced’ tab when you select the tables and make a check over the “”relationships”” box. Also ensure that you have imported all the tables.

But if you have tables in the Front End, you are importing it into the backend. Again make sure have get all the tables and check the Relationship box.

 DON’T MISS IT:

How To Convert OR Migrate An Access Database To SQL Server

So, all an all it’s very easy to work with a split database. The only difference is that you need to open the back-end file to make design changes to the tables. And also you need to maintain the links to the tables.

Risks Associated With Unspliting Of Access Database

• Chances of Corruption gets higher:

Well splitting is the best ways to avoid Access databases corruption. as  split database are less prone to corruption. But after your unspliting Access database this risk gets higher.

• User interface is get tricky to modify:

Because when your database is splitted, testing and implementing like modification in the front end can occur with almost no disruption to users.  But after unspliting it all these tasks gets messy.

• Your Data Is Not Safe Anymore

Actually backend helps in protecting off your database design. And this unable user to directly access the tables via the interface objects in the front end.  After unspliting MS Access database any of your users can alter or delete tables.

So, unspliting the Access database has negative impact. It will be better to split the database. Perhaps, the biggest advantage of splitting the Access Database is convenient supply of data over network or on the cloud via Access Hosting.

How To Recover Data From Corrupt Access Database ?

If after unspliting Access database somehow your database gets corrupted then in that case what will you do?

 Well still there is an option so no need to panic…! That option is Access Repair And Recovery Tool for advanced troubleshooting and solutions of MS Access Database issue.  It is most accepted option to repair corrupted/damaged .accdb and .mdb files, restore each and every data and such as queries, macros, reports, table, forms, etc. Apart from that it is the best suited option to fix any kind of error occurred in your Access database.

Conclusion:

Above post must have helped you in exploring your knowledge on how to unsplit Access database. So, do try all the aforementioned steps.