People How Can I drop all my tables in a ACCDE file?

I want to clear all my record in my DB tables. (Start like New DB)

Thanks for helps

Normally the ACCDE will be a front end. You can just swicth to a new blank back end. ACCDEs normally do not have any data.

If you do not have a blank back end, You could create a new blank database and import all the tables with no data.

Also see:
Sharing an Access Database (http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1264601&Zf=f53&Zw=sharing&Zg=0&Zl=a&Main=1264601&Search=true&where=&Zu=&Zd=l&Zn=&Zt=2&Zs=a&Zy=#Post1264601&Zp=)

See the next post

Normally the ACCDE will be a front end. You can just swicth to a new blank back end. ACCDEs normally do not have any data.

If you do not have a blank back end, You could create a new blank database and import all the tables with no data.

Also see:
Sharing an Access Database (http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1264601&Zf=f53&Zw=sharing&Zg=0&Zl=a&Main=1264601&Search=true&where=&Zu=&Zd=l&Zn=&Zt=2&Zs=a&Zy=#Post1264601&Zp=)

OK But How Can I see all the schema of the DB?

My ACCDE have a front end and I have all my tables linked to that ACCDE. I need to drop all the linked tables.
I can open the linked tables and see the data on the table. When I delete the data I see the next record follow the same sequence like the old. Its like continue secuence.
Example: If I add a new record before delete all Its suppost to be record #1 and appear record#233
Thanks for help

Example: If I add a new record before delete all Its suppost to be record #1 and appear record#233


Assuming you are using Autonumber fields:

After you delete all the data, you need to compact the database to rest the Autonumber counters.

resetting autonumbers to start at 1 is done by compacting, but shouldnt matter for an autonumber - dont even think about trying to make sure an autonumber sequence is maintained intact - that not what its for, and you wont do it

if you really want to drop all the linked tables the pseudocode is only a few lines, and is something like

for each table in tabledefs collection
if table is attached (ie not local) then drop the table
next

i am not in front of access, so i cant verify the exact syntax

resetting autonumbers to start at 1 is done by compacting, but shouldnt matter for an autonumber - dont even think about trying to make sure an autonumber sequence is maintained intact - that not what its for, and you wont do it

if you really want to drop all the linked tables the pseudocode is only a few lines, and is something like

for each table in tabledefs collection
if table is attached (ie not local) then drop the table
next

i am not in front of access, so i cant verify the exact syntax

Working with compact and repair option... THANKS