Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: could not lock file

Discussion in 'Information Technology' started by Zagaaru, Jul 28, 2006.

Tags:
  1. Zagaaru

    Zagaaru
    Expand Collapse
    Guest

    Here is a possible soluation. I noticed when I use rs.refresh, the
    could not lock file record does appear, however once I changed it to
    rs.requery, this change solved the problem. If it is applicable try it,
    if not, then its time for debugging the step by step approach.

    Joseph Meehan wrote:
    > Chey wrote:
    > > Wow that is all greek to me. How do I check the file lock and all
    > > that stuff?

    >
    > From the help file of 2003 version:
    >
    > When a user edits a record, Microsoft Access can automatically prevent
    > others from changing that record until the user has finished editing it.
    > Giving one user exclusive access to a record is called locking.
    >
    > a.. Under Default record locking, do one of the following:
    >
    > To prevent locking of records while you edit them, click No locks.
    >
    > To lock all records in the form or datasheet (and the underlying tables)
    > while you edit them, click All records.
    >
    > To lock only the record you're editing, click Edited record.
    >
    >
    >
    >
    >
    > As I recall different version have slight variations in their record
    > locking. I believe that earlier version locked pages not records (see last
    > line of the help file information above). That might include more than one
    > record.
    >
    >
    >
    > >
    > > "Joseph Meehan" wrote:
    > >
    > >> Chey wrote:
    > >> >I have 3 communities using a database. We are all on a network.
    > >> > They can access the database but when she opens it it reads Could
    > >> > not lock file. What do I need to do to fix this?
    > >> >
    > >> > Thanks
    > >> > Chey
    > >>
    > >> It could be that someone else has it open at the same time, or
    > >> other possible issues.
    > >>
    > >> What file locking is set up for that data?
    > >>
    > >> Is it a split system with one back end file and a separate copy
    > >> of a front end file for each user on their own machine?
    > >>
    > >> --
    > >> Joseph Meehan
    > >>
    > >> Dia duit

    >
    > --
    > Joseph Meehan
    >
    > Dia duit
     
  2. Loading...

    Similar Threads Forum Date
    Debate With Sarbjeet Singh Dhunda At Turlock (California) Gurdwara, April 2015 - YouTube Gurmat Vichaar Apr 23, 2016
    Uk clocks go back Blogs Oct 17, 2015
    Kesh: Dreadlocks Questions and Answers Nov 20, 2013
    Obamacare Faces Near-Solid Block In The South Health & Nutrition Mar 31, 2013
    Malaysia Have you forsaken your flock, Archbishop? Malaysia News Update Breaking News Jan 30, 2013

Share This Page