Export Access Structure only ?

  • Thread starter Thread starter olivier
  • Start date Start date
O

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
 
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
 
olivier said:
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 ?
Click to expand...

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

Tools - Database Utilities - Database Splitter.
 
Back
Top