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

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

Post by RWQgS » Fri, 18 Nov 2005 11:55:03


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
 
 
 

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

Post by Rick Brand » Fri, 18 Nov 2005 12:14:26


You leave the common back end in 97 but make converted front ends in the new
version. If you want to make design changes to the front end using 2003 you do
have to convert a copy of it before you can do so.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

 
 
 

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

Post by Arvin Meye » Fri, 18 Nov 2005 12:18:55

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.


db
access
create a
convert
 
 
 

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

Post by Albert D.K » Fri, 18 Nov 2005 12:20:26


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.yqcomputer.com/

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

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
http://www.yqcomputer.com/
 
 
 

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

Post by Van T. Din » Fri, 18 Nov 2005 12:23:11

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.

--
HTH
Van T. Dinh
MVP (Access)