Record already in use...

[Grafixx01]

So the database that I have now has a front and back-end. However, the issue that I'm running into is this:

1. Does MS Access allow users to access the same record at the same time?

2. If this is possible, I need to put in a check that says "is this record already opened by another user"? If this does return a "yes", then a message should be displayed to the user who is trying to access the record of "This record is already being used by (network user name). You can only view this record in read-only status where you cannot edit it. if you would like to edit it, please locate the current user who has it opened and ask them to close it, or you can wait until they are through."

Any ideas?

 

[Uncle Gizmo]

Generally you don't have to do anything, MS Access does this automatically. However I think you do have some level of control over it, but I have never had to take advantage of this myself.

 

[Grafixx01]

Generally you don't have to do anything, MS Access does this automatically. However I think you do have some level of control over it, but I have never had to take advantage of this myself.

Ok, so it should do it automatically. Wonder if I can change the message that it shows though? So it'll show the user name of the person who is currently on the record?

 

[anthonys]

vaguely remember using this in the past to solve a similar issue

if me.dirty = true then msgbox ......... (me.dirty will return true if someone is editing the record)

can't find that actual code but i think the function should help

Hope thsi helps.

Ant

 

[Grafixx01]

Thanks,

I'll look into that. Though if Access will let them look at it in a 'read-only' status, that should be fine, just wanted to edit the message box that comes up with a little more to it than just "record x is currently locked".