how do i create a new access database using the same fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could you please advise me of how to create a new database using the same
fields as a previous database without having to type all the fields in again.
 
Could you please advise me of how to create a new database using the same
fields as a previous database without having to type all the fields in again.
Click to expand...

Create a new blank database.
Click on File + Get External Data + Import.
Navigate to the database that has the table you want to copy.
Click on the Tables tab and select the table you want. Click on the
Option button. Select Definition Only.
Click OK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I concatenates two fields into one field in the same table? 3
Access Skip address field if previous field is blank 2
Adding a new field to a form in Access 2002 3
Access Microsoft access database(creating a search engine form) 0
Access 2007 Previous Record 8
Converting Access 97 to Acees 2003 & get conversion Errors 1
How do I change my database icon? 2
How do I store which user modified a record in Access 2007? 5

Back
Top