copy an access database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Copy An Access Database

Copy An Access Database

resolvedResolved · Urgent Priority · Version 2007

Katrina has attended:
Access Introduction course
Access Intermediate course

Copy An Access Database

Hello. I created an Access database for the last financial year. I now need to duplicate this database for the new financial year. How can I do this?

I tried copy and paste, but it made some of my Reports and Queries buggy. Or should I copy and paste and just re-do my Queries from scratch?

Thank you

RE: Copy An Access Database

Hello Katrina,

Regarding a copy of your database. The easiest and safest way of creating a duplicate of your Access database, is to ensure you are not in Access, close the application down.
Locate the Database file you would like to copy in Windows Explorer and perform a regular Copy/Paste procedure.

Providing your database is not using linked files from external sources all content of the database will function exactly as the original.

I have never come across, or seen any forum postings of people having problems with a straight forward copy.

If this does not work, we'll need to look deeper into the structure and content of your original database.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: Copy An Access Database

Thank you. I think the problem may be linked to me changing the names of the Queries and Reports. They have titles ending 2012/2013 and I after I change them to 2013/2014, they don't want to cooperate. So I'll copy and paste as normal and re-do my Queries and Reports.

Thanks again

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.08 secs.