Migration from 97 to 2003 - users accessing same db on both NT & X

[Ed H]

I thought I read somewhere that you could choose not to convert the access db
which would be okay other than you would not be able to take advantage of
functionality 2003 brings in.

Dilema is we are in the process of upgrading from NT (Office 97) to
XP(Office 2003) and we will have people from both worlds that want to access
(pardon the pun) the same data. I thought I read it was possible to create a
2003 front end that went after a 97 format DB. When I choose to not convert
the database, it says it is read only and I can not save my VB changes.

Any thoughts

 

[Arvin Meyer [MVP]]

That's true of all versions of Access, you can read and write the data from
earlier version(s), but you cannot change the definitions in an earlier
version.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D.Kallal]

Dilema is we are in the process of upgrading from NT (Office 97) to
XP(Office 2003) and we will have people from both worlds that want to
access
(pardon the pun) the same data. I thought I read it was possible to
create a
2003 front end that went after a 97 format DB. When I choose to not
convert
the database, it says it is read only and I can not save my VB changes.

Don't try and convert the data part, just leave it as access 97. what you do
is split the database (do this in a97).

You then wind up with two parts, the data part (you leave in a97), and the
application part. You simply convert the application part to a2003, and give
that to a2003 users. You give a a97 application part to a97 users, and they
both can happy use the same data.

If you are new to splitting, then you can read the following :

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Even after you get eveyone on a2003, you need to split if you plan to use
this data in multi-user mode anyway...

 

[Van T. Dinh]

Is your database application split into Front-End and Back-End?

The Back-End can stay in A97 (JET 3.5) file format. You will need 2
versions of the Front-End, one for Access 97 users and one for Access 2003
users.

If you use Access 2003, you can only modify the Front-End file in A2000 or
A2002/A2003 file format. If necessary, you can convert a copy back to A97
file format for A97 users.