• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Exporting Access 2003 db to new file

Expers,
I would like to export my Access 2003 DB to a blank 2003 database
0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
NeverReadInstructionsCommented:
Do you want to "export" tables, forms, queries, etc. or just tables?
0
 
RemRemRemCommented:
You'll have to do that a table or object at a time if you export. However, if you create a new blank database and choose INSERT: TABLE: IMPORT TABLE and then find the copy of your database, you can select all the objects and import them.

Do be aware that if you have hidden objects hidden, they won't show for import, so be sure to check the Show Hidden Objects option in your TOOLS: OPTIONS: VIEW tab.

Also know that you'll need to opt to import the import/export specifications and table data or structure only depending on what you need out of your import.

This will not work if you're drawing on an MDE file to begin with, as you will not be able to get the code segments of your DB imported.

-Rachel
0
 
Frank FreeseAuthor Commented:
all I have are tables - i resolved the problem by creating a blank db and importing everything into that db
0
 
Frank FreeseAuthor Commented:
thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now