Multi-user

[shez]

What steps should I take to make an access database multi-user? The mdb/mde will be installed onto a server and multiple users will access it??

 

[M8KWR]

what i do is create my table within one mdb file, then have another mdb file which is linked to the original one, within this one i will create the forms etc.

Once the forms are complete, then i would convert this to an mde file for distribution.

The reason for this, you are able to make changes to the forms without kicking people out of access. Then you can distribute the new file accordingly.

The only reason why you would have to kick people out is when you are adding a new field into a table.

This way works well for me, with th mde file the users can not edit the forms. They can create queries, and mess about with the tables, but you could hide the tables in the mde file.

hope this helps

 

[shez]

Thanks M8KWR. I know there is data splitter functionality within access, is this what you meant? or simply just create a new mdb and import all tha tables into there then link the tables into the mdb that will hold the forms etc?

I tried to create an mde file but got the following error: Microsoft access was unable to create an mde database. (This error is usually associated with compiling a large database into an MDE file.)...My database is not very big and only has about 15 forms and 12 tables!! Any ideas's about this?

 

[M8KWR]

i did mean create a new one, i have not used the spliter myself.

The error message i am unsure. Try going into one of your form, and then go directly to the code, and compile it. Sometimes a mde file will not be created due to a error within the code. That could be it.

But saying its to large, could mean something else altogether.

As a last result, you could try creating an mde file with all the table empty, and see what happens then, but it should work, i've created an mde file with more then 15 tables with no issues. But if you split the db, then you would only be creating an mde file with linked tables only.

Hope this helps.

 

[shez]

Thanks a lot M8KWR. Once I compiled it successfully the mde file could be created.

I wonder if you would also know how I could resolve a record locking issue. I would like to ensure that either two users cannot update the same record at the same time or there is a mechanism in place where the record is locked when the first user accesses it, then updated, and then the second users update can go through (after the first has been processed)...I am using a recordset in the code to update the records...

Thanks.

 

[M8KWR]

i must amit i am lazy when it comes to this, i use the properties within the form.

I know its not the safest way, but it works for me. I seem to have more issues when i try and lock down records when a user is in it, then it i keep all records open, if that make sense.

I did read some code that someone did to do this, but i can not find you the link, sorry.

But i know its out there, i would advise you to post another question, you should get an answer.

 

[shez]

How do you set this within the forms properties - ie - what property is set?? I didnt realise I could do that!! Sounds interesting (and easy!!)

Thanks.

 

[M8KWR]

go into the form, and make sure you are showing the form properties, then click on the tab data, its under "Record Locks".

Hope this helps...