Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page