MDE issues after upgrade from 2K to 2K3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Joshua said:
I converted the .mdb to the 2K3 format, but now I cannot create a
new .mde for the DB.
Click to expand...

Usually when Access can't convert it, you get an error message. When it
hangs, there's something not quite right. Did you make sure all conditional
compilation code is commented out? Did you compile the code afterward? Are
all the queries *valid?* (Do all the queries execute correctly?)

You may need to create a new database (in Access 2002-2003 format) and import
all the objects into it, then compile the code, compact, and create an MDE.
 
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.
 
Granny Spitz nailed it (thank you very much, by the way)... the code compiled
and life is good.
 
Granny Spitz nailed it (thank you very much, by the way).... I compiled the
code and everything worked.
 
Joshua said:
Granny Spitz nailed it (thank you very much, by the way)... the code compiled
and life is good.
Click to expand...

You're welcome, Josh. Glad to hear you've got it working.
 
Bill said:
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.
Click to expand...

And you might be interested in what I do. I have a laptop without a lot of
disk space so I've only loaded Office 2003 on it. I have a custom
developer's toolbar I bought from one of the web sites that belongs to people
who post in these newsgroups. There are quite a few neat tools on it, but
one button compiles my Access 2000 or Access 2003 format database into an
Access 2000 MDE. Anyone with Access 2000, 2002 or 2003 can run it without
problems. I use late binding and don't use any post-2000 VBA code of course.

It works great. I don't have to waste the disk space for installing Access
2000 (or Office 2000), and I didn't have to buy another license to install
Office 2000 (which are getting harder to find these days) on the laptop
either. Saved me money and disk space, and the 15 developer's tools increase
my productivity. I don't know what I'd do without it.
 
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.
 
Bill said:
Does it use 2K runtime files? how could it create an MDE without
Access?
Click to expand...

It *does* require the Access 2003 retail version. You can either:

1) Make a copy of their template Access 2000 MDB file with the settings
already set for developers (like track name autocorrect turned off), then
develop the application using the buttons as needed, or

2) You can import the toolbar and a code module into a database (or drag the
buttons onto your built in toolbars like I do so I can use the buttons on all
databases) and set a reference to the library MDE file, then develop the
application using the buttons as needed.

When you're ready to ship your database, you delete the toolbar (if you
imported it), library reference and code module, then compile, compact and
close it. Open another Access database that has the toolbar (if you didn't
put the buttons on your built in toolbars) and library reference. Press the
"Convert to Access 2000 MDE" button and follow the prompts to pick the
database you want to convert. It'll make an Access 2000 MDE file no matter
if the MDB is in 2000 or 2003 format. Of course the usual disclaimers apply,
like it will fail if the MDB's code doesn't compile, you don't have exclusive
access, it's using replication, etc., but that applies to all MDBs anyway.
What is this *wonderful* tool, and where can I get it?
Click to expand...

I can't give you the URL because advertising is prohibited in the newsgroups,
but you can find a link to the web site in the signature block of several
people (including 2 MVPs) who have posted answers in the Access newsgroups
for years. Once you find their web site you have to find their products,
because they don't put a link to their products in their signature blocks.
And it's not FMS or Moshannon if that's what you're thinking.

BTW there's only 14 buttons, not 15. I miscounted. Sorry about that.
 
Granny Spitz via AccessMonster.com said:
I can't give you the URL because advertising is prohibited in the newsgroups,
Click to expand...

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
 
Back
Top