Preface: I am using Access 2003 but have Office 2007 on my machine with Access 2007 disabled.
In the database I am working in/building, I transfer data in from SPSS (statistical software) and other access db through ODBC so that I can put into reports in this db.
However, everytime I transfer in data, I get the ldb. that will not go away. Sometimes I can open my mdb., close it and then the ldb. will leave; or open the mdb. close it, and then refresh windows explorer and then it will go away. But mostly, I just cannot get rid of it.
And if I check its properties, I'm the one who has the db open. Or if I try to open and work in my db, it says it is open and locked for editing by another user (me).
Any ideas or solutions??
Thank you in advance.
-Tamela
6 7755 NeoPa 32,556
Expert Mod 16PB
Typically, you wouldn't use ODBC to link to an external Access database.
Try connecting using Files of type Microsoft Access.
Why not use: - Dim MyOtherDatabase as Database
-
Set MyOtherDatabase = OpenDatabase("Path to your external DB")
I don't believe this creates an .ldb lock file. You then can manipulate tables in MyOtherDatabase.
Typically, you wouldn't use ODBC to link to an external Access database.
Try connecting using Files of type Microsoft Access.
I am transferring data from SPSS to msAccess, so other than using an ODBC i'm not sure how I would move the data. I'm confused by your suggestion connecting files of type. can you explain further?
thank you!
NeoPa 32,556
Expert Mod 16PB
I'll certainly try.
...
In the database I am working in/building, I transfer data in from SPSS (statistical software) and other access db through ODBC so that I can put into reports in this db.
However, ...
That tells me you are working exclusively with Access databases but using an ODBC connection.
If that's not the case then please ignore the comment, but as you'll see - I was responding to what you'd posted.
If that is the case and you are still confused - let me know and I will go into finer detail.
I'll certainly try.
That tells me you are working exclusively with Access databases but using an ODBC connection.
If that's not the case then please ignore the comment, but as you'll see - I was responding to what you'd posted.
If that is the case and you are still confused - let me know and I will go into finer detail.
Thank you.
Its not exclusively Access. One db was built by a contractor in sequel and I link to through ODBC. I use the ODBC to transfer the data into SPSS (Statistical Software for the Social Sciences) and into Access.
Once I score data, i move it from SPSS into Access.
Not my calling in life, but these are the cards dealt...
I wonder if the fact that i'm keeping Access 2003 to finish the db work however having Office 2007 is a factor in the problem?
If not, please ignore.
Thanks again for your help.
There are several possible causes of your ldb lock file problem. See these links for possible causes that should be checked out, along with the recommended action to remedy the problem:
You may need to review/change the locking scheme that is configured for the Access DB to No Locks in view if the heavy transaction processing. http://office.microsoft.com/en-us/ac...408601033.aspx
For example, If you use record-level locking, Access locks only the record you are editing. This becomes the default behavior for access to data through a form, a datasheet, and code that uses a recordset object to loop through records, but not through action queries, nor through code that performs bulk operations using SQL statements, which will lock the entire table being updated. http://support.microsoft.com/kb/8397...d=2509&sid=898 http://support.microsoft.com/kb/815281
The failure of the ldb file to close could also be a symptom of database corruption. See item # 14 in this link: http://www.granite.ab.ca/Access/corruption/symptoms.htm Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ryan |
last post by:
I have a problem with record locking / blocking within an application.
The app is quite straight forward. Written in Delphi 5 using BDE to
access a SQL 7 database (Win2K server).
Every so often...
|
by: Megan |
last post by:
Hi-
I have a question about the Microsoft Access Record-Locking
Information Icon.
Whenever I, or my friends, open my MS Access database, the Microsoft
Access Record-Locking Information Icon...
|
by: ethanj /personal/ |
last post by:
We are using Access 2000 database, with the following settings.
Tool > Options > Advance >
Default Record Locking = Edited Record
Open databases using record level locking = True
Form...
|
by: MLH |
last post by:
Can I read the name of the current database's record locking
file from within code? I would expect to read something like
"MyDB.ldb"
|
by: Jay A. Moritz |
last post by:
I have an ASP .NET 2003 application that uses an Access 2003 database.
Trimming my application down to just one page that connects to the database
and uses an OleDbDataReader to get info, then...
|
by: Arsalan |
last post by:
I'm using MS Access as database
I dont know, but after accessing my database, i cant seem to trace which
page is not releasing record locking information for access
How do I trace it ?
|
by: master |
last post by:
Actually, it is not only the record locking, what I need, and nobody seems
to descibe this.
Imagine the following scenario.
There is a database with, say 10000 records with some unvalidated...
|
by: goodlie |
last post by:
Hello;
I have an access 2003 db on XP OS split with backend on sql2K. I want
to put the front end on a fileserver for easier maintenance. I have 7
users using the database at any given time.
...
|
by: Cindy Huyser |
last post by:
I have an Access 2000 database behind a threaded Java application that
that can have have concurrent access to the same table (but not the same
record). The database is set up for shared access...
|
by: kstevens |
last post by:
I have turned on record locking do to the fact that we are starting to have issues with the records not being locked. I have a button on a form that changes the recordsource of the form. When i...
|
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: 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...
|
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: 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,...
|
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...
| |