MultiUser Environment Help

[daherb]

Hi, i am having some major problems so i thought i would ask you guys out there for some help because i am starting to bang my head against a brick wall.

I have a simple database, well i have 3 but the problem is only occuring on 1. each of these databases sit in a shared folder on the company network. I am trying to allow multiple users access this database but every time a second user tries to open the database they are unable to get access and receive this message

The table 'MSysAccessObjects' is already open exclusively by another user

However i have set the default open mode to be shared.

can anyone help as i really need this database to open in shared mode

 

[MStef]

Hello daherb!

Maybe your first user open DB as exclusive.
He can do it in "OPEN" dialog box. Ask them
"how he open db".

 

[daherb]

after first getting this problem i began troubleshooting by using two computers myself, both machines are opening the database in shared mode but still i have the problem, i just cant get in at the same time.

 

[jrjr]

Shot in the dark but have you tried compact and repair?
It doesnt really sound like network permissions so I tend to think DB trouble.

Edit:
better make a backup

 

[seth_belgium]

Have you considered splitting the database into two databases, one that is back-end and contains only the tables and another one that is front-end and contains everything else and only had linked tables to your back-end database.

Every user can then take a copy of the front-end database and store it on his or hers own drive and work in that db. I think this might be a sollution to your problem.

Greetz,

Seth

 

[neileg]

Is the system generating the .ldb file when the application is opened? If there is no .ldb then you will get problems. It is possible fro a lack of network permissions to cause this.

 

[klhutch]

Did the items listed in the post work?

Hello: I was wondering if the splitting of the database helped with your multiuser environment database problem. I am having a similar problem but with it locking so multiusers cannot access it. I have taken it to unsure it is shared, ensured everyone hass no restricted access but still get certain erros with users.

klhutch

 

[jrjr]

Is the system generating the .ldb file when the application is opened? If there is no .ldb then you will get problems. It is possible fro a lack of network permissions to cause this.

Wouldn't you think that since the DB's are all in the same folder, and 2 of them work, that permissions are ok? If I read the original post correctly that is......

 

[neileg]

Wouldn't you think that since the DB's are all in the same folder, and 2 of them work, that permissions are ok? If I read the original post correctly that is......

You may be right, but the post says that they are all in a shared folder, not that they are all in the same shared folder. Ambiguous, then.

 

[daherb]

Cheers guys for all your input, the situation as it stands now is as follows.

It has nothing to do with permission on the network or the shared folder as all users have full permissions of read, write, execute.

I have split the database into a BE and FE configuration which has improved the situation as now each user has a copy of the FE configuration on their own hard drive. This allows everyone to connect to the database at the same time. However the situation is still not resolved because now what happens is that as soon as someone has the input form open no one else can open the form from their FE version as it says the table is already open exclusively by another user.

So any other ideas would be greatly appreciated. If i manage to solve the problem i will post the answers here for other peoples future reference.

 

[jrjr]

You could try creating a new blank DB and import the tables from the original BE. Then rename the original and give the new one the original's name. Make a backup first though just in case!!

Backup Backup Backup

 

[daherb]

already tried that and it doesn't change the situation unfortunately.

 

[jrjr]

Did you try the front ends too or did you do it before the split?

 

[Big2]

daherb, make sure that you dont have the input form linked to any tables. Only have it linked on the submition of your "input form".

Your input form shouldnt be showing much data, as it is an input form, so all listboxes that you have need to be linked to the corresponding tables which hold their values. But every other textbox etc needs to be unbound.

Then when they click to save or submit, in code you then send all these values and update the corresponding tables.

Hope ive described it clear enough, let me know if you still have any problems.

 

[daherb]

Thats an interesting idea, i haven't thought about that, i simply created forms using the wizards. think i might have a look at doing that. Only problem is i am still going to need a form that allows users to read and edit existing enquiries. which at the moment i cant do because of this conflict that i'm getting

 

[Big2]

Well then you produce an edit mode. You should create most your forms manually to stop conflicts and so that you know exactly what you are putting on them.

Therefore have a form that people can view all records, then an edit button which will then pull that record from the backend so you can modify it and then when saved it is sent back to the backend. During this time people can still view all records in the database. (possibly even the one your editing, although they cant modify that record because it is currently being edited).

Again, not sure if this clears things up a little for yourself, but hope its helped in some way.

 

[daherb]

Everything you have said makes sense to me and thank you very much for your input.

Its been quite a while since i got indepth with writting databases about 2 years now and i was always working in access 97 until now. The thing i am having trouble with at the moment is how to go about creating the form without linking it to any tables other than the submit button, i will probably figure out how to create the form manually without too much hassle but any info on the code required to make the button work would be very much appreciated.

 

[Big2]

Go to the database window that holds all the queries/tables/forms etc, click on the forms tab on the left and then click on New at the top, and then click Design View then OK.

A blank form will then open with all the objects etc on a toolbar for you to select and drag onto your form, just like any other development tool.

 

[daherb]

thats great i have remembered how to design an unbound form but i dont know how to write the code for the submit button, any chance you could give me a heads up on this part

 

[Big2]

Ok quick example i rumaged up:

Dim Course As Recordset
Dim StrMultipleCourse As String

Set Course = CurrentDb.OpenRecordset("SELECT * FROM Tbl_Course", dbOpenDynaset)

StrMultipleCourse = "[CourseName]=" & "'" & txtCourseName & "'"
Course.FindFirst StrMultipleCourse

If Course.NoMatch Then     'if there are no multiple fields then its ok to add the new user to database
    
With Course
        .AddNew
        ![IN] = InTotal
        ![OUT] = OutTotal
        ![NoOfHoles] = Holes
        ![CourseName] = txtCourseName
        ![SSS] = txtSSS
        ![PAR] = OverallTotal
        .Update
End With

The StrMultipleCourse string is useful so that we cant add identical records that have the same name etc.

Basically opening a recordset, the ![field] are your fields in your table and = InTotal is the name of your textbox.

Have a play around before trying to get the whole thing working, just get one field working and then add the rest once you've figured it out.