Export Access Structure only ?

[olivier]

Hello,
I want to give a friend my small Access database structure on a floppy. I do
not want give him data. Is there a way to export/copy my access database
structure only ?
Thanks in advance.
Olivier

 

[Ed Warren]

Easy answer

1. Make a copy of your database
2. Open each table in the copy. Then select all records then delete. (if
related, then gotta do it in the right order)
3. Then compact and repair the copy.
Now you have a clean copy.

Little harder.

1. Make a copy of your database
2. Open the copy
3. For each table right click and select copy, structure only, then save
copy as (table)_1
4. Go back and delete all the orginial tables
5. Rename the copies from (table)_1 to (table).

Hope this helps,

Ed Warren

 

[Jim/Chris]

In a macro
Transfer database
In the action arguments "Structure Only" put Yes

Jim

 

[rkc]

Hello,
I want to give a friend my small Access database structure on a floppy. I do
not want give him data. Is there a way to export/copy my access database
structure only ?

Split your database into frontend backend and send your friend a copy of
the front end.

Tools - Database Utilities - Database Splitter.