How can multi-users access a ms access 2007 database

[revival786]

I have a MS access database 2007. I need to make it accessible to multi-users simultaneously so that all can print , mail ad update it while all the database copies must be updated.

[zmbd]

You split the database.
Be carefull here, although the wizard does a bang-up job of splitting, there are ways of optimizing the tables between the front and back ends, queries will generally stay on the front-end and so should all of your forms.

IMHO: Only a PROPERLY NORMALIZED database should be split; however, I've seen some very poorly designed databases split and they work quite well.

Here is a link to the basic information: http://office.microsoft.com/en-us/ac...010342026.aspx