Error creating MDE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lina Manjarres - 23 Dec 2006 18:19 GMT

When I tried to creat an MDE file from Access 2003, I get an error message
saying that my database is too big. So, how can I secure my database, so no
body can access the forms design, the modules and the queries?
thanks a lot, Lina

Reply to this Message

'69 Camaro - 23 Dec 2006 19:16 GMT

Hi, Lina.

> When I tried to creat an MDE file from Access 2003, I get an error message
> saying that my database is too big.

I've never seen that error message. Perhaps the online Help explained "this
is often caused by too many Table ID's"? If so, that excuse is almost always
a red herring. Check the "Can't make an MDE!" checklist on the following Web
page to help you determine why you can't create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

> So, how can I secure my database, so no
> body can access the forms design, the modules and the queries?

An MDE will not secure your database. It will remove the VBA source code
and make it difficult to alter forms and reports, but users can still access
the designs of forms, reports and queries. If you want to prevent them from
doing this, you must implement User-Level Security. For more information,
please see the following Web page:

http://support.microsoft.com/?id=207793

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

> When I tried to creat an MDE file from Access 2003, I get an error message
> saying that my database is too big. So, how can I secure my database, so no
> body can access the forms design, the modules and the queries?
> thanks a lot, Lina

Reply to this Message