LDB Files - Locked & Unable To Delete

May 3, 2005

Hi can anyone help. My database is running on a Citrix server. No real problems except that I am continualy being left with the database apparantly locked by another user. Am unable to delete the LDB file even when no other users are logged on. Is there a way of deleting LDB files in relation to stale Access sessions. I know that in normal circumstances these files close automatically. Problems seems to be occurring when the database is not exited properly or the connection to the server drops for some reason. I've tried loads but can't find a workaround.

Stuart Dennis

View Replies


ADVERTISEMENT

Form Locked, Unable To Unlock

Feb 13, 2005

Hi all,
I'm having a problem here and after searching the web, I can't find a solution.
Problem is that I have a form which seems to be locked. None of the fields can be modified. This should be ok except for 1 combo-box.
I have checked all objects settings and all objects have:
Edit/Delete/Add options enabled;
Visible option enabled;
Locked option disabled;
The form has only Fromview enabled and recordlock is off.
There is no VB code modifying a 'locked' status.

Can someone help me out here?

My project is +20Mb so first I'd like to see if there are any things I've forgotten to check before I'll strip and post it.

View 6 Replies View Related

General :: Unable To Edit Records - Fields Are Locked

Jun 11, 2013

I have a user that is unable to edit records, He can click in the fields but he could not delete or enter data in the fields. He has the ability to edit records but its fields are locked. I created a split database and created a secure front which I distributed it to multiple uses. The other users front end is working fine, expect for the one.

View 2 Replies View Related

MDE Files - Locked?

Mar 12, 2007

Are all mde files locked so that you cannot edit or see design view for forms etc?

Are there any tools out there that can unlock an mde database?

Thanks,

Dave

View 1 Replies View Related

How Does Database Get Locked When Can't Write LDB Files

Aug 1, 2014

I have a database on a shared network drive. All users except the manager have only read access to the file/directory. However, if the manager tries to open the file while other users have access open, it only allows him to read it as read only. If they close the database, then he can open it with read-write. Does access use another mechanism other than ldb files for locking?The weird thing is that it seems to be locking correctly. If the manager tries to open the file while someone has it open, it's read-only.

View 2 Replies View Related

Tables :: Access 2013 - Unable To Link To DBF Files?

Sep 19, 2013

2013 does NOT recognize DBF files, we are trying to find a solid work around to LINK to our DBF files.

There are about 30 DBF files that get updated EVERY week. And there are about 60 employees that LINK to the various DBF files. Importing is not a realistic solution given these circumstances.

View 4 Replies View Related

Unable To Delete Or Change Name Of Database

Jan 23, 2008

I have tried to rename or delete in MS Explorer, but this just creates confusion. The databases still show up in bits and pieses on various screens. I've purchased 2 additional how to do it books on MS Access 2007 and find nothing on deleting or renaming an entire database and all objects or references to it. Does anyone know the magic bullet?:confused:

View 3 Replies View Related

Unable To Delete Data In Table

Jul 25, 2013

I am currently unable to delete any data from my table. When I highlight a row and right-click, the option to delete the record is grayed-out. I have deleted and recreated the table and relationships, saved the database as a new file, and compacted and repaired, but I am still unable to delete anything.

View 1 Replies View Related

Need To Delete Some Files

May 17, 2007

Before I spend a load of time on this, thought I'd check to see if it's even possible.

Thanks to some help from folks here, I have some code that allows me to output some reports to a folder and then email those reports as attachments, all from inside my db.

Now I'd also like to delete those files after the email is sent, before the module ends.

Anyone know if this is doable? If so, I'll get started working on the code.

Thanks
BeckieO

View 4 Replies View Related

Delete Files Using Listbox

Oct 21, 2005

Hello,
I have a list box on a form which pick up excel file in my c drive. Is there a way I can delete this files via command button? Let's say I would like to select the file in the listbox, and use the button to run the delete code.

Any help? Thanks.

View 7 Replies View Related

Modules & VBA :: Delete A Folder To Include Subfolders And Files?

May 25, 2015

I need a way to delete a folder along with subfolders and files associated with a record via command on a form:

The path is stored in a text field "txtDocuments".

For example: "C:UsersWatsonDesktopFY1515051505-010"

So, I would want the code to pull the folder location from the txtDocuments text field and delete folder "1505-010" and all sub folders & files contained within it.

View 4 Replies View Related

Queries :: Unable To Open Or Design Queries From Older Access Files

Jan 1, 2014

Im trying to work on an db in Access 2007 that was migrated from Access 2003 (in fact its been migrated several times starting from Access 97). It executes and runs with no problems in both versions.
The problem is when trying to open some queries (not all) - Access is unable to open the query in design mode and gives me this error :

" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

However, as I cant open it - I cant check it. Im pretty sure none of the fields have invalid characters (they do have spaces) and Im not sure how long is too long....

