Results 1 to 9 of 9
  1. #1
    rubs34 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    22

    Run time error - 3051

    Hey everyone,

    The database that I am working on suddenly started showing this error. Everyone else is able to connect to it except me. I don't understand what to do.


    I was able to connect to this for a week.

    Click image for larger version. 

Name:	Capture.JPG 
Views:	10 
Size:	23.7 KB 
ID:	36336

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,797
    The message is unusually helpful.
    It has either been opened exclusive by someone else ....look for a lock file
    OR you don't have read/write permissions to the folder containing that file... Check by browsing direct to the file.

    However, Access databases should never be run from shared network locations
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,884
    usually there is a lock file open... .lccdb (on your front end)
    delete it then open the .accdb

    provided you DO have a split database correct? Each person has their own copy of the Front End.
    If you don't have a
    split database, then split it.

  4. #4
    rubs34 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    22
    Hey Ridders & Ranman,

    Thanks for your replies.

    Yes, it is a split database. And there is no Locked file on my end. I have restarted the computer thrice, But how do I find this locked file??

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,797
    Look in the folder containing the backend file as that is read only.
    If in use normally, there will be a lock file.
    If exclusive, there won't be. If so ask IT support to help.
    If you can't open the folder, it's a permissions issue
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  6. #6
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,884
    The lock file on the backend is normal and should be there.
    otherwise I see no reason for you to be locked out.

    and if YOUR Frontend is only used by you,then there should be no problem.
    you could try getting another copy of the FE. Sometimes corruption may do it.

  7. #7
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,797
    Yes the lock file is normal & should indeed be there ...if the split database is being opened correctly by all users.
    BUT if someone has exclusively opened the BE file directly from that folder, the lockfile won't exist but you will be unable to write to the file from the FE
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  8. #8
    rubs34 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    22
    Okay... There was a locked backend file. Now its no longer there. But now I still can't enter.

    I have tried running it from different front-end database.

    I have restarted my laptop again. Still no use.

  9. #9
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,797
    Can you open the BE file direct ...if nobody else is running the FE?
    If not, check permissions.

    When others open the FE are there any signs of data corruption?

    Where is each user's copy of the FE located? On their own workstation or a shared network drive?
    Is anyone else running the exact same copy of your FE? In other words sharing the same FE?
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-23-2014, 07:49 AM
  2. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  3. Replies: 6
    Last Post: 05-30-2012, 12:32 PM
  4. Run-time '3051' - Too few parameters. Expected 1
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 04-11-2011, 07:17 AM
  5. Replies: 1
    Last Post: 10-15-2008, 01:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums