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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GO" <(E-Mail Removed)> wrote in message
news:82B07319-A4C9-4BB4-9EE2-(E-Mail Removed)...
> 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?

My switchboard is a MDE

"Allen Browne" wrote:

> 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
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "GO" <(E-Mail Removed)> wrote in message
> news:82B07319-A4C9-4BB4-9EE2-(E-Mail Removed)...
> > 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?
>
>

"GO" <(E-Mail Removed)> wrote in message
news:496160BB-48AC-4903-AB26-(E-Mail Removed)...
> My switchboard is a MDE
>

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

Keith.

Is there anyway to convert a MDE to a MDB?

"Keith Wilby" wrote:

> "GO" <(E-Mail Removed)> wrote in message
> news:496160BB-48AC-4903-AB26-(E-Mail Removed)...
> > My switchboard is a MDE
> >
>
> You need to work with your mdb file. You can do just about nothing with an
> mde.
>
> Keith.
>
>

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

"Keith Wilby" wrote:

> "GO" <(E-Mail Removed)> wrote in message
> news:496160BB-48AC-4903-AB26-(E-Mail Removed)...
> > My switchboard is a MDE
> >
>
> You need to work with your mdb file. You can do just about nothing with an
> mde.
>
> Keith.
>
>

> 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


"GO" wrote:

> Is there anyway to convert a MDE to a MDB?
>
> "Keith Wilby" wrote:
>
> > "GO" <(E-Mail Removed)> wrote in message
> > news:496160BB-48AC-4903-AB26-(E-Mail Removed)...
> > > My switchboard is a MDE
> > >
> >
> > You need to work with your mdb file. You can do just about nothing with an
> > mde.
> >
> > Keith.
> >
> >

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 - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GO" <(E-Mail Removed)> wrote in message
news:A03C54C5-959C-489A-B545-(E-Mail Removed)...
> Or is there anyway to copy the info from a MDE to a MDB?
>
> "Keith Wilby" wrote:
>
>> "GO" <(E-Mail Removed)> wrote in message
>> news:496160BB-48AC-4903-AB26-(E-Mail Removed)...
>> > My switchboard is a MDE
>> >
>>
>> You need to work with your mdb file. You can do just about nothing
>> with an mde.

"Allen Browne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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

"Keith Wilby" <(E-Mail Removed)> wrote in message
news:49b0e6cd$(E-Mail Removed)...
>> ... commerical services that can create the MDB from the MDE
>
> Or you could try to reverse engineer it yourself.

How did you go with doing that, Keith?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.