Delete Access Form From Excel using vba

[Abhi24]

Hi,
I have 2 forms in an access database (access 2007-10). I am trying to delete these forms using vba in an excel workbook.
My access database has NO database password but the VBA project in access HAS a password. In the access database I have created a sub procedure (named DeleteAll) which contains the following code for each form.

Docmd.DeleteObject acform, <formname>

When I call this code from my excel vba, the Access database gives me an error -

Run-time error '2017': Microsoft helps protect this Visual Basic for Applications Project with a password. You must supply the password in the Visual Basic Editor before you can perform this operation.

Funny thing is if I were to delete a query using this method, it gets deleted easily. I am experiencing this problem with forms only. Please help.</formname>

 

[xenou]

Since you can open the database and delete the two forms in a few seconds I would not spend time on this. No reason to do it from Excel.

 

[Abhi24]

I am creating an automated tool. After a period of time, the excel along with the forms should be deleted but the data in the tables should remain. I could not find a direct way of doing this from access itself. So, I am going via excel to delete the forms.

 

[Norie]

Why not have the data in a separate, back-end, database and the forms in a front-end database?

Then when you want to delete the forms just delete the front-end database.

 

[Abhi24]

That is a fantastic idea. I will implement it right away. Thanx a lot.

 

[xenou]

good idea Norie