Copy Database with No Records (1 Viewer)

J

JCorreia

Registered User.

Local time

Today, 08:43

Joined

May 9, 2013

Messages

17

• Aug 6, 2013

• #1

Hi,
This summer I worked on a pretty extensive database for my internship and I'd like to be able to show recruiters the database as an example of my work (to get an interview, etc.). Of course, I can't just show them a copy of the database with all of the private information on it, so I'd like to be able to show them a copy of the database with no records. Is there a way to export/copy it so I can do this in Access 2007?
Thanks!

 

Trevor G

Registered User.

Local time

Today, 13:43

Joined

Oct 1, 2009

Messages

2,341

• Aug 6, 2013

• #2

Why not just copy the database and empty the tables of the data? You could also use some VBA code to empty the tables, here is an example of one line of code but you would then need to run this and add the additional lines for the other tables

DoCmd.RunSQL "DELETE * FROM TableName"

 

pr2-eugin

Super Moderator

Local time

Today, 13:43

Joined

Nov 30, 2011

Messages

8,494

• Aug 6, 2013

• #3

Hello JCorreia, Have you had a look into DoCmd.TransferDatabase method? There is a StructureOnly attribute, which you can use..

 

J

JCorreia

Registered User.

Local time

Today, 08:43

Joined

May 9, 2013

Messages

17

• Aug 6, 2013

• #4

Ah, of course Trevor, should have thought of that.
I keep forgetting KISS.
Thank you very much.

 

pr2-eugin

Super Moderator

Local time

Today, 13:43

Joined

Nov 30, 2011

Messages

8,494

• Aug 6, 2013

• #5

Trevor's method: Exporting Tables & Data-> Deleting Data -> (Essential) Compact & Repair
Paul's method: Exporting Table Structure -> (Optional) Compact & Repair

Which method is Keeping It Short? Nothing wrong following Trevor's method.. When you have some native function that can do everything in one go, why would you complicate things? It sure is your call at the end of the day, but just pointing out..