Importing / New DB

[MS]

Hey Guys,

I have a database that I am working with, with alot of
data added. Now I want to replicate the same database,
without any data. How is this possible ?
I tried to create a new database and import tables, but I
have usesr permisson errors, prompting me to call the
system admin. I am the creator, and have all the passwords.
What can I do ?

Thanks.
..

 

[Eric Butts]

Hi,

Assuming you can get past your error which indicates User Level permissions
(you setup security on the database right?) you can click on the Options
button under Import objects and select under Import Tables choose
"Definition Only". Example:

- Create blank database file
- Click File > Get External Data > Import
- Select your database file and click Import
- In the Import Objects box select the Options button
- Under Import Tables choose "Definition Only" and click OK



I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support