Share via

Copying an Access database without it affecting the original

Anonymous
2018-01-17T15:52:26+00:00

Hi all!

So I have taken over a database from someone who makes things a bit more complex than they need to be and I have tried to copy the database with the format and data but when I edit the data in the new database it also changes it in the original. I have tried several different ways but no luck. Any suggestions?

Thanks in advance!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2018-01-17T16:27:59+00:00

    I would guess that the database is split into a backend and frontend and you are copying only the frontend.

    If that's the case, you'll need to make a copy of the backend as well to use as a development copy.  Then re-link your frontend copy to it as a development frontend.

    Was this answer helpful?

    0 comments No comments