2000 vs 2003

[Guest]

Hello,

I built a database in Access 2003 and converted it to 2000. For some odd
reason when the 2000 users tried to use the database that had problems
operating the database due to VBA Code and Macros.

Could anyone provide help to change the code from 2003 to 2000 if I put it
on the web or email it to you. Thanks

 

[Tony Toews]

I built a database in Access 2003 and converted it to 2000. For some odd
reason when the 2000 users tried to use the database that had problems
operating the database due to VBA Code and Macros.

Could anyone provide help to change the code from 2003 to 2000 if I put it
on the web or email it to you. Thanks

There are only a few new things in A2003 that don't work in A2000.
What exact error messages or problems are you having?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

In 2000,

I did a macro and it is not reading set values and in VBA in is not reading
the right function

If possible I can send you screenshots in 2000 or the code. Let me know.

thanks

 

[Albert D.Kallal]

Could anyone provide help to change the code from 2003 to 2000 if I put it
on the web or email it to you. Thanks

You should not have to change anything.

HOWEVER!! you REALLY want to do a de-compile..and re-compile on the a2000
box.

I currently have ONE client left with a2000, and I have found that deploying
my a2003 application (in a2000 format) will often be so breakage prone that
some screens don't even display half the fields. I VERY quickly found out
that due to binary code differences, you have to do a de-compile, and a
recompile on the a2000 box.

THIS IS EVEN WHEN you make a mde from the a2000 file on the a2000 box!!!!
In other words, if you take the original mdb file from the a2003 box (in
a2000 format), move it to the a2000 box and make the mde..the mde will also
often be FULL OF problems.

Again:

when moving the application, do a de-compile on the a2000 box.

I suppose it is possible that you could do a de-compile on the a2003 box
(just make sure you shift key in...no forms/code runs..and you exit right
away).

A number of posters have also experienced the above.

So, once you do a de-compile..then you should have no problems on the a2000
box...

 

[Tony Toews]

I did a macro and it is not reading set values and in VBA in is not reading
the right function

If possible I can send you screenshots in 2000 or the code. Let me know.

Please post the details in text format in the newsgroup. Many folks
won't open attachments in newsgroups.

And as I've hardly ever worked with macro's I have little experience
with them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm