Help With Table Lock, Please.

[Kissi Asiedu]

I have access 97 database being run by multiple users. It was working fine
until I created a form and a macro to open the form at start-up. Now only
one user can open the table. If a second user attempt to open the same table
at the same time, there is an error message that says "table cannot be lock,
it is being used by user A on machine C or you may not have permmision to
open table". Does anyone have an idea how to solve this problem? I want
multiple users to be able to add records to a table simultaneously.

Thanks.

[Salad]

Re: Help With Table Lock, Please.

Kissi Asiedu wrote:[color=blue]
> I have access 97 database being run by multiple users. It was working fine
> until I created a form and a macro to open the form at start-up. Now only
> one user can open the table. If a second user attempt to open the same table
> at the same time, there is an error message that says "table cannot be lock,
> it is being used by user A on machine C or you may not have permmision to
> open table". Does anyone have an idea how to solve this problem? I want
> multiple users to be able to add records to a table simultaneously.
>
> Thanks.[/color]

Open up the Form's property sheet, click on Data tab. What is the
RecordLocks set to?

[Salad]

Re: Help With Table Lock, Please.

Kissi Asiedu wrote:[color=blue]
> I have access 97 database being run by multiple users. It was working fine
> until I created a form and a macro to open the form at start-up. Now only
> one user can open the table. If a second user attempt to open the same table
> at the same time, there is an error message that says "table cannot be lock,
> it is being used by user A on machine C or you may not have permmision to
> open table". Does anyone have an idea how to solve this problem? I want
> multiple users to be able to add records to a table simultaneously.
>
> Thanks.[/color]

Open up the Form's property sheet, click on Data tab. What is the
RecordLocks set to?

[Kissi Asiedu]

Re: Help With Table Lock, Please.

The RecordLocks is set to "No Locks"
"Salad" <oil@vinegar.co m> wrote in message
news:VnjCe.6031 $BK1.3335@newsr ead3.news.pas.e arthlink.net...[color=blue]
> Kissi Asiedu wrote:[color=green]
>> I have access 97 database being run by multiple users. It was working
>> fine until I created a form and a macro to open the form at start-up. Now
>> only one user can open the table. If a second user attempt to open the
>> same table at the same time, there is an error message that says "table
>> cannot be lock, it is being used by user A on machine C or you may not
>> have permmision to open table". Does anyone have an idea how to solve
>> this problem? I want multiple users to be able to add records to a table
>> simultaneously.
>>
>> Thanks.[/color]
>
> Open up the Form's property sheet, click on Data tab. What is the
> RecordLocks set to?[/color]

[Salad]

Re: Help With Table Lock, Please.

Kissi Asiedu wrote:
[color=blue]
> The RecordLocks is set to "No Locks"[/color]

OK. Is the form's recordsource a query? If so, go to the form's data
tab, click on Recordsource and view it. Right click somewhere in the
query and see if there are any locks on it. IOW, check the properties
to it. Also, check the User's permissions in the query/recordsource.
See if the Run Permissions are Users or for a specific user.

[color=blue]
> "Salad" <oil@vinegar.co m> wrote in message
> news:VnjCe.6031 $BK1.3335@newsr ead3.news.pas.e arthlink.net...
>[color=green]
>>Kissi Asiedu wrote:
>>[color=darkred]
>>>I have access 97 database being run by multiple users. It was working
>>>fine until I created a form and a macro to open the form at start-up. Now
>>>only one user can open the table. If a second user attempt to open the
>>>same table at the same time, there is an error message that says "table
>>>cannot be lock, it is being used by user A on machine C or you may not
>>>have permmision to open table". Does anyone have an idea how to solve
>>>this problem? I want multiple users to be able to add records to a table
>>>simultaneous ly.
>>>
>>>Thanks.[/color]
>>
>>Open up the Form's property sheet, click on Data tab. What is the
>>RecordLocks set to?[/color]
>
>
>
>[/color]

[Kissi Asiedu]

Re: Help With Table Lock, Please.

Form's recordsource is a table. I have checked all its properties, and
permissions. The table is shared , however, under permissions "Open/Run" is
disabled. I don't know if that is the problem. I don't know how to enable
it. (Tools ->Security-->User and Group permissions).
"Salad" <oil@vinegar.co m> wrote in message
news:HW9De.447$ Uk3.306@newsrea d1.news.pas.ear thlink.net...[color=blue]
> Kissi Asiedu wrote:
>[color=green]
>> The RecordLocks is set to "No Locks"[/color]
>
> OK. Is the form's recordsource a query? If so, go to the form's data
> tab, click on Recordsource and view it. Right click somewhere in the
> query and see if there are any locks on it. IOW, check the properties to
> it. Also, check the User's permissions in the query/recordsource. See if
> the Run Permissions are Users or for a specific user.
>
>[color=green]
>> "Salad" <oil@vinegar.co m> wrote in message
>> news:VnjCe.6031 $BK1.3335@newsr ead3.news.pas.e arthlink.net...
>>[color=darkred]
>>>Kissi Asiedu wrote:
>>>
>>>>I have access 97 database being run by multiple users. It was working
>>>>fine until I created a form and a macro to open the form at start-up.
>>>>Now only one user can open the table. If a second user attempt to open
>>>>the same table at the same time, there is an error message that says
>>>>"table cannot be lock, it is being used by user A on machine C or you
>>>>may not have permmision to open table". Does anyone have an idea how to
>>>>solve this problem? I want multiple users to be able to add records to a
>>>>table simultaneously.
>>>>
>>>>Thanks.
>>>
>>>Open up the Form's property sheet, click on Data tab. What is the
>>>RecordLock s set to?[/color]
>>
>>
>>[/color][/color]