how to Reset or Delete ACCDE file Data

[ZKHADI]

Hellow guys!

i purchase an ACCDE file. and i fill the data in file. now i want to erase all data from the file and reset it. but there is no option of delete in file. is there any method that i erase all the data i put in file. and blank the file.

 

[arnelgp]

on Immediate window:

Currentdb.Execute "delete * from tableName;"

 

[isladogs]

If you have access to the navigation pane & ribbon, you can still create delete queries in an ACCDE.
Try using the shift bypass if necessary when you open the file.

Alternatively, use an external database. Link all tables from the ACCDE and delete the data from there.

 

[ZKHADI]

no its accde file not accdb. i cant modify or delete anything. tell anyother way

 

[ZKHADI]

on Immediate window:

Currentdb.Execute "delete * from tableName;"

i cant goto tables and VBA. its locked accde file

 

[isladogs]

All of the methods suggested earlier should work for an ACCDE file
Have you actually tried what what suggested?

ACCDE files are designed to protect the code in forms/reports/modules.
Tables and queries can still be edited or created or deleted.

How exactly is it locked?

 

[gemma-the-husky]

can you download a new version of the database and start again?

 

[ZKHADI]

Locked mean its accde i cant access deaign mood or see the tables reports

 

[ZKHADI]

can you download a new version of the database and start again?

Re download not available

 

[Gasman]

Contact the developer?

 

[isladogs]

Have you tried opening using the shift bypass or using an external database as I suggested in post #3?

 

[gemma-the-husky]

You may be able to write a new database to connect to that accde database, and view the tables that way. It depends how carefully it's been protected. Colin @isladogs may be your expert in this.

 

[ZKHADI]

Have you tried opening using the shift bypass or using an external database as I suggested in post #3?

No i didt tried shift key

 

[ZKHADI]

You may be able to write a new database to connect to that accde database, and view the tables that way. It depends how carefully it's been protected. Colin @isladogs may be your expert in this.

Ok i will

 

[arnelgp]

see if this can open your db and show the tables.

 

[isladogs]

No i didt tried shift key

Why not? Which of the various suggestions did you try?

 

[Pat Hartman]

So, you downloaded a file that you "purchased" and never made a backup. Just started typing in data? Most companies will allow you do download a purchase multiple times, at least for a limited amount of time.

Once you download the file again, you might want to make a backup.

You also can't actually use this database in a multi-user enviornment with the tables embedded in the FE. Proper setup for an Access application is to use two separate files. A FE for the application objets and a BE for ONLY the data. The BE is placed in a shared folder on the server and the FE is distributed to each user so everyone has a personal copy of the FE.

 

[ZKHADI]

It

So, you downloaded a file that you "purchased" and never made a backup. Just started typing in data? Most companies will allow you do download a purchase multiple times, at least for a limited amount of time.

Once you download the file again, you might want to make a backup.

You also can't actually use this database in a multi-user enviornment with the tables embedded in the FE. Proper setup for an Access application is to use two separate files. A FE for the application objets and a BE for ONLY the data. The BE is placed in a shared folder on the server and the FE is distributed to each user so everyone has a personal copy of the FE.

No this was only one time download

 

[ZKHADI]

Thank you

see if this can open your db and show the tables.

i will try this and let you know

 

[ZKHADI]

Why not? Which of the various suggestions did you try?

I will try