473,387 Members | 1,492 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Compiling to A2000 in A2003... problems

Hi

I am using A2003 on XP. The client has A2000. So I have ensured that I have
developed based on A2000 and compiled as such.

I have found that in a number of cases now, I have used (what I thought) was
fairly standard methods & properties, but as it turns out, not so. I
install on the client's machine and recompile and have found that a method
is just not recognised in A2000. eg: in A2003, docmd.OpenReport includes
the 'OpenArgs' parameter. In A2000, there is no such parameter available.

I am wondering is there a way that when using A2003 (apart from what I'm
already doing), to ensure that I don't use methods that seems to only be
available in A2002-3 and not in A2000?

TIA
Michelle
Nov 12 '05 #1
4 1672
On Wed, 28 Jan 2004 19:31:20 +1000, "-Michelle-" <mi********@yahoo.com> wrote:
Hi

I am using A2003 on XP. The client has A2000. So I have ensured that I have
developed based on A2000 and compiled as such.

I have found that in a number of cases now, I have used (what I thought) was
fairly standard methods & properties, but as it turns out, not so. I
install on the client's machine and recompile and have found that a method
is just not recognised in A2000. eg: in A2003, docmd.OpenReport includes
the 'OpenArgs' parameter. In A2000, there is no such parameter available.

I am wondering is there a way that when using A2003 (apart from what I'm
already doing), to ensure that I don't use methods that seems to only be
available in A2002-3 and not in A2000?

TIA
Michelle


Actually, I've been wondering the same thing, and besides developing in the
older version to make sure you don't try to use newer features, I don't really
know a way. I can tell you the few things I know, though.

1. The OpenArgs parameter for reports was added in Access 2002.
2. The Replace function was added in Access 2000.
3. The Recordset property of forms was added in Access 2000.

And finally, I find Access 2000 to have too many bugs to be worth using,
myself, so if you can try to convince clients to at least upgrade to 2002,
that will save you some hassle.
Nov 12 '05 #2
Thanks very much for your information. It's much appreciated.

Michelle

PS: Have tried convincing clients to upgrade, but it's not happening any
time soon.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:ov********************************@4ax.com...
On Wed, 28 Jan 2004 19:31:20 +1000, "-Michelle-" <mi********@yahoo.com> wrote:
Hi

I am using A2003 on XP. The client has A2000. So I have ensured that I havedeveloped based on A2000 and compiled as such.

I have found that in a number of cases now, I have used (what I thought) wasfairly standard methods & properties, but as it turns out, not so. I
install on the client's machine and recompile and have found that a methodis just not recognised in A2000. eg: in A2003, docmd.OpenReport includes
the 'OpenArgs' parameter. In A2000, there is no such parameter available.
I am wondering is there a way that when using A2003 (apart from what I'm
already doing), to ensure that I don't use methods that seems to only be
available in A2002-3 and not in A2000?

TIA
Michelle

Actually, I've been wondering the same thing, and besides developing in

the older version to make sure you don't try to use newer features, I don't really know a way. I can tell you the few things I know, though.

1. The OpenArgs parameter for reports was added in Access 2002.
2. The Replace function was added in Access 2000.
3. The Recordset property of forms was added in Access 2000.

And finally, I find Access 2000 to have too many bugs to be worth using,
myself, so if you can try to convince clients to at least upgrade to 2002,
that will save you some hassle.

Nov 12 '05 #3
On 28 Jan 2004 14:25:27 -0000, Mike Storr wrote:
Path: news20.bellglobal.com!nf4.bellglobal.com!nf1.bellg lobal.com!nf3.bellglobal.com!news.uunet.ca!cyclone .bc.net!news.alt.net!news.bananasplit.info!news.di zum.com!sewer-output!mail2news
Date: 28 Jan 2004 14:25:27 -0000
Message-ID: <4PWOUUKO38014.3926736111@anonymous>
From: An****************@See.Comment.Header (Mike Storr)
Subject: Re: Compiling to A2000 in A2003... problems
Newsgroups: comp.databases.ms-access
X-No-Archive: Yes
References: <bv***********@otis.netspace.net.au>
Comments: This message did not originate from the above address.
It was remailed by two or more anonymous mail services.
Send complaints of REAL abuse to remaileradmin at optonline dot net.
Mail-To-News-Contact: ab***@dizum.com
Organization: ma*******@dizum.com
Lines: 54
Xref: nf1.bellglobal.com comp.databases.ms-access:783579

-Michelle- wrote:
Hi

I am using A2003 on XP. The client has A2000. So I have ensured that I have
developed based on A2000 and compiled as such.

I have found that in a number of cases now, I have used (what I thought) was
fairly standard methods & properties, but as it turns out, not so. I
install on the client's machine and recompile and have found that a method
is just not recognised in A2000. eg: in A2003, docmd.OpenReport includes
the 'OpenArgs' parameter. In A2000, there is no such parameter available.

I am wondering is there a way that when using A2003 (apart from what I'm
already doing), to ensure that I don't use methods that seems to only be
available in A2002-3 and not in A2000?

TIA
Michelle


Go tools options and select Turn Off New Features Added after 2000. Simple.

You could also look this up in Help.


This is the second time I've seen my name used in a remailed message that
is not mine. Is it insecurity, or immaturity that requires this person to
hide behind others?

--
Mike Storr
veraccess.com
Nov 12 '05 #4
An****************@See.Comment.Header (Mike Storr) wrote:
Comments: This message did not originate from the above address.
It was remailed by two or more anonymous mail services.
Send complaints of REAL abuse to remaileradmin at optonline dot net


This posting is a forgery. Mike Storr did not post it.

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
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: \(Bradley | last post by:
In an A2000 ADP I cannot edit data in an MS-SQL2000 view that has a simple JOIN in it. However I can edit the data in the same view if I open it in A2003 or SQL Query Analyser/etc. I understand...
6
by: Tim Marshall | last post by:
This is for a personal "fun" application I've been toying with for years first in A97, now in A2003. It's just for me and my friends who aprticipate in a weird hobby to use. My friends have...
3
by: Tim Marshall | last post by:
I have a user who has what I assume is a VB application: it's opened with an exe file, there are numerous dll files in the directory in which the executeable resides, along with an mdb file that I...
1
by: Paul Brady | last post by:
I have A97 and A2K on my computer at home, on which I do volunteer work for several databases on our county park system. One of the clients uses A97, and the rest, A2K. The A97 user is...
17
by: rdemyan via AccessMonster.com | last post by:
With A2003, I'm having trouble accessing files in a folder on another computer where back-end files, update files, etc are located. Here's the scenario: 1) Computer #1 - A2003 2) Computer #2 -...
1
by: larpup | last post by:
I've converted my frontend and backend from A2003 to A2000. Data is linked, however, I receive "recordset not updateable". Additionally my code stops on a simple function which turns data in a...
6
by: tombsy | last post by:
Hello Group. I work for a company who is about to embark on a long awaited Office upgrade from Office 97 to Office XP. Office XP comes with Access 2002. I am an accomplished Access developer...
0
by: terry | last post by:
Has anyone had any experience with concurrent (multi-user) use of an A2000 front end and an A2003 front end on the same linked set of tables? The reason I'm asking is that we've got a number of...
1
by: Fred Zuckerman | last post by:
I have a database on a shared drive. It has user level security (ie: mdw file). It was created in A2000 and works fine when opened on workstations with A2000 installed. Some workstations have...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.