Access Solutions Archive

How to Back Up Your Split Database in MS Access

Posted November 17, 2017 By AuthorVS2

This article focuses on understanding the importance and use of Split database while also addressing steps to create its backups.

As the name suggests, split database is created by splitting two database files which are:

  • Back-End Database – consisting of data available in tables
  • Front -End Database – consisting of links connecting to all the tables present in the back-end database including forms, queries, reports etc.

Note that back end database consists of all the data in the system. Whereas all user interface data Objects like forms, reports etc. is stored in front end database. Front end database can be seen as the first layer of data, which is accessible to all. Anyone can go through the information available in the front end database. But the user needs to get an administrator permission to access the back end database. This split end division of database is what makes Access so secure and sound.Backing Up Your Split Database In MS Access

Since both these databases have different properties, their databases are also backed up independently. Front-end database consisting of minor form of data consumes less space, which takes less time in creating its database. However creating backups for back-end database can be a time consuming process. But as it contains all the data, it is important to generate regular backups for it to avoid incidents of corrupted Access databases.

Steps to create Backup for Back-end Database

Note: Make sure to notify all the users on the system about the backup on the back-end database. Running a backup requires an exclusive access to all the files of database, which disable users from using the database during the backup process.

Tip: Usually organizations run backups during holidays to ensure that the data remains undamaged and the work efficiency is also maintained.

  • BackUp DatabaseStep 1: Open Access without opening any database.
  • Step 2: Click on Open and select the database file you want to backup.
  • Step 3: Click on the arrow > next to Open > Select Open Exclusive.
  • Step 4: Click on the File Tab.
  • Step 5: Click on Save & Publish.
  • Step 6: Now go to ‘Save Database As’ section, right under ‘Advanced’ option and click on BackUp Database.
  • Step 7: Once the backup is created users can save the File.

Tip: Users can save the file with the original name and add backup in front of it, to help them easily identify the file in the future.

Steps to create Backup for Front-end Database

Since the front end database is accessible to most users in an organization, they all have a separate copy of that database. Users can customize and redesign their copy according to their liking. Note: each individual needs to generate backup for their front-end databases especially if they want to see their customized arbitrary design changes in their front end database.

Note: These changes made in the front-end database will only be visible to the user, making the changes as other users will have access to their own front-end database.

  • Step 1: Users can make design changes and other basic modification in the database.
  • Step 2: Once the user has saved all the necessary changes in his/her frontend database file, he/she can repeat the step mentioned above for creating database backup for back-end database to create a backup for their front end database.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair SQL Server and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment

This article addresses the importance and requirement of MS Access, as a development platform for enterprise-wide application.

Access is widely used by small to midsized companies as it is amongst the only few platforms which strive to fulfill all the needs of database managements. Not only does it act like a storage system, it also promotes easy accessibility and operation of data. Businesses can record everything from their client details, annual profits and expenses to employee attendance on an MS Access Database. It is however equally important to note that Access can be used as a versatile development platform for enterprises.Access Is Apt For Being Used As A Development Platform For Enterprise-Wide Applications

Why Access is Apt for being used as a Development platform for Enterprise-wide applications

Development Platform For Enterprise-Wide ApplicationsMS Access is often considered best suited for running departmental applications in an enterprise. It can be used to produce and distribute application, which needs to be sent through an organization. However the success rate of this endeavor completely depends on the organization. There is no limit or restriction on the number of users who can use and share multiple files using an Access application. The best part about the platform is that it doesn’t sabotage the performance of the system. Users are also allowed to insert as many as number records on each table without feeling any performance drop.

These numbers depend on various factors such as:

  • The existing traffic on the Network.
  • How much RAM Storage and the number of Processors, does the server has?
  • The current use of the server. (What application or the data is the server using?)
  • Different types of tasks take up different amount of performing capacity. Existing tasks performed by the users can also affect the performance and the storage speed of the database.
  • Where Access file and applications are being used (the workstation or the server)
  • What network operating system is being used in the place?

