I have a student database in which many teachers need to update grades. Can Access be set up to allow more than one person to enter data (in different records)at a time? If so, how?

Yes it can by default. Just place the database on a server(shared drive). Just remember to make daily backups of the database. You should not have any problems sharing the database.

Do remember that you will not be able to make changes to the objects while another user has the database open.

Do you do any VBA coding in your forms at all?



Sal

Thanks for the advice; its good to be pointed in the right direction.

thutt

you can also split your database. create two database.
1. place all your tables in one database
2. Place all your forms, queries,reports on another
3. link your database (data tables) to your forms and queries

You should also check the options to assure that the database is set to 'Shared'. That is the default setting but it never hurts to verify things are going as planned. To do this in the database window go to Tools/Options/Advanced and choose the Shared in defalut open mode. I also have some code that can be placed in the autoexec macro that will always set your database to shared when it is opened - if you are interested let me know.

Kenny Alligood

Hi Kenny,

May I also have this code for shared access. Also, will it work if I choose the option to split my database?

Kindest Regards,
Nancy

Hi Nancy & Vin,

Unfortunately Kenny hasn't posted to p2p.wrox.com for over a year now (always enjoyed hearing from him), but the function he was referring to is one I posted on the "old" Wrox forum (circa 2002). I posted it as an event procedure. Just change the procedure header to someting like:

Public Function SetToShared()

and you can call it from an AutoExec macro.

Here is the thread:

http://p2p.wrox.com/archive/access/2002-09/35.asp

HTH,

Bob