Converting switchboard from 1998 to 2003

  • Thread starter Thread starter GO
  • Start date Start date
G

GO

Our original switchboard was generated in Access 1998. When I upgraded to
2003 I have not been able to use it. I would like to be able to convert it to
2003 as I am considering upgrading to 2007. Can it up converted to 2003? If I
upgrade to 2007 will I be able to convert it?
 
Access 2003 provides the ability to convert an Access 97 MDB to the Access
2000 or 2002/3 file format. Go to:
Tools | Database Utilities | Convert

Access 2007 can also convert an A97 MDB. It can also convert the A2000 and
A2002/3 file formats, or it can use those without needing to convert.

For more detailed information about issues you may experience converting
from A97 to 2003, see:
Converting from Access 97 to 2000 and later
at:
http://allenbrowne.com/ser-48.html

And for information about A2007, see:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html
 
My switchboard is a MDE

Allen Browne said:
Access 2003 provides the ability to convert an Access 97 MDB to the Access
2000 or 2002/3 file format. Go to:
Tools | Database Utilities | Convert

Access 2007 can also convert an A97 MDB. It can also convert the A2000 and
A2002/3 file formats, or it can use those without needing to convert.

For more detailed information about issues you may experience converting
from A97 to 2003, see:
Converting from Access 97 to 2000 and later
at:
http://allenbrowne.com/ser-48.html

And for information about A2007, see:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html
Click to expand...
 
Is there anyway to convert a MDE to a MDB?

Nope.

That's the major reasoning behind creating the MDE, you make it so that
noone can see the code, and also so that none can revert back and possibly
steal your info. But, an MDE needs to be made from an MDB, so there must be
an MDB somewhere... if not you'll have to start from scratch. You can't
even import from an MDE into an MDB, it completely locks everything to do
with the design phase of the project.
--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain
 
An MDB contains 2 copies of the code:
- the text version that you view and edit;
- the compiled version (machine code that executes.)

An MDE contains only the 2nd. You cannot modify the forms/reports, and you
cannot edit the code. You must locate the MDB.

If there is no way you can do that, there are commerical services that can
create the MDB from the MDE if you can a) demonstrate you have copyright,
and b) pay for them:
http://www.everythingaccess.com/mdeconversion.htm
 
Allen Browne said:
You cannot modify the forms/reports, and you cannot edit the code. You
must locate the MDB.

If there is no way you can do that, there are commerical services that can
create the MDB from the MDE
Click to expand...

Or you could try to reverse engineer it yourself.

Keith.
www.keithwilby.co.uk
 
Allen Browne said:
How did you go with doing that, Keith?
Click to expand...

Not sure what you mean there Allen, I was just suggesting that the OP could
try to re-create the functionality of the mde in a new mdb.

Regards,
Keith.
 
Back
Top