Can you open multiple databases in access

I didn't mean to copy the database, I meant open two instances of Access. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Related 1. Hot Network Questions.

In a single instance of Access, you can have only one database open at a time. In other words, you can't start Access, open one database, and then open another database without closing the first database. However, you can run multiple instances of Access at the same time, each with a database open in it. Each time you start Access, you open an instance of it.

So to open two Access databases at the same time, start Access and open the first Access database, then start Access again and open the second database in the second instance of the program. An alternative way to solve your initial problem, namely the copying of objects from one database to another is to use the import facility that you will find in the tab "External Data" which is divided into to sections, one having commands relating to imports and linking and the other to exports.

In the imports section click the "Access" icon an follow up with the wizard. Note that linking is optional. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Cannot open more than one ms access databases at the same time Ask Question. Asked 7 years, 10 months ago. Active 6 years, 1 month ago. Viewed 13k times. Improve this question. One Database vs. Multiple Databases. Import multiple worksheets into one table. PostgreSQL Database. PostgreSQL multiple databases. DB2 Database. MySQL Database. Multiple Databases or Single Database. Single stored procedure for multiple databases?

Data Scientist vs Software Engineer. The research path of clustering. How to reverse string using loop. Career Advice. Do you think a 50 year old male with no degree can still become a coder? A tool to try open-source projects quickly. Get Ahead by Going Headless. Achieving a true 3-Tiered Architecture through Load Balancing.

Follow us! Get the Latest Bytes Updates. By using this site, you agree to our Privacy Policy and Terms of Use.

Connecting multiple databases via a single control table deathnes 3 I have multiple access databases created using Access and I want to create a single control table with multiple buttons which will just start up different databases. This creates active links to them, where you can update, delete rows as you wish Apr 3 '13 reply deathnes 3 No, sorry, you misunderstood my question.

I am very inexperienced with writing programs but I guess it shouldn't be too hard Apr 3 '13 reply NeoPa 32, Expert Mod 16PB Perhaps you should consider rewording your question again, in such a way that misunderstanding what you are asking for is avoidable.

Apr 4 '13 reply deathnes 3 I am really sorry. Apr 4 '13 reply NeoPa 32, Expert Mod 16PB I'm still a little confused, but I certainly understand you're trying to make as good sense as possible so we're happy with that.