Have there been functions in Access 2.0 which have been removed in version XP 2002?

[Stefan Frank]

Hello community!



I have let a database of version 2.0 been converted to Access XP (2002). The
programmer said 'there are functions in Access 2.0 that are not available
anymore in version 2002'.

The subject also comes up in relation with the 'construction of a series
letter'.



That would mean that Microsoft has removed functions from one version to the
following. Unfortunately I am not a great Access programmer, so I can not
say if that is correct.



Maybe some more background information - with the old database (2.0) you
could draw up a series letter directly. In the new version of the database
firstly there is an Excel table been generated, than a word document uses
this table to generate the series letter.

I can not imagine that this method meets the Microsoft philosophy. It makes
the procedure a lot more complicated.



What is your experience? Have there been functions in Access 2.0 which you
have to find bypass-solutions for in Access XP as the functions are not
available anymore?



In advance thanks a lot for your answers.



Stefan

 

[Van T. Dinh]

I can't remember all functions in Access 2.0 (there are certainly major
changes in syntactical elements since Access 2 uses Access Basic and since
Access 97, VBA is used instead) but shouldn't the programmer who converted
the database fix these _minor_ conversion problems??? (of course, you will
have to pay for his/her time).

It sounds too much like passing the buck to me and it is simpler to blame
Microsoft than fixing the problems.

I am not sure what you meant by "series letter" (MailMerge?) but it doesn't
sound right that Access has to create an Excel to be used as the Source for
Word. In general, if the data comes from an Access database, Access
certainly can supply the data to Word directly rather than via Excel.

 

[Tony Toews]

I have let a database of version 2.0 been converted to Access XP (2002). The
programmer said 'there are functions in Access 2.0 that are not available
anymore in version 2002'.

Yes but these were functions which should never have been allowed in
queries in the first place. Such as the capability to delete a file
in a query.

None of these have ever caused me a problem.

So let the programmer be a bit more specific as to exactly what is not
available.

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