Converting mdb to mde failing

[pubdude2003 via AccessMonster.com]

Getting a general "Microsoft Access was unable...." error when attempting to
convert an mdb to an mde. It should be good to go, proper version, compiles
like a dream, just a few forms....

Are there any other general reasons for an mde conversion failure??

 

['69 Camaro]

Hi.

Are there any other general reasons for an mde conversion failure??

Please check the "Can't make an MDE!" checklist on the following Web page to
help you determine why you can't create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[pubdude2003 via AccessMonster.com]

Thanks 'chevy', actually I had already used this page to check everything.

I had thought the reference to another MS Access db that wasn't an mde might
be it but when I remove that reference it still won't convert. (Can't convert
that db anyways because I rename reports in it, so not viable as an mde.)

I will re-check again but it doesn't seem to be any of the reasons suggested..
.. it's so weird because it is possibly the smalled app I have ever built....
less than 500 kb, three forms, three linked (all viable) tables and 4 reports.

 

['69 Camaro]

Hi.

I had thought the reference to another MS Access db that wasn't an mde
might
be it but when I remove that reference it still won't convert.

All referenced Access libraries must be MDE's _before_ you can convert this
database file into an MDE. The reason is that if an MDB were allowed to be
a referenced library, the code could be changed, thereby uncompiling the
code in all other databases that rely on it, and MDE's can't uncompile.

After you removed the library reference, did you recompile the code
successfully, and then try to convert it to an MDE?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[pubdude2003 via AccessMonster.com]

Of course, that totally makes sense!

Converts fine without the reference.

Now my challenge is to come up with a method of renaming reports (necessary
because I am sending print files the client wants to clearly identify on the
fly) but still be able to run it from an mde.

Ah, if it were easy we wouldn't be making the big bucks!

Thanks for the insight!

 

['69 Camaro]

Hi.

Now my challenge is to come up with a method of renaming reports
(necessary
because I am sending print files the client wants to clearly identify on
the
fly) but still be able to run it from an mde.

Your MDE can store the reports in a separate MDB file. These reports can
either use linked tables as data sources or use remote queries on the tables
stored in another database file.

Thanks for the insight!

You're welcome!

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[pubdude2003 via AccessMonster.com]

ah, I was storing the function in the mdb, thusly the reference but I suppose
I could just do that from the mde.... what was I thinking?

Probably, is it time for ANOTHER drink?

Thanks AGAIN!!!

 

['69 Camaro]

You're welcome. Good luck with it.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[pubdude2003 via AccessMonster.com]

Gunny,

While I have your attention, maybe now I see why I ran this locally and
ref'ed it

The code below doesn't seem to want to run, it poops out with a 2501 the copy
object was cancelled.

Any further insights I can prevail upon you for?

'Set myApp = New Access.Applic ation
'myApp.OpenCurrentDatabase ("C:\...\Reports.mdb")
'myApp.DoCmd.CopyObject "C:...\Reports.mdb", "Report - " & ReportName,
acReport, "report1"

'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'Pause 1000
'myApp.OpenReport "Report - " & ReportName, acViewNormal, "", "", acHidden
'myApp.Close acReport, "Report - " & ReportName
'my.app.DeleteObject acReport, "Report - " & ReportName
'myApp.CloseCurrentDatabase

 

[Aaron Kempf]

of course MDB is failing

MDB always fails but the chipmunks around here blame it on the NETWORK

time for a real database = Access Data Projects