Cannot create mde file

  • Thread starter Thread starter Sander
  • Start date Start date
S

Sander

Hi,

i am trying to create a mde file but it constantly collaps
with the following error message:

Cannot create MDE file.

Does anyone know what to do or how else i can create a mde
file. I am giving a presentation tommorow and i think they
would like to try using my database. And therefore I in
doubt of giving them the mdb file.

Thanks in advance
Sander.
 
If you are using Access 2002 and have created your database in the default
file format of Access 2000, you will need to convert your database to the
Access 2002 file format.

Otherwise, for any version of Access, you will need to compile your
application. To do this, open any code window using Alt - F11; then, from
the menu select Debug | Compile. You'll need to fix any errors that are
highlighted until your code compiles error-free.

hth,
 
Thanks,
That was the trick, I had a compile error.
But people still can open the tables in designview?
Is this in anyway to block?

Thanks,

Sander.
 
Hi,

i am trying to create a mde file but it constantly collaps
with the following error message:

Cannot create MDE file.

Does anyone know what to do or how else i can create a mde
file. I am giving a presentation tommorow and i think they
would like to try using my database. And therefore I in
doubt of giving them the mdb file.

Thanks in advance
Sander.
Click to expand...

The database must be compiled with no errors (open the VBA editor and
select Debug... Compile Project). In addition, it must be in the same
format as the version of Access you're using - that is, although
Access 2002 can use a database in A2000 format, it must be upgraded to
2002 format before it will make a MDE. The same applies to 2003.
 
Sander,

Saving your Access database as an MDE file prevents the following actions:

- Viewing, modifying, or creating forms, reports, or modules in Design view.
- Adding, deleting, or changing references to object libraries or databases.
- Changing code - an MDE file contains no source code.
- Importing or exporting forms, reports, or modules.

However, tables, queries, data access pages, and macros can be imported from
or exported to non-MDE databases.
 
Back
Top