copying/pasting/transferring?

[Kevin]

I'm in the process of creating a new database and want to pull in the
contents of an existing database rather than building on the existing one.
The existing is not very large, however I would like to pull in all it's
tables and data, queries, forms, reports and all associated programming.
Both databases will be Access 2002. I am more than doubling the size and
have had some user level security issues which is why I'm leaning toward
creating new and eliminating any user level security.

Is there a preferred way of doing this easily and safely? Am I thinking
correctly in my approach? Any suggestions are appreciated!

 

[NetworkTrade]

I would simply do the right-click & copy the entire db....give it a new
name...and then modify from there.

Starting a virgin db and then copying/importing in every/each object
one-by-one seems like it would be alot of time without any additional
benefit...plus you would have to recreate all the relationships and any
custom programming....

 

[Rick Brandt]

I would simply do the right-click & copy the entire db....give it a
new name...and then modify from there.

Starting a virgin db and then copying/importing in every/each object
one-by-one seems like it would be alot of time without any additional
benefit...plus you would have to recreate all the relationships and
any custom programming....

What makes you think the import would have to be "one by one"? Plus an import
would include all programming and relationships so I don't understand those
comments either.

If he wants to eliminate security then copying the file doesn't accomplish that
whereas importing will.