suggest me in changing a normal Access databse to a muluser system.

Hallo this is Kiran,

I have a MS-Access database which I have been creating since 3 months.

When we have started this project we did not know that this could be a multi user system, but now they are asking this access database in a multi user environment.

Our IT professionals have suggested me that Access database can work as a multi-user database. So I want to use this is as a multi user database.

One of the requirements for my multi user database is – there should not be any difference from working online and offline.

So I have to copy the required data to the client system and show that data onto the form.



NOW I have a problem, Selecting the data from the server and inserting it into the client system is ok.

In my stand alone Access database the forms are directly connected to tables so I did not write any code to show data onto the form. Even now If have to write I know how to show one record onto the form.

But the problem with my main form is this form has another sub form on it and that sub form is in datasheet view to show the 1 to N relation between the main form and sub form.



How can I show all data’s onto a datasheet form.



So can any one suggest how to proceed with my MS-Access database in converting it as a multi-user system?



On Monday I have to start this, if any one can suggest me about this that would be great for me.



I am attaching my main form which has a subform in datasheet view. If you want to have a look how it looks? Please have a look. And please suggest me how to proceed.



Any way thanks for paying attention on my problem.



Kiran Karnati.

www.mvps.org is a good starting point.

Haiii
Thanks for your reply...
My problem is my forms are directly connected to the underlying tables. So if I open the access databse which is kept in the shared folder and has access from every computer, the that Access file is getting locked and no other user can open that from other computer it is saying that some user opened and locked the data.
May be it is possible to open Access database and work on it in multiuser environment but I think I have to adjust any property of the databse or forms to make it work , If you already did it can you pelase help me.
Thank you ,
Kiran Karnati.

Try reading the Access help, there is a chapter on multi-user use.

haii
Thank you Doug G I have read somethings and now I have Splitted my database and I put my back-end in a shared folder and front-end in every system which has access to that shared folder. it is working very good, with out changing anything it is working perfectly.
I want to say what I did to get this great functionality here so that others can know it.
I did only 2 very small modifications or setting changes, they are :

1. changed the 'Open mode' property of the database which I can find in the
Tools-> Options->Advanced->Openmode . to " shared"
2. For every form change the 'Record Locks' property to "No Locks" so that no records will be locked and if you are trying to open a form which shows the first record by default then those forms will also work perfectly.

as one of my forms is showing data , it was't opened from more than one system before I change the record locks property to " No locks".

Have fun there.
Kiran Karnati.