Field Not Updateable?

  • Thread starter Thread starter Bart E
  • Start date Start date
B

Bart E

Jack,

Is there a primary key defined ?
If there's no key defined you cannot perform
any updating.

Regards,
Bart

-----Original Message-----
Hello,

I created a simple database in MSaccess XP. 3 tables,
Click to expand...
Apartments, Reservations, and Guest. This was working
fine. All date fields have the date/time property.
Anyway, I was asked to add some additional fields to the
database. It seems that after I add them, I am not able
to use the query via the form to add data. I have the
Created date set to current date on the form. When I then
click on any other field I get field not updateable. What
is going on? I went back to the table and tried to put
data directly into it. When I get to the date fields, I
can not enter anything. I don't know why. I tried
removing the fields that I had added and I still have the
same problem.
I have my original database as a backup that works fine.

I need to add the additional fields. I don't understand
Click to expand...
why it would quit working after adding these. I'm using
the database on my laptop so it is not running off the
server.
I've attached a picture of the Query, Relationships, and
Click to expand...
the Reservation table. I am unable to enter dates. Very
strange.
 
Also, please don't attach files to messages. Many of us won't read your
message and certainly won't open your file.
 
Back
Top