Welcome to SPN

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

Sign Up Now!

Date field cannot be updated

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

  1. please help

    please help
    Expand Collapse
    Guest

    I am trying to enter information into a form and i get a warning sign that
    reads "field cannot be updated" after clicking ok thru the sign 5 times it
    lets me update the field. When I go to the query and the table the field is
    based on I do not get the warning sign. It lets me update the date field
    perfectly fine. I have already checked there are no data locks or macros
    that would affect this field. Please help!!!
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Is there more than one user at a time? Is the form based on more than one
    table? If not, it just might be a corruption issue.

    Tony Toews has an excellent web page on database corruption.
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Allen Brown also has excellent info on corruption.
    http://allenbrowne.com/ser-47.html

    I have a white paper in a Word document named Fix Corrupt Access Database
    towards the bottom this page:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "please help" wrote:

    > I am trying to enter information into a form and i get a warning sign that
    > reads "field cannot be updated" after clicking ok thru the sign 5 times it
    > lets me update the field. When I go to the query and the table the field is
    > based on I do not get the warning sign. It lets me update the date field
    > perfectly fine. I have already checked there are no data locks or macros
    > that would affect this field. Please help!!!
     
  4. please help

    please help
    Expand Collapse
    Guest

    There is more than 1 user but not at the same time. The form is based on 1
    table, upon which I createda query and then the form from the query.

    "Jerry Whittle" wrote:

    > Is there more than one user at a time? Is the form based on more than one
    > table? If not, it just might be a corruption issue.
    >
    > Tony Toews has an excellent web page on database corruption.
    > http://www.granite.ab.ca/access/corruptmdbs.htm
    >
    > Allen Brown also has excellent info on corruption.
    > http://allenbrowne.com/ser-47.html
    >
    > I have a white paper in a Word document named Fix Corrupt Access Database
    > towards the bottom this page:
    > http://www.rogersaccesslibrary.com/OtherLibraries.asp
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "please help" wrote:
    >
    > > I am trying to enter information into a form and i get a warning sign that
    > > reads "field cannot be updated" after clicking ok thru the sign 5 times it
    > > lets me update the field. When I go to the query and the table the field is
    > > based on I do not get the warning sign. It lets me update the date field
    > > perfectly fine. I have already checked there are no data locks or macros
    > > that would affect this field. Please help!!!
     

Share This Page