Can app written in 2003 be converted to 2000?

[larpup]

I've written an app in A2003 only to find out that some customers are
presently using A2000.
Rather than place a runtime on their computer, it would be more
convenient to convert appt to A2000 if possible. I know how to convert
the file format, but when running an A2000 instance, if receive
"recordset not updateable". Is this possible?

Lar

[Allen Browne]

Suggestions

1. Split the database
Whenever you have have multiple users accessing the database, you need to
give each one a separate front end, with linked tables to the shared data.
If that is a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

2. Decompile
Each version of Access uses a different binary for the compiled code. You
can avoid some of these problems by decompiling before you give the front
end to users with a previous version.

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then open it in Access 2000, open a code window, and choose Compile from the
Debug menu.

3. Service packs
This particular error can occur because the A2000 users are not up to date
with their Office or JET service packs:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"larpup" <la****@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

I've written an app in A2003 only to find out that some customers are
presently using A2000.
Rather than place a runtime on their computer, it would be more
convenient to convert appt to A2000 if possible. I know how to convert
the file format, but when running an A2000 instance, if receive
"recordset not updateable". Is this possible?

[Lyle Fairfield]

larpup wrote:

I've written an app in A2003 only to find out that some customers are
presently using A2000.
Rather than place a runtime on their computer, it would be more
convenient to convert appt to A2000 if possible. I know how to convert
the file format, but when running an A2000 instance, if receive
"recordset not updateable". Is this possible?

Access has a method called
"ConvertAccessProject"

>From it's name one might think it is designed for ADPs only. But 2003

help talks about converting Access Files and shows MDBs in its
examples.

It's used as follows:

Sub ConvertNorthwind()
Application.ConvertAccessProject "northwind.mdb", "converted.mdb",
acFileFormatAccess2000
End Sub

The "northwind.mdb" mentioned is a copy of Northwind that I had
previously converted to Access 2003.
Now I am using that code (from another db) to convert that Access 2003
to Access 2000. It !!!!!!!!seems!!!!!!!! to handle all the
decompilation etc mentioned by Alan.

The new db runs swimmingly on my one and only Access 2000 machine. Of
course, this may be an anomaly and it may run satisfactorily in Access
2000 no where else in the world. Perhaps someone will try it and
report. Copying and pasting the code, replacing the file names and
running it will take at least a minute?

[larpup]

haven't tried yet as i am busy at work, but will take up your
suggestions later. thank you so much for you professional advice. I so
very much appreciate it.

Very truly yours,

Lar

Allen Browne wrote:

Suggestions

1. Split the database
Whenever you have have multiple users accessing the database, you need to
give each one a separate front end, with linked tables to the shared data.
If that is a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

2. Decompile
Each version of Access uses a different binary for the compiled code. You
can avoid some of these problems by decompiling before you give the front
end to users with a previous version.

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then open it in Access 2000, open a code window, and choose Compile from the
Debug menu.

3. Service packs
This particular error can occur because the A2000 users are not up to date
with their Office or JET service packs:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"larpup" <la****@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

I've written an app in A2003 only to find out that some customers are
presently using A2000.
Rather than place a runtime on their computer, it would be more
convenient to convert appt to A2000 if possible. I know how to convert
the file format, but when running an A2000 instance, if receive
"recordset not updateable". Is this possible?