access vs sql server

Dear All,

my problem is the following:
i have an access database. i imported it into sql server. after it i linked tables into the access. but now i can't use a subform, because it doesn't want to work*. i know which table is wrong. the original table and sql table are same. (key, default value...... etc.) but if i use original table (which doesn't want to work form sql server) then the subform works perfectly. i don't know what is different from the access and sql server table. i haven't got permission problem, because i'm owner.


* the subform has got a sql command and when it can't find datas then subform hasn't got an empty row but it should has got an empty row.

another interesting thing. when i use all tables from sql server, then i can change datas, but i can't add new record.
here is the error message: cannot add new record(s); primary key for table <tablename> not in recordset.

Thank You

Check whether you have created the primary key in sql tables from sql enterprise manager. When you export a table from access to sql server (particularly in sql 6.5 version) the primary keys info will not be loaded into sql tables. you have to manually set it thru sql enterprise manager. Access will deny addrecord option to linked tables without primary key. when no record is available for a subform normally it wont show any blank row.Apart from Access table properties SQL table fields has some additional datavalidation like zerolength or something like that. Just check it.

i've tried what you sad, but it doesn't work.
it is an idea:
when i want to save records in access, then access immediately create id before i fill up my records, but sql server create id after i fill up them.

what do you think? can it be my problem?