Will Access database files/forms transfer from one computer to another and function properly?

Question

I am taking over a business that uses Microsoft Access with some customized forms, but I am not buying their computer. Will their database with their custom forms work on a newly downloaded version of Access? I have never used access before so not sure how databases conform from one computer to another. Thank you for any advice you can give!

Answer 1

They just have a single user.

Even in a single user environment I would strongly recommend that the database be split into front and back ends. By isolating the tables containing the data from the interface, in the event of the latter becoming corrupted, which is not uncommon, the data will be preserved intact. All that is necessary is to replace the corrupted front end with a clean copy made form a 'master' copy kept in a secure location. For further details see the following link:

https://support.microsoft.com/en-gb/office/split-an-access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

Another advantage of splitting the file is that it makes it very easy to make regular backups of the data from within the front end. For an illustration see BackupDemo.zip in my Dropbox public databases folder at:

https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0

Answer 2

Thank you, Scott. They just have a single user.

Answer 3

In addition to George's comments. You need to know whether the database is split, whether it was shared on a network, whether it had multiple back ends.

Also to understand Access files are a container for various objects. Tables, forms, reports, queries and programming code modules are all objects within an Access file. In addition, Access can use multiple files to store data. For example I do free lance work for a company that has 4 different Access apps, to help they run their business. Most of the apps use data common to them So I have one back end file that contains that common data.

Answer 4

I appreciate the great feedback and gives me a place to start. Thank you!

Answer 5

The short answer is yes, it should transfer, with some qualifications.

The long answer is that it requires more information.

It might depend to some extent, on which version of Windows you have installed on your computer. Generally not a significant factor, but if your version of Windows is much newer, or older, it might make some difference at the margins.

It does depends, in part, on which version of Access the previous owner has and which version you install.

It also depends, in part, on whether you install the same bitness of Office/Accessas the previous owner. If that owner had 32 bit Access, you should also install 32 bit Access/Office. Or, if you want to install 64 bit Access, then you will probably have to make modifications in the VBA to accommodate that change.

It also depends on whether the Access database has customization that depend on third-party code libraries. Chances are that it doesn't, but if it was created for the previous owner by a professional developer, then there could be such features included.

If you've never used Access before, you should start with a serious grounding in how to use a relational database in general, and Access in particular. Again, chances are good that the Access database will continue to operate effectively. Trouble-shooting problems, though, requires more than a superficial knowledge.