Making mde file of the FE

[aman]

Hi guys

I have designed multi user application which will be used by around 8 people simultaneously and now I want to deploy the FE to each workstation. Can anyone please tell me before I deploy the application to users,shall I compile the FE mdb into an mde file? What are the benefits of this? Will it increase processing speed as now the system does miss some records when bulk insert occurs on multiple computers.

And also when I go to tools->database utilities then there is no "make mde file option" present.

Any help would be much appreciated.

Thanks
Aman

 

[SimonB1978]

Hi,

I create always create mde files when possible. I have never compared performance but since the code is somewhat precompiled it SHOULD be faster. Plus, users cannot mess around with forms and vba code.

The reason you don't see Create MDE file is possibly because your default file format is different from your Access version, ie: Access 2000 filetype with Access 2002. You will then need to convert it to your version. What version of Access are you running?

HTH,

Simon B.

 

[aman]

Hi Simon

I am using Access 200 file format with Access XP version.
Can you please suggest me how can I convert it to the current version.

Thanks
Aman

 

[SimonB1978]

Hi Aman,

Tools -> Database Utilities -> Convert Database -> Access 2002

The names are approximates as my version is in French...

Access will actually create a copy of your mdb file in the new format. You will then have to use this new file to create the mde.

Simon B.

 

[aman]

Simon,

I am able to convert it into Access 2002 file format and after that when I try to make mde of this then a window with a message comes up like: Microsoft Access has encountered a problem and needs to close. we are sorry for the inconvenience.

Any suggestions in this?

Thanks
Aman

 

[aman]

My problem has been sorted out. Thanks a lot for your help.

Cheers