Multiuser or User Issue?

[Core]

Hello,

I recently designed a database for work. The database consisted of tables, forms, reports, queries, etc etc

The database was for collating feedback form responses. There where seven different feedback forms for different programmes we offer. Each feedback form had its own table, forum, queries, reports.

I stored the database on the network. I put links to the file onto two employees desktops. Said employees began to data input onto the database. Each employee was given different forms and thus was accessing different tables and forms within the database.

By the end of the day one had done 177 and the other 88 forms. However, the data from the user entering 88 was not there. but the 177 records were.

As I understand databases are multiuser and there should not have been an issue with them both accessing the database, especially as they were using different tables.

Is there any reason for this? Could this be a mistake they have made or myself?

Any feedback would be greatly appropriated.

Regards,

 

[RossWindows]

Without looking at your code, I can't say if it's because of the multiple users causing corrupted data, or if it's the code itself.

Regardless, in your type of scenario with a database being accessed by multiple users over the network, it is a GOOD idea to split your database into a front-end and back-end. Search the forum for "splitting database" or along those lines.

With multiple users accessing the same .mdb file, it's not a matter of IF it will get corrupted, it's a question of WHEN.

Good luck!

 

[Core]

Without looking at your code, I can't say if it's because of the multiple users causing corrupted data, or if it's the code itself.

Regardless, in your type of scenario with a database being accessed by multiple users over the network, it is a GOOD idea to split your database into a front-end and back-end. Search the forum for "splitting database" or along those lines.

With multiple users accessing the same .mdb file, it's not a matter of IF it will get corrupted, it's a question of WHEN.

Good luck!

Would you mind if I sent you the code, there isn't a great deal.

 

[boblarson]

Read this about split databases. You need to know that the users should have a copy of the frontend on their computer and the backend is linked to that frontend and is on the server. Are you certain that each was working on the same database and not that one had a copy of the database on their machine (the whole thing) which then they were putting in the 88 records and that is why they aren't in the other one. That is a very common thing to happen.

 

[Core]

I could split the databases.

Hmm I have been pounding the post about the code.

Here is my form, you can see the radio options:



I used this code to convert this into a text for the fields within the database:

Private Sub FrameQ5_AfterUpdate()

curvalue = FrameQ5.Value
Call subValue(curvalue, Q5)

End Sub

here what it calls:

Public Sub subValue(opValue, opQuestion)
'Takes the value of the option group passed and the name of the text box required
'and translated the numerical value into a text value to be stored on the table

  Select Case opValue
      Case 1
         opQuestion.Value = "Strongly Agree"
      Case 2
         opQuestion.Value = "Agree"
      Case 3
         opQuestion.Value = "Disagree"
      Case 4
         opQuestion.Value = "Strongly Disagree"
      Case 5
         opQuestion.Value = "Don't Know"
   End Select
End Sub

When the form loads a record it does the reverse to fill the radio's

Think that could have caused it? They could be calling the same functions I mean?

Jeez I am a newb

Many thanks,

 

[RossWindows]

I would still start with splitting the database;
That could solve the problem by itself, not to mention it's good to do anyway.

Also, it IS the 6th commandment.

 

[Core]

I would still start with splitting the database;
That could solve the problem by itself, not to mention it's good to do anyway.

Also, it IS the 6th commandment.

So you don't think it's the code?

I just wanted to be sure because, if I split the database into front/back end, which is fine I can do that, I dont want to put them to work to find one persons records go missing again.

The are both female and much older than me.... I'll be mince meat!!!!!

Thank you though I will try the splitting out.

 

[boblarson]

To have 88 records go missing really still strikes me as that they were both entering data into TWO distinct databases and you haven't found the one the other person was entering into. I know it sounds absurd but it really could be just that. I've seen that happen easily. Did you create the shortcut to the file yourself and then send each the same shortcut? Or did you create a shortcut from each user's computer? If the latter then it is possible you linked to the wrong database file on the one who is missing the 88 records. Something to check on anyway.

 

[RossWindows]

Tell you what;
If you split the database and one user's records still go missing, go ahead and remove any confidential data from the tables, and pack up the whole thing (front-ends, back-end, and each user's shortcut) into a zip file and post it.

 

[Core]

To have 88 records go missing really still strikes me as that they were both entering data into TWO distinct databases and you haven't found the one the other person was entering into. I know it sounds absurd but it really could be just that. I've seen that happen easily. Did you create the shortcut to the file yourself and then send each the same shortcut? Or did you create a shortcut from each user's computer? If the latter then it is possible you linked to the wrong database file on the one who is missing the 88 records. Something to check on anyway.

I set up the short cuts myself, but I dunno, I could have. The database was on her computer before being moved over to the network... which doesn't sound good!! I'm sure I checked though.... oh dear I really hope it isn't this I will look like a fool!!!

I'll be sure to double check though and thanks for taking the time to response I really appreciate it!

Tell you what;
If you split the database and one user's records still go missing, go ahead and remove any confidential data from the tables, and pack up the whole thing (front-ends, back-end, and each user's shortcut) into a zip file and post it.

Okay

BTW Just to confirm, I never did the split before but I read about it a moment ago and seems easy enough. the front end basically replaces the shortcut right? Front on local pc back on server?

Many thanks both of you!

 

[RossWindows]

That's basically it.
The back-end only contains tables
The front-end contains:
Links to the back-end tables.
& Everything else like queries, forms, reports etc.

Yes, like you said; Most folks put the front-end directly on each user's desktop.
There are other options, but I don't want to introduce advanced tactics to you just yet.