Access ADP project won't let me edit/update data

[nanfa]

Hi All,

I upgraded my Access db from mdb to apd with all data exported into a sql server database and then I exported the forms reports and modules from the mdb to the apd. Everthing seems to be okay except that I cannot edit any data from my tables or forms from within access. This is the first time I am encountering anything like this. When I connect to SQL server with query analyzer using the same login I use for access, I can update the data. Does anyone know what I am doing wrong?

Thanks,

Nanfa

 

[nanfa]

Thanks Pat Hartman!!!

You are right. It was the first problem and as soon as I make unique keys, it worked. I guess the data import/export wizard does not import unique keys as unique keys, or I didn't know how to instruct it properly.

Thanks,

Nanfa