By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

unlock DB - to view table, forms design

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<ac*********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
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?


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.
Nov 13 '05 #2

P: n/a
Yes, it is MDE file...

:(

Nov 13 '05 #3

P: n/a

<ac*********@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Yes, it is MDE file...

:(


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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.