473,387 Members | 1,760 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

locked table

hi
i have a macro that imports ables omn opening of the Database
the problem is when a user has the database open
the second user gets an error message cant lock another user has the
table open

is it possible to get round this

thanks
kevin

Jan 16 '06 #1
3 1309
you have two choices:

1. Use a seperate front end for each user, each with local copies of
imported tables
2. Change the code to import the data, not the table

but a better approach is to question this practice, why do you need to
do this? i'm willing to bet that there is a better approach to take to
solve what you are trying to achieve. For example, why not just have a
linked table to the data source you are importing at every login...

Jan 16 '06 #2
BillCo
Thanks very much for your suggestions
i have now linked the tables not imported them
this resolves the problem of the table not locking
Slowed the opening of the book but cant have it all
again thank you

kevin

Jan 17 '06 #3
Happy to help!

Linking tables does slow down an access app, because instead of having
all the data on a local machine it needs to be constantly pulled across
the network from the backend. However linking is pretty essential for a
multi user environment where there can be concurrent updates by
different users. But there are ways of speeding up things... by prudent
use of recordsets, unbound forms, stored procedures etc.

Jan 17 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: CaptainMcBunnyTickle | last post by:
Using FLUSH TABLES via the C query API mysql_query() hangs if the table is locked already. That is to say, nothing prevents me from running a LOCK TABLES twice; it won't tell me "it's already...
5
by: David C. Barber | last post by:
I'm trying to determine which user has locked a given record from VB6. I know I can use sp_lock and sp_who, and match up the data to determine which users have locked records in my database,...
2
by: Bardolator | last post by:
Hello I have a stand alone Java application that uses SQL Server 2000 on the same machine. Sometimes, when we run the applications and follow a certain steps, the SQL server locks some of the...
1
by: Mel Apiso | last post by:
Hi, I want to know if I can detect exactly what row table is locked. My application is locked and I get valuable information (table, application, lock mode...) with "get snapshot for locks..."...
1
by: Dudley Joseph | last post by:
Hi Ive got an Access97 db with a record in one of the tables that appears to be locked by another user even though no one is using it and the ..ldb confirms this. I need to delete this record...
1
by: University of Toronto | last post by:
Hi gang, Hopefully someone can help us out. In short - Access 2002, db split into a front end and back end. It appears that our backend db is locked. Our form bound to one table won't allow...
0
by: Access Programming only with macros, no code | last post by:
ERROR MESSAGE: Could not update; currently locked by another session on this machine. BACKGROUND I have the following objects: Table1 - HO (which has about 51,000+ records) Table2 -...
5
by: breal | last post by:
I have a db table that holds a list of ports. There is a column in_use that is used as a flag for whether the port is currently in use. When choosing a port the table is read and the first...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
0
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...
0
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.