97 vs 2000 question

[davetek]

I have a MS Access 97 database with 5 users..
my first question is: are there any multi-user issues i should be aware of (i.e. can all users read and write to the database at the same time.?)
my second question is: one of the users has Access 2000...will it be possible for him to use the same database or does he need to use 97 as well...?

cheers....

 

[psemianonymous]

The short answers are:
1. There will be no problems with 5 concurrent users and using Access, assuming there are no (heretofore undiscovered) design flaws. Yes, I used the word "heretofore" and no, I don't know if it's a real word.

2. You can't use Access 97 and 2000 in a simple manner. The only way this will work is if:
-You SPLIT the database into data and forms/reports (i.e. backend and frontend)
-You then make a copy of the front-end and CONVERT it to 2000.
-Your 2000 user uses the 2000 front-end ONLY. His performance will be slower because...I don't know why, but it will be when stepping between JET versions.
-Your 97 users will use the 97 front-end.

So basically, it's a big hassle, but it's feasible.

Good luck.

 

[davetek]

cheers foolio....

 

[lameid]

Your 2000 user should be able to use the 97 file... When he opens it he needs administer permission to the database object and needs to tell it NOT to convert the database. I recommend you do this for the file BEFORE letting a user open it because they will likely just convert it. foolio12's recommendation works too, but is not necessary. The performance will suffer because the data is not in A2k's native format. The following applies to modules just in case you don't have any... DAO code you have will run slower in A2k even if you convert the database to A2k. You have to rewrite everything to get the performance back and then some.

 

[davetek]

thanks guys...