MDE file problem

[Anita]

I'm not sure if I'm going about this the correct way (I'm using 2003)

I have split my databse using the database splitter.

I want to distribute the front end file as an mde so that users can't mess
about with the objects. I would actually like to have 4 or 5 different front
end files for different departments, all saved as mdes but linked back to the
tables stored in the backend. Is this the right thing to do?

I have tried creating the mde file and I get the message 'Access cannot
create MDE' (I did ensure the file was saved in the latest format first
before trying to make an MDE).

Any help gratefully received - I know what I want to do but I don't think
I'm doing it in the right order.

Thanks so much

Anita

 

[Jesper Fjølner]

I have split my databse using the database splitter.

I want to distribute the front end file as an mde so that users can't mess
about with the objects. I would actually like to have 4 or 5 different
front
end files for different departments, all saved as mdes but linked back to
the
tables stored in the backend. Is this the right thing to do?

I have tried creating the mde file and I get the message 'Access cannot
create MDE' (I did ensure the file was saved in the latest format first
before trying to make an MDE).

First thing - hit Alt + F11 and check if your code compiles.


Jesper

 

[TC]

You'd be hard pressed to justify having different front-ends for
different departments, IMHO. This just make your maintenance effort
harder. You'll inevitably end up with Tom having version 1 of FEs 'A'
and 'B', but version 2 of FE 'C', but Dick has version 2 of FE 'A',
version 1 of FE 'B' and version 3 of FE 'C', and so on. I'd aim for a
single front-end with a switchboard or menu of forms & reports. Then
each user chooses the forms & reports that apply to them. You could
even have the switchboard or menu see what group(s) the user belongs
to, and determine exactly /which/ forms or reports to include on the
menu.

As for the MDE problem, Jesper has the probble answer there. Another
possible cause of being unable to create an MDE, is using methods of
the dbengine object without explicitly including the dbengine keyword;
eg. opendatabase (wrong), instead of dbengine.opendatabase (right).
Maybe check you code for those.

HTH,
TC