Converting switchboard from 1998 to 2003

[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?

 

[Allen Browne]

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

 

[GO]

My switchboard is a MDE

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

 

[Keith Wilby]

My switchboard is a MDE

You need to work with your mdb file. You can do just about nothing with an
mde.

Keith.

 

[GO]

Is there anyway to convert a MDE to a MDB?

You need to work with your mdb file. You can do just about nothing with an
mde.

Keith.

 

[GO]

Or is there anyway to copy the info from a MDE to a MDB?

 

[dymondjack]

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

 

[Allen Browne]

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

 

[Keith Wilby]

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

Or you could try to reverse engineer it yourself.

Keith.
www.keithwilby.co.uk

 

[Allen Browne]

Or you could try to reverse engineer it yourself.

How did you go with doing that, Keith?

 

[Keith Wilby]

How did you go with doing that, Keith?

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.