Turning database into MDE

[Brandon M]

Hello,

I am working on a project for my work and I would like to lock it up a
little so that the code is inaccessible. I was going to turn it into an MDE
file but for some reason that option is greyed out. Have I done something
wrong? Basically this database is pulling information from another raw data
database for historical and reporting purposes.

[Larry Daugherty]

Hi Brandon

Open any module in that MDB and click Compile and Save All Modules. When it
compiles without errors, make sure you're using the same version of Access
that created the MDB to then create the MDE.

HTH
--
-Larry-
--

"Brandon M" <aw*****@telus.net> wrote in message
news:NdToc.2915$9P6.142@clgrps12...

Hello,

I am working on a project for my work and I would like to lock it up a
little so that the code is inaccessible. I was going to turn it into an MDE file but for some reason that option is greyed out. Have I done something
wrong? Basically this database is pulling information from another raw data database for historical and reporting purposes.

[Wayne Gillespie]

On Thu, 13 May 2004 23:08:29 GMT, "Brandon M" <aw*****@telus.net> wrote:

Hello,

I am working on a project for my work and I would like to lock it up a
little so that the code is inaccessible. I was going to turn it into an MDE
file but for some reason that option is greyed out. Have I done something
wrong? Basically this database is pulling information from another raw data
database for historical and reporting purposes.

This option will be greyed out if you are working in A2002 (and I assume A2003) on an mdb which is is A2000 file format.
Although A2002 can create and work with A2000 files, it cannot create an mde in A2000 format.

You need to either open the file in a copy of A2000 and create the mde, or convert the file to A2002/3 format. You will
then be able to create the mde.
Wayne Gillespie
Gosford NSW Australia

[Brandon M]

If I convert it to 2002 format will people with access 2000 or access 97
still be able to work with the database? If not is there a way to make it
run no matter which of the above versions they have?

"Wayne Gillespie" <be*****@NObestfitsoftwareSPAM.com.au> wrote in message
news:rc********************************@4ax.com...

On Thu, 13 May 2004 23:08:29 GMT, "Brandon M" <aw*****@telus.net> wrote:

Hello,

I am working on a project for my work and I would like to lock it up a
little so that the code is inaccessible. I was going to turn it into an MDEfile but for some reason that option is greyed out. Have I done something
wrong? Basically this database is pulling information from another raw datadatabase for historical and reporting purposes.

This option will be greyed out if you are working in A2002 (and I assume

A2003) on an mdb which is is A2000 file format. Although A2002 can create and work with A2000 files, it cannot create an mde in A2000 format.
You need to either open the file in a copy of A2000 and create the mde, or convert the file to A2002/3 format. You will then be able to create the mde.
Wayne Gillespie
Gosford NSW Australia

[Douglas J. Steele]

Nope. For that matter, Access 97 users will be unable to use it in Access
2000 format.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Brandon M" <aw*****@telus.net> wrote in message
news:2jupc.5144$9P6.234@clgrps12...

If I convert it to 2002 format will people with access 2000 or access 97
still be able to work with the database? If not is there a way to make it
run no matter which of the above versions they have?

"Wayne Gillespie" <be*****@NObestfitsoftwareSPAM.com.au> wrote in message
news:rc********************************@4ax.com...

On Thu, 13 May 2004 23:08:29 GMT, "Brandon M" <aw*****@telus.net> wrote:

Hello,

I am working on a project for my work and I would like to lock it up a
little so that the code is inaccessible. I was going to turn it into an MDEfile but for some reason that option is greyed out. Have I done somethingwrong? Basically this database is pulling information from another raw datadatabase for historical and reporting purposes.

This option will be greyed out if you are working in A2002 (and I assume

A2003) on an mdb which is is A2000 file format.

Although A2002 can create and work with A2000 files, it cannot create an

mde in A2000 format.

You need to either open the file in a copy of A2000 and create the mde,

or convert the file to A2002/3 format. You will

then be able to create the mde.
Wayne Gillespie
Gosford NSW Australia