multiple users to access/update database question

[EBee]

I just have a question regarding multiple access ( meaning multiple users to access,add,modify,search,print data at the same time to one .mdb file.

I have a Hotel guest database in a Access97 . I am more familiar with VBA (access97) and it is a lot easier for me to create a form and report in access than VB, though I am starting creating DAO/ADO. If I have multiple users wants to access the form that I created in access, it is not possible at this time. Only one user at a time to update the record.


What do i need to change so multiple users can access the database and able to update files in it. Do I create a DAO and have it point to the file( is that even possible), or is there a way that i can change some settings in my access97 database so it can be modified by multiple users at the same time.

thanks
erwin

 

[mikey69]

You need to split the database into front and back ends. Then multiple front ends can use a common back end. there is an option in the tools menu called database splitter.

You should also search the help file for splitting a database. It is well documented.

 

[EBee]

thank you very much , exactly what I am looking for, do you know any other site that i can get more info about this. Or any good books i should checkout

thanks once again
erwin

 

[mikey69]

There's a guy called Woody Leonhard who runs a whole string of sites devoted to Microsoft applications. Think it's

http://www.wopr.com.

The one you need is called Woody's Access Watch. the text is mostly written by Helen Feddema and she's written books about Access. Her home page is

http://www.helenfeddema.com.

Try it.

Otherwise, look for the Que book, or look in Microsoft press. It helps if you are near a bookshop. I'm actually not, so I can't easily be more specific.

With Access 97, Microsoft published a book called Developing Applications. The printed version came with the Developer Edition and there was an electronic copy on the Professional Edition of MS Office. You should try to find it. It's really good if you write Visual Basic.

Hope all this helps - good luck.