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. 5 3133
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
RecordLocks set to?
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
RecordLocks set to?
The RecordLocks is set to "No Locks"
"Salad" <oi*@vinegar.com> wrote in message
news:Vn*****************@newsread3.news.pas.earthl ink.net... 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 RecordLocks set to?
Kissi Asiedu wrote: The RecordLocks is set to "No Locks"
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.
"Salad" <oi*@vinegar.com> wrote in message news:Vn*****************@newsread3.news.pas.earthl ink.net...
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 RecordLocks set to?
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" <oi*@vinegar.com> wrote in message
news:HW***************@newsread1.news.pas.earthlin k.net... Kissi Asiedu wrote:
The RecordLocks is set to "No Locks"
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.
"Salad" <oi*@vinegar.com> wrote in message news:Vn*****************@newsread3.news.pas.earthl ink.net...
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 RecordLocks set to? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: scorpion53061 |
last post by:
I really like this javascript for an image slideshow. The only thing I woudl
like to do differently is have a cell above the image and navigation that
would allow text content to be placed.
Does...
|
by: Bing Wu |
last post by:
Hi Folks,
I have a very large table containing 170 million rows of coordinats:
CREATE TABLE "DB2ADMIN"."COORDINATE" (
"FID" INTEGER NOT NULL ,
"AID" INTEGER NOT NULL ,
"X" REAL NOT NULL ,...
|
by: Rohit Raghuwanshi |
last post by:
Hello all,
we are running a delphi application with DB2 V8.01 which is causing
deadlocks when rows are being inserted into a table. Attaching the
Event Monitor Log (DEADLOCKS WITH DETAILS) here....
|
by: RWC |
last post by:
Hello,
I have an issue that's driving me batty! I have a report, whose record
source is SQL based on a normalized set of tables. There are no nested
queries and no dlookups in this record...
|
by: D. Shane Fowlkes |
last post by:
This is a repost (pasted below). Since my original post, I've double
checked the system clock and set all IIS Session Timeout values to 10
minutes. Still ...the problem occurs. I've also...
|
by: RayPower |
last post by:
I'm having problem with using DAO recordset to append record into a
table and subsequent code to update other tables in a transaction. The
MDB is Access 2000 with the latest service pack of JET 4....
|
by: Jay |
last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send
text messages to many, many employees via system.timer at a 5 second
interval. Basically, I look in a SQL table (queue) to...
|
by: Sam Durai |
last post by:
Hello, I need to merge a small table (of rows less than 100,sometimes
even 0 rows) to a big table (of rows around 4 billion). I used the PK
of the big table as merge key but merge does a table scan...
|
by: wugon.net |
last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad
query performance
Env:
db2 LUW V8 + FP14
Problem :
We have history data from 2005/01/01 ~ 2007/05/xx in single big...
|
by: LanaR |
last post by:
Hello,
one sql statement is causing severe performance issue. The problem occurs only in UDB environment, the same statemnt on the mainframe is running fine. I have an explain output from the sql....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| | |