subform bound to query of linked table to sql - won't insert

[MColeman]

I'm working on a problem in an Access2003 database.

A subform is bound to a simple query (no joins or unions)
that reads from a table linked to an SQL2000 database table.

The new record button of the navigational control is greyed out.

The query works outside the form and I can add a new record to the linked table in datasheet view.

I have a hunch that this may be a security problem, but I
don't understand how Access and SQL work together on security.

For two days, I've been combing the Internet looking for possible solutions. I have found several leads, but so far
nothing has panned out.

Does anyone have any ideas of what I could check or know of any links that might help me?

Thanks

 

[Remou]

Hi
Is Allow Additions set to yes?

 

[MColeman]

sure have...

allow additions and allow edits both set to yes on the main form and the subform

also tried changing from dynaset to dynaset - inconsistent updates

and checked the version of Jet and MDAC and looked for possible updates that needed to be applied

and made sure the table has a primary key in Access

and checked to see if we had the correct version of the sql odbc driver

and checked the permissions in Access

 

[Remou]

My! Well, hopefully this comment will bring your post to the top of the list, and draw someones attention.