MDE issues after upgrade from 2K to 2K3

[Joshua K Briley]

Hello,

I have a small database that I created with Acess 2K. I recently upgraded
to 2K3. I converted the .mdb to the 2K3 format, but now I cannot create a
new .mde for the DB. Access just sits there like a bump on a log, and Task
Manager shows Access as "Not Responding". Have I overlooked something in the
conversion?

 

[Joshua K Briley]

A tid bit more information... I have multiple databases, and this one is the
only one that's failing on the creation of the .mde file. I've compacted and
repaired. I'd appreciate any advice.

 

[Bill Mosca, MS Access MVP]

Josh

Does your code compile? How long did you let Access run before giving up?

You might be interested in what I do. I have both 2000 and 2003 installed.
All my databases are in 2000 format, but i develop in 2003. When it comes
time to create an MDE, I close up 2003 and do the creation in 2000. That way
all my users who have either 2000, XP or 2003 cna open the mde.

 

[Joshua K Briley]

Granny Spitz nailed it (thank you very much, by the way)... the code compiled
and life is good.

 

[Joshua K Briley]

Granny Spitz nailed it (thank you very much, by the way).... I compiled the
code and everything worked.

 

[Bill Mosca, MS Access MVP]

Granny

What is this *wonderful* tool, and where can I get it? I'd love to try it
out. Does it use 2K runtime files? how could it create an MDE without
Access? This is downright intriguing.

 

[Tony Toews]

I can't give you the URL because advertising is prohibited in the newsgroups,

In my opinion advertising isn't prohibited in the newsgroups. The
last time I looked, which was a few years ago, off topic advertising
was prohibited.

Regardless of your viewpoint on this though it is, in my opinion, the
general consensus that responding with a specific URL, even if it is
your own product, is ok.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm