unlock DB - to view table, forms design

Folks, I have Access db, but whenever I try to open it and view design
of tables, forms, etc, ie, when I double click on icon then instead of
opening it in MS Access it opens as application, first asking for
password then opens forms to enter or update data...

In folder there are two files:
ABCbase and
ABCbase_data

I want to open first file, but it has small lock sing on it, and, as I
said, it doesnt' want to open in Access database...

Is there any way to "unlock" it, so I can view forms and code behind
it?

<accesstribe@yahoo.com> wrote in message
news:1114601663.489980.283530@g14g2000cwa.googlegr oups.com...[color=blue]
> Folks, I have Access db, but whenever I try to open it and view design
> of tables, forms, etc, ie, when I double click on icon then instead of
> opening it in MS Access it opens as application, first asking for
> password then opens forms to enter or update data...
>
> In folder there are two files:
> ABCbase and
> ABCbase_data
>
> I want to open first file, but it has small lock sing on it, and, as I
> said, it doesnt' want to open in Access database...
>
> Is there any way to "unlock" it, so I can view forms and code behind
> it?[/color]

Just a guess here, but the one with the small lock icon, might be an MDE
file, not an MDB file. If that is the case, you will not be able to view
the code.

Yes, it is MDE file...

:(

<accesstribe@yahoo.com> wrote in message
news:1114610355.234308.52820@f14g2000cwb.googlegro ups.com...[color=blue]
> Yes, it is MDE file...
>
> :(
>[/color]

In which case the VBA code is not retrievable. You can however unlock the
forms and reports so that you can make design changes (Acc 2000+) - read
this article:

http://www.everythingaccess.com/tuto...ccess-MDE-file

Regards,

Wayne Phillips
http://www.everythingaccess.com

Or better www.rvsoftware.hr/MDEDesigner.htm.

--
Message posted via http://www.accessmonster.com