By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,747 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

Task to convert A97 to A2000

P: n/a
Dear Access Gurus,

I am tasked with converting an Access 97 Database to A2K. I created Macros,
switchboards and used the full feature of buttons on forms. The A97 is also
split (FE and BE). Are there any suggestions that I should keep in mind
while attempting to do this task ?
What can I expect ?

Thanks

Omey
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:fz***************@news01.bloor.is.net.cable.r ogers.com...
Dear Access Gurus,

I am tasked with converting an Access 97 Database to A2K. I created Macros,
switchboards and used the full feature of buttons on forms. The A97 is also
split (FE and BE). Are there any suggestions that I should keep in mind
while attempting to do this task ?
What can I expect ?


If your A97 file is error free (you can create an MDE successfully), then it
should convert to 2000 and work without problems (other than those you would
have in any other A2K app).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
Thanks for your prompt response Rick.
Just to be sure, do I create MDE files for both the FE and BE in A97 and
then convert them to A2K ?
Omey
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c0*************@ID-98015.news.uni-berlin.de...
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:fz***************@news01.bloor.is.net.cable.r ogers.com...
Dear Access Gurus,

I am tasked with converting an Access 97 Database to A2K. I created Macros, switchboards and used the full feature of buttons on forms. The A97 is also split (FE and BE). Are there any suggestions that I should keep in mind
while attempting to do this task ?
What can I expect ?
If your A97 file is error free (you can create an MDE successfully), then

it should convert to 2000 and work without problems (other than those you would have in any other A2K app).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #3

P: n/a
You cannot convert an MDE. There is no reason, ever, to convert a back-end
to MDE... MDE "compiles" the code to make it unreachable but has no effect
whatsoever on Tables, their data, or the Relationships which are all that
should be in a back end. You will convert the MDB files.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:33**************@news01.bloor.is.net.cable.ro gers.com...
Thanks for your prompt response Rick.
Just to be sure, do I create MDE files for both the FE and BE in A97 and
then convert them to A2K ?
Omey
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c0*************@ID-98015.news.uni-berlin.de...
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:fz***************@news01.bloor.is.net.cable.r ogers.com...
Dear Access Gurus,

I am tasked with converting an Access 97 Database to A2K. I created Macros, switchboards and used the full feature of buttons on forms. The A97 is also split (FE and BE). Are there any suggestions that I should keep in mind while attempting to do this task ?
What can I expect ?
If your A97 file is error free (you can create an MDE successfully),

then it
should convert to 2000 and work without problems (other than those you

would
have in any other A2K app).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 12 '05 #4

P: n/a
Perfect, thank you for clearing that up Larry.
Omey

"Larry Linson" <bo*****@localhost.not> wrote in message
news:TY***************@nwrddc02.gnilink.net...
You cannot convert an MDE. There is no reason, ever, to convert a back-end
to MDE... MDE "compiles" the code to make it unreachable but has no effect
whatsoever on Tables, their data, or the Relationships which are all that
should be in a back end. You will convert the MDB files.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:33**************@news01.bloor.is.net.cable.ro gers.com...
Thanks for your prompt response Rick.
Just to be sure, do I create MDE files for both the FE and BE in A97 and
then convert them to A2K ?
Omey
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c0*************@ID-98015.news.uni-berlin.de...
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:fz***************@news01.bloor.is.net.cable.r ogers.com...
> Dear Access Gurus,
>
> I am tasked with converting an Access 97 Database to A2K. I created

Macros,
> switchboards and used the full feature of buttons on forms. The A97
is
also
> split (FE and BE). Are there any suggestions that I should keep in

mind > while attempting to do this task ?
> What can I expect ?

If your A97 file is error free (you can create an MDE successfully),

then
it
should convert to 2000 and work without problems (other than those you

would
have in any other A2K app).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



Nov 12 '05 #5

P: n/a
Sorry for the confusion. I was only saying that if you can make an MDE in A97
that that is a good indicator that the file has no hidden code problems or
corruptions. That would then indicate a file that should convert to a newer
version without problems.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:W7********************@news04.bloor.is.net.ca ble.rogers.com...
Perfect, thank you for clearing that up Larry.
Omey

"Larry Linson" <bo*****@localhost.not> wrote in message
news:TY***************@nwrddc02.gnilink.net...
You cannot convert an MDE. There is no reason, ever, to convert a back-end
to MDE... MDE "compiles" the code to make it unreachable but has no effect
whatsoever on Tables, their data, or the Relationships which are all that
should be in a back end. You will convert the MDB files.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replytogroup.com> wrote in message
news:33**************@news01.bloor.is.net.cable.ro gers.com...
Thanks for your prompt response Rick.
Just to be sure, do I create MDE files for both the FE and BE in A97 and
then convert them to A2K ?
Omey
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c0*************@ID-98015.news.uni-berlin.de...
> "Omey Samaroo" <no****@replytogroup.com> wrote in message
> news:fz***************@news01.bloor.is.net.cable.r ogers.com...
> > Dear Access Gurus,
> >
> > I am tasked with converting an Access 97 Database to A2K. I created
Macros,
> > switchboards and used the full feature of buttons on forms. The A97 is also
> > split (FE and BE). Are there any suggestions that I should keep in

mind
> > while attempting to do this task ?
> > What can I expect ?
>
> If your A97 file is error free (you can create an MDE successfully),

then
it
> should convert to 2000 and work without problems (other than those you
would
> have in any other A2K app).
>
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>



Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.