I want to Migrate Data from existing Access 2021 database to an updated version of the same Access 2021 database

Question

I want to Migrate Data from existing Access 2021 database to an updated version of the same Access 2021 database

Joseph Holland 0

This is the same database.

The new database is an updated version with new forms.

The database application stays the very same, i.e Access 2021

0 comments

4 answers

Your answer

Answer 1

Hi Joseph,

Since both databases were created with Access 2021 and the newer database primarily contains updated forms, could you please confirm whether the tables in the new database have the same names and field structures as those in your existing database?

If the table structures have remained the same, you may be able to import the data directly. To do this, open the new database and navigate to External Data > New Data Source > From Database > Access, then select the existing database. Access can import tables and other database objects from another Access database.

That said, if the new database already contains empty tables with the same names, importing the data directly will create additional copies of those tables rather than populate the existing ones. In that situation, a safer approach would be to import the data into temporary tables first and then use append queries to transfer the records into the appropriate tables.

Before making any changes, I strongly recommend creating backup copies of both databases so you can restore them if needed.

For additional guidance, you may find the following Microsoft resources helpful:

I hope this information helps. If you have any further questions or need help with anything else, please don't hesitate to reach out again.

I'm looking forward to hearing from you.

Kind regards,

Joseph Holland 0 Reputation points

2026-09-21T17:23:58.6+00:00

The TABLES and QUERIES do NOT change.

Answer 2

George Hepworth 23,130 Volunteer Moderator

Can you be more specific about the reason for your concern?

On the surface, it should be really simple, so there must be something more behind your question.
Let's start with the basic question. Is the database properly split into Front End and Back End?

If it is, it should be a straightforward as linking the new front end to the current Back End.

What else is involved that hasn't yet been mentioned?

Joseph Holland 0 Reputation points

2026-09-22T10:41:24.2+00:00

"Is the database properly split into Front End and Back End?"

No and I am not going to the trouble of doing this, this Database is only designed for one standalone user.

There is no need for further investigation on this problem.

My own solution is to EXPORT THAT PARTICULAR form to the older database, from the new database which has been downloaded and keep on using the old database.

It's simply not worth the effort to split the database into a front and back end:

This database is not commercial software. It is a database designed as a hobby!
Killian N 4,410 Reputation points Independent Advisor

2026-09-22T16:03:59.9866667+00:00

Hi Joseph

Thank you for taking the time to explain your situation and share the solution you've chosen. For a single-user hobby database, it's perfectly reasonable to look for the simplest and most practical approach. Not every database project requires the same level of complexity, especially when it's being maintained for personal use.

It's good to hear that you've found a method that works for you by exporting the updated form into your existing database and continuing to use your current data file. Ultimately, the best solution is often the one that meets your requirements with the least disruption.

I appreciate and thank you as well for sharing your workaround, as it may be useful to other community members who have a similar standalone Access database and only need to transfer form changes between versions.

I wish you the best with your project, and I'm glad you've been able to move forward with a solution that suits your needs.

Kind regards,

Answer 3

George Hepworth 23,130 Volunteer Moderator

Interestingly enough, if you HAD properly split this database prior to creating a new form in another copy, which forced the import of a form, you have had to do nothing. The new form would have been in the front end all along.

0 comments

Answer 4

Hi @Joseph Holland

This happens because startup options and form properties are stored inside the database file itself, not in Access 2021.

Your old database had:

A startup form configured

Possibly Navigation Pane hidden

Maybe AllowDesignChanges = No

Maybe Default View = Form View on forms

Your new database version may have:

No startup form set

A form whose Default View is set to Design View

A missing AutoExec macro

A bypassed startup (SHIFT key)

A different Access Options configuration inside the file

So Access 2021 is behaving normally — the new database simply doesn’t have the same startup configuration as the old one.This happens because startup options and form properties are stored inside the database file itself, not in Access 2021.