Access was unable to create MDE database

[Bobby1st]

Hello!

I followed boblarson - Access Front-end Auto-Updating Utility procedure. I tested the procedure to a smaller database following the procedure, it stop after it deleted the old copy but tried different ways and made it to work. Applying the same on a much larger database with lots of links to the BE, might cause me the problem. I tried different approach, still gave me “MSAccess was unable to create an MDE database”. One thing I did to avoid deleting the master-FE was to change the name of the mde and the location, the same as in the tbl-version_master_location. It works in my test database. Any idea what causing unable to create a MDE database?

BobLarson - great utility!

 

[KeithG]

Try to compile your code. Access will fail to make an MDE if there is a compile error.

 

[boblarson]

Yes, it's almost certain that there is some code error because it has to be able to compile (as that is what an MDE does is compile the code and eliminate access to the source code).

 

[Bobby1st]

Hi boblarson and KeithG

Everything is rolling smoothly, thanks but I came up with another problem. I have two front-end and one data back-end. Now I've conflict on the tbl-version_fe_master. I have two copies of your utility residing on different folder. Should I revise one of this "Me.Parent.fe_version_number = Me.fe_version_number". I don't want to run the mde that could possible override the other FE. What can you recommend?

Should you want to know, one FE is for employee/managers production scorecard and the other are for data entry and data import from other sources.

 

[boblarson]

Sorry, the utility I created only works for one front-end master. If you need to do two, then you would have to have separate fields for versions and modify the code to check the correct field for the second master.

 

[Bobby1st]

Sorry, the utility I created only works for one front-end master. If you need to do two, then you would have to have separate fields for versions and modify the code to check the correct field for the second master.

Which of the three items should I create a copy to differentiate it from the other utility?

• tbl-fe_version
• tbl-version_fe_master
• tbl-version_master_location

I tried to revised this part of the code "DoCmd.TransferDatabase acExport, "Microsoft Access", strBEFile, acTable, "tbl-version_fe_master_EPS", "tbl-version_fe_master_EPS". I add EPS but it didn't work.

Can you explain what you meant by separate field of version, and which of the three should I do that?

 

[boblarson]

There's a lot more to it than a simple response, unfortunately. As I was trying to formulate an answer, it dawned on me that it isn't as simple as I made it out to be in my original post.

 

[Bobby1st]

boblarson,

I figured out your codes and made it to work, different from the separate field of versions you mentioned. The back-end accommodate two front-end links. Thanks

 

[boblarson]

Cool - glad you got it to work as I couldn't really dedicate enough time to think about it today.

 

[Bobby1st]

I found solution to my problem. Does the user need to have access to the folder where the FE mde is located?