View 6 Replies View Related

Modules & VBA :: Loop Through Files And Then Compare With Files In Database Table

Nov 11, 2013

I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .

Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files

[code]...

View 7 Replies View Related

Using MDB Files Which Are Backed Up Hourly Into Zip Files

May 2, 2012

Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.

What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?

View 3 Replies View Related

Access 2010 - Delete Form Command Button With A Password To Confirm Delete

May 6, 2014

All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.

View 13 Replies View Related

Query Lets Me Delete But Doesn't Actually Delete...

Apr 2, 2007

I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.

How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?

View 2 Replies View Related

How To Delete Record Using Delete Query

May 19, 2011

I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"

I think my problem has something to do with security but I can't figure out what to change.

View 13 Replies View Related

HELP!!! Locked Myself Out Of My Own Db!!

Jul 29, 2005

Hi

I know this sounds stupid but on my database with user-level security, i have somehow managed to remove administer rights from all users , and do not know how to change it back, if it is even possible.

I think what might have happened is it was stored on my USB drive and i switched computers and opened the db, would that have affected it? :confused:

Is there an easy way out of this or am i screwed? :eek:

thanks, ian :)

View 5 Replies View Related

Help!!! Locked Out

Aug 29, 2007

I have been following a text book to try and secure a database, i set up the Work Group Info File, allocated a password, now even when i want to start a completley new database i have to enter a password.........

AND when i set up the password i must have enetered it wrong now i am completely locked out!!


Is there any way to fix this i cant do anything!! I cant even start on a completely new databse!!

Please help

View 8 Replies View Related

Locked Out Of My Databse

Jul 12, 2005

undefined

Hi, can anyone help? Like an idiot I veered away from my intention to put a password on an Access database which holds only a table and a few queries and explored other security options. I now cannot get in to the database at all and get a message telling me that I do not have the necessary acces srights and to consult my administrator. When I look at the properties, I am shown as the administrator, which makes sense but despite trying various, desperate things, I cannot get back in to take the security off. Needless to say I did not create a copy first, so have learned a lesson the hard way. Any advice gratefully received.

View 3 Replies View Related

Locked Database

Jul 22, 2005

i have this database with tables i can't access, so i had to import the data into a new database , given the size of the new database JoeCruse (form this board) pointed out that it could be that the front end is separated form the back end. and i can't find the front end anywhere

i want to press F11 and see the tables and so forth open up when i launch the original db. how do i go about doing that.

View 2 Replies View Related

Locked Out Of Access

Oct 10, 2005

:eek: security levels were set on a database using the wizard, unfortunately the person who set the security did not print out the sheets with the WID etc on it, this person is now unable to open access at all from their pc it asks for a password which the user does not believe they set or if they did set one it was their standard pc log in, however the database and access can be opened from any other pc on the network......can anyone out their help...thanks

View 2 Replies View Related

Database Locked Up NEED HELP

Apr 18, 2007

I have a database that I password protected. Somehow, in the process of applying the password, the file became corrupted and now I am getting the following error message:

"This database is in an unexpected stat; Microsoft Office Access can't open it.

This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state."

Does anyone know what this error is and how I can retrieve my data?? I have tried to import the files into a new database, convert the database into a different version and compact and repair. Nothing has worked. I have looked into recovery tools and two of them do get me into the database and let me see some of the data, however, the programs are holding my information hostage until I purchase the software which is running around $300.00. Any ideas???

View 6 Replies View Related

Could Not Update. Currently Locked

Jul 3, 2007

I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so often one of them experiences being unable to input data from their Form because of this lock condition. Sometimes the condition will go away (if they wait long enough) and they can input data again. Sometimes it's User A experiencing the lock, sometimes it's User B. I thought splitting would alleviate lock issues, but it doesn't seem to be the case for me. Could this be a "permissions" issue on the shared directory where the BE is located or some security setting within Access (or both)?

Thanks in advance for everyones help!
Michael

View 2 Replies View Related

Locked Out Of Access

Nov 3, 2007

I copied Odun's post below to describe my problem. I'm having the same problem. I can't even creat a new blank database without being prompted for my user name and password, which aren't working.

Any suggestions would be very much appreciated.

Thanks,
Mike

-------------------------------------------------------------------------
#1 02-13-2006, 04:33 AM
odun
Registered User Join Date: Apr 2005
Posts: 108


can't log on to database

Hi all,
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?

I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.

Please help

Thanks!

odun
View Public Profile
Send a private message to odun
Find all posts by odun
Add odun to Your Buddy List
--------------------------------------------------------------------------

View 1 Replies View Related

Locked Myself Out Of Access

Nov 26, 2007

Hi

Is there anyway of returning the menus that I removed from the Tools > Startup options back?
It looks like I have locked myself out of my FE!!!!

Thanks,
B

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved