Access 97 executables and other versions of Access

[knee_boarder]

I have a few questions regarding Access 97 and other versions of Access as we
don't have time to develop .net versions of our Access 97 databases and some
of our users are moving to other versions of Office/Access - I work for a
local authority hence we tend to be very slow in moving to newer technology!

We've tried converting our Access 97 databases (lots of front end forms) into
Access 2000 but they fail and we don't want to install two versions of Access
due to having our applications delivered via Novell to the user (PC's are
locked down).

Do we need to purchase anything to produce stand alone executables which
could be used on any pc regardless of which version of Access is installed
instead of using mdb/mde files?

Would stand alone executables have all the functionality of mdb/mde files?

Would this overcome the Office XXX version problem?

Will newer versions of Windows become an issue (we're on a mixture of 2000
and XP at the moment)?

Are there any issues with going down this route?

Thanks

Steve

 

[Alex Dybenko]

Hi,
Access 97 to 2000 conversion should work smoothly, just check that you have
all references in place. and remove all unused references in Access 97 mdb
before converting
Furthermore - you can run Access 97 mdb on Access 2000.
Having Access 97 and 2000 running on same PC is not a problem, works fine

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[knee_boarder via AccessMonster.com]

What I completely forgot to mention is it's Access 97 forms linking to a sql
server database rather than everything being in Access 97 (using linked
tables and queries)

Hi,
Access 97 to 2000 conversion should work smoothly, just check that you have
all references in place. and remove all unused references in Access 97 mdb
before converting
Furthermore - you can run Access 97 mdb on Access 2000.
Having Access 97 and 2000 running on same PC is not a problem, works fine

I have a few questions regarding Access 97 and other versions of Access as
we

[quoted text clipped - 27 lines]

Steve

 

[Alex Dybenko]

Hi,
still should work ok. What kind of errors you are getting after conversion
(or during it)?

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

What I completely forgot to mention is it's Access 97 forms linking to a
sql
server database rather than everything being in Access 97 (using linked
tables and queries)

Hi,
Access 97 to 2000 conversion should work smoothly, just check that you
have
all references in place. and remove all unused references in Access 97 mdb
before converting
Furthermore - you can run Access 97 mdb on Access 2000.
Having Access 97 and 2000 running on same PC is not a problem, works fine

I have a few questions regarding Access 97 and other versions of Access
as
we

[quoted text clipped - 27 lines]

Steve

 

[Tony Toews [MVP]]

I have a few questions regarding Access 97 and other versions of Access as we
don't have time to develop .net versions of our Access 97 databases

And it will take significantly longer to develop the same app in a
..Net or other solution than it would in Access anyhow.

We've tried converting our Access 97 databases (lots of front end forms) into
Access 2000 but they fail

Like Alex stated they should convert relatively easily. Let us know
the error messages and we can help out.

and we don't want to install two versions of Access
due to having our applications delivered via Novell to the user (PC's are
locked down).

Well, you'd likely need to keep developing in A97 though until the
last of your users convert to A2000.

Hmm, A2000 is quite old. MS won't be delivering any more security
patches in about a year or so.

Do we need to purchase anything to produce stand alone executables which
could be used on any pc regardless of which version of Access is installed
instead of using mdb/mde files?

There is no such product.

Now what there is available is a runtime. But if you already have a
version of Access installed then there's no real need for the runtime.

Will newer versions of Windows become an issue (we're on a mixture of 2000
and XP at the moment)?

No.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

HIIIIIIIII!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
THIS IS REALLY WEIRD WHAT THE HELL ARE YOU GUYS ON ABOUT? WHAT DO YOU MEAN?
WHY DO YOU TALK ABOUT THIS STUFF?

This forum/newsgroup is meant for discussions on Microsoft Access.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[kenneth]

I have a few questions regarding Access 97 and other versions of Access as
we
don't have time to develop .net versions of our Access 97 databases and
some
of our users are moving to other versions of Office/Access - I work for a
local authority hence we tend to be very slow in moving to newer
technology!

We've tried converting our Access 97 databases (lots of front end forms)
into
Access 2000 but they fail and we don't want to install two versions of
Access
due to having our applications delivered via Novell to the user (PC's are
locked down).

Do we need to purchase anything to produce stand alone executables which
could be used on any pc regardless of which version of Access is installed
instead of using mdb/mde files?

Would stand alone executables have all the functionality of mdb/mde files?

Would this overcome the Office XXX version problem?

Will newer versions of Windows become an issue (we're on a mixture of 2000
and XP at the moment)?

Are there any issues with going down this route?

Thanks

Steve

 

[Gilbert Braquehais]

Le 29/10/09 13:50, dans 9e51099d65383@uwe, « knee_boarder via

What I completely forgot to mention is it's Access 97 forms linking to a sql
server database rather than everything being in Access 97 (using linked
tables and queries)

Hi,
Access 97 to 2000 conversion should work smoothly, just check that you have
all references in place. and remove all unused references in Access 97 mdb
before converting
Furthermore - you can run Access 97 mdb on Access 2000.
Having Access 97 and 2000 running on same PC is not a problem, works fine

I have a few questions regarding Access 97 and other versions of Access as
we

[quoted text clipped - 27 lines]

Steve

 

[nathalie devarre]

no spicke ingli

 

[joe]

HIIIIIIIII!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
THIS IS REALLY WEIRD WHAT THE HELL ARE YOU GUYS ON ABOUT? WHAT DO YOU
MEAN? WHY DO YOU TALK ABOUT THIS STUFF?

dsl je suis po ou je suis suis expliquer moi svp si ya quelqun qui
parle francais svp???????????????.......................

 

[zion gerald]

i have some questions about this how do u add friends

 

[Edmundo Vasquez]

Le 25/11/09 03:30, dans (e-mail address removed), « zion

 

[alex N]

Yeah steve. What will happen then??

 

[leo]

edyefeyf9eyGDFEFdefie fayefoyeweyw8fouhdufaiyfwi8uryeiwoiew