RECORDS LOCKED on TABLE

[ZaZa]

Hi folks,

Can anyone suggest to me why I can't edit records on my Main Table when I have opened it up in datasheet view? When I try, the pencil icon changes to a circle with a line through it. I presume this means that the records are locked.I can only add new records.

But:
a) I am the only user so there is no mult-user environment
b) I don't have any queries based on the Main Table
c) I have a combo box on a form ( call it Form1 for argument's sake)that gets it's values from one of the fields in the Main table
d) On Form1, there are two check boxes with after update event properties that bcan change the value of two fields in the Maintable depending on wether or not the check boxes were ticked.

That is about all I can think about that might affect the table.

Any suggestions?

Frustrated,
ZaZA

 

[Alcar]

are the comboboxes unbaund?? They should be, otherwise if you have linked one directly to the main table and you changed the updatable property of the combobox to false (or if I can recall) the locked property to false, then I believe it would prevent in anyway for you to make changes on the table.

What that the problem?
HTH
Alcar

 

[Alcar]

unbound that was.. sheeesh I have to buy new fingers
Alcar

 

[ZaZa]

Alcar,

the combobox is unbound,the Rowsoucre, however is set to an sql select query that gets the value of the field from the Main table.

Zaza

 

[Alcar]

Hi ZaZa,

Do you use any option paramenters when you create the connection string to the DB? If yes, wich ones?

Alcar1

 

[ZaZa]

Alcar1

Since, I am not sure what you are talking about , my guess is that I didn't use any.

I think have narrowed down the possible causes to point c):
I have another form with a checkbox on it and if the check box is ticked, its after update event ticks off another check book on the MainTable

Experiment to test my theory:
This morninig, I decided to spilt the original MainTable into two tables, the second new table contained the fields that are affected by the after update event of the form.

I noticed that after a while, this NewTable became locked in datasheet view while the original MainTable behaved normally in datasheet view. So it must be happening becasue of the after update event.

Conclusion:
I'm no Shelock but that's what I figure.

PostScript:
Still don't know what to do 'bout it though would appreciate any more ideas from the forum.

ZaZa

ZaZa