how to Reset or Delete ACCDE file Data (1 Viewer)

ZKHADI

Member
Local time
Today, 16:07
Joined
Apr 5, 2021
Messages
118
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

..forever waiting... waiting for jellybean!
Local time
Today, 19:07
Joined
May 7, 2009
Messages
19,169
on Immediate window:

Currentdb.Execute "delete * from tableName;"
 

isladogs

MVP / VIP
Local time
Today, 11:07
Joined
Jan 14, 2017
Messages
18,186
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

Member
Local time
Today, 16:07
Joined
Apr 5, 2021
Messages
118
no its accde file not accdb. i cant modify or delete anything. tell anyother way
 

isladogs

MVP / VIP
Local time
Today, 11:07
Joined
Jan 14, 2017
Messages
18,186
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

Super Moderator
Staff member
Local time
Today, 11:07
Joined
Sep 12, 2006
Messages
15,613
can you download a new version of the database and start again?
 

ZKHADI

Member
Local time
Today, 16:07
Joined
Apr 5, 2021
Messages
118
Locked mean its accde i cant access deaign mood or see the tables reports
 

Gasman

Enthusiastic Amateur
Local time
Today, 11:07
Joined
Sep 21, 2011
Messages
14,038
Contact the developer?
 

isladogs

MVP / VIP
Local time
Today, 11:07
Joined
Jan 14, 2017
Messages
18,186
Have you tried opening using the shift bypass or using an external database as I suggested in post #3?
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 11:07
Joined
Sep 12, 2006
Messages
15,613
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:07
Joined
May 7, 2009
Messages
19,169
see if this can open your db and show the tables.
 

Attachments

  • showTablesFromOtherDB.accdb
    420 KB · Views: 184

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:07
Joined
Feb 19, 2002
Messages
42,970
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

Member
Local time
Today, 16:07
Joined
Apr 5, 2021
Messages
118
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
 

Users who are viewing this thread

Top Bottom