Cannot edit table values in ADP

[den]

I have a database on an SQL server and I am using Access 2003 as the front
end to do some simple editing of table values, but Access will not let me
edit the values in some of the tables. When I hit a key I just hear a
"dink" sound and it won't do anything. Some tables I can edit. I can
click on design mode and I can add colunms. but in normal mode, when I open
a table and try to change a value, it won't let me.

I can use Query Analyzer from the same workstation under the same account
and use an "UPDATE" statement and it will change the values just fine. But
it would be a lot easier just to do it directly in an ADP.

anybody have any idea what setting or whatever is keeping me from editiing
these tables. I created them myself on the SQL server so I should be able
to edit them.

Any suggestions, appreciated.

Dennis

 

[Sylvain Lafontaine]

Many things can put a form into a read-only state; the first one being a
missing primary key.

(In the past, with older versions of Access, some trouble with the Bit and
TimeStamp fields have also been mentionned in this newsgroup but I don't
know if there are still some problems with them.)

 

[Den]

Many things can put a form into a read-only state; the first one being a
missing primary key.

(In the past, with older versions of Access, some trouble with the Bit and
TimeStamp fields have also been mentionned in this newsgroup but I don't
know if there are still some problems with them.)

The table I am trying to edit has only 7 entries. It is a simple look
up table, i.e. it is not linked to any other tables. It has a simple
digit as the primary key and description of an item and a date. That is
it.

any other suggestions>

den

 

[Sylvain Lafontaine]

What do you mean exactly by 7 entries? 7 rows or 7 columns (fields) ? The
number of rows is absolutely of no importance in a case of a Read Only
table.

If you could give us the structure of the table as SQL DDL statements, that
could help.

BTW, triggers can also give some trouble.

Finally, it is very important that you make use of the Access Refresh
command for both the Tables and the Queries windows.

 

[Den]

What do you mean exactly by 7 entries? 7 rows or 7 columns (fields) ? The
number of rows is absolutely of no importance in a case of a Read Only
table.

If you could give us the structure of the table as SQL DDL statements, that
could help.

BTW, triggers can also give some trouble.

Finally, it is very important that you make use of the Access Refresh
command for both the Tables and the Queries windows.

By 7 entries I mean 7 rows. There are 3 columns in each row. Column 1
is a autonumber field for the primary key. Column two is a text field
that holds a description. column 3 is a date field. I want to edit the
descriptions and dates.

What sets the table to read only. I have not set it to read only. How
can I examine and change the read only properties.

This table is not linked to any ohter table. It is simply holding data
that is used in a drop down box on a form.

den

 

[Sylvain Lafontaine]

Maybe a permission problem or you forgot to use the Refresh command.

Try creating another table with the same structure.

 

[Vadim Rapp]

D> Column 1 is a autonumber field for the primary key.

have you actually set this column to be the primary key? if you enter design
mode, is there a key symbol next to it?

Vadim

 

[den]

That was it Vadim. I had mentally meant to use column one as the primary
key, but forgot to "actually" set it as the primary key. After I set it to
be the primary key, I could edit it fine.

Thanks for eveyone's help.

Den