They key rule to work with MS Access is to understand how is works effectively and efficiently. Like any other application if a user commands multiple actions at a single time, the application will be subjected to perform poorly. However, Access has a rather strong tolerance level, and it can work smoothly despite being used frequently, with a heavy amount of storage in its database.

Users can avoid these types of performance issues by dividing data sharing units in different categories. We understand that this technique won’t work best with big organizations, but it’s a risk they should be able to take if they don’t want to switch to any other application.

Reasons for poor Performance in MS Access

Access applications which aren’t client/server based are more likely to deliver poor performance. Also, if more than 10 to 15 users consequently use this server, consisting of over 100,000 records it will only end in creating a slow processing unit. Note: these numbers are subject to vary depending on the factors listed above and what a user or an organization defines an acceptable performance. Some organizations strive to achieve smooth and speedy operation, which won’t be satisfied with the speed they will get while multitasking on this MS Access application. At times incidents of mdb corruption also come to notice.

However if a user wishes to go beyond prescribed limits, they should switch to a enterprise server database like Microsoft SQL Server – By doing so they will be able to create Access reports and forms on MS Access  while storing them on different queries and tables on the SQL database server.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including SQL Server repair and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment

How to Refresh Combo Box Contents in MS Access

Posted November 15, 2017 By AuthorVS2

In this article we teach our readers how they can efficiently refresh Combo Box Contents in an MS Access Database.

Creating or Editing a Combo Box Data is easy. Users just need to select Combo Box Tool from the Toolbox; choose all the required fields from the Query or Source Table available on the Wizard. Now the user just needs to get into the Property Sheet and he/she has the access to make any changes in the Combo Box.Refresh Combo Box Contents In MS Access

It is important for users to update code tables every now and then to ensure that their database works smoothly. For example, if a user selects a Combo Box, but is unable to locate the value that he/she is looking for in the database, they can set up a corresponding Combo Box to launch a different code table for the event. However, the only problem with this simple solution is that the user needs to refresh all the value left in the Combo Box code table screen.

Another instance which can turn this situation into a complex one is, if a database has more than one instances of combo box in a Form. It is likely that the contents of one combo box in that Form depends on the values of another combo box. In this situation if a user makes changes in one combo box, they will be reflected in the values of other combo box, which can potentially destroy the whole structure of the Form.

Steps to Refresh Combo Box Contents in MS Access

  • Combo BoxStep 1: Import tables consisting of the Combo Box contents into a current project.

(Categories, Products, Order Data)

  • Step 2: Now select Order Data Table, and open its Form from Insert Menu and then select Auto Form: Select Columnar from Wizard and press OK.
  • Step 3: Save the Form under Order Data.
  • Before making changing the form make sure to check all the contents on the new form. Now create a new Combo Box.
  • Step 4: Select design View in the View Menu, and make the desired changes in the Form.
  • Step 5: Now select all labels and controls except OrderID Label and Control, and drag them to create a new Combo Box under OrderID Field.
  • Step 6: Note: users can use View Menu to make their Toolbox visible.
  • Step 7: Now create another Combo Box under the name of ProductID, matching the size of the former ProductID Combo Box.
  • Step 8: Select these category table from the list and select Next.
  • Step 9: Click on Next >> again.
  • Step 10: Make sure to select the ‘Remember and save the values for future use’ on Control Menu and click on Finish.
  • Step 11: Open the Property Sheet on the combo box (View → Properties) and go to its property to change its name.
  • Step 12: User can now change the size of Label control, with the size of others Objects.
  • Step 13: Make the desired changes in the VBA Window and insert the new code of the update files.
  • Step 14: Open the Form and recheck the data. Select the New Combo Box that you have now updated in your Access Sheet.
  • Step 15: Users can check the list of products by selecting the Combo Box of the particular category.

Congratulation your Combo Box has now been refreshed.

At times while working on Access, you may end up with a corrupt accdb database. In such a scenario, it is prudent to opt for specialized recovery software like DataNumen Access Repair to assuredly get back all your valuable data.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf fix and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment