Hello guys, i have MS Access Database located on windows 2003 server, and other users with windows XP got a shortcut to that Database, the problem is that they cant access the Database at the same time, only one user can a time, but they said before they could do it, so is it something to do with the windows 2003 side!! or the client side!! or something to do with MS Access?!!

any hint will be appreciated..

Hello guys, i have MS Access Database located on windows 2003 server, and other users with windows XP got a shortcut to that Database, the problem is that they cant access the Database at the same time, only one user can a time, but they said before they could do it, so is it something to do with the windows 2003 side!! or the client side!! or something to do with MS Access?!!

any hint will be appreciated..

From MS help docs:

Make sure the Access database is set to open in shared mode, which is the default setting.

How?

On the Tools menu, click Options.

On the Advanced tab, under Default open mode, click Shared.

i will check that on sunday thnx man