S
Steve
Hi:
We have upgraded our Access 97 application to use SQL backend, so tables are
now in SQL and linked to our application. Everything is working okay with
the following issue: To get around the constraint of only being able to
retrieve 255 fields from a table, we have split one of our main tables into 2
(in sql server). We would like to create an updatable query that allows
linkage of these 2 tables (linked from PrimaryKey of 1 table to FK in second)
and allows for input of new records - this scenario works okay with Access
tables, but with our linking scenario we are unable to add records across
both tables, getting an error that the foreign key in the second table will
not take null values (since it should not!) - this seems to be an
intermediary step in adding data across the tables...
Any help will be greatly appreciated. I hope the above is clear enough to
get some input... I'd like to find a solution for our current environment
(Access 97 with SQL backend, but I'd also be interested in knowing whether
Access 2000/3 has the 255 field constraint)...
Thanks in advance.
Steve Gregory
We have upgraded our Access 97 application to use SQL backend, so tables are
now in SQL and linked to our application. Everything is working okay with
the following issue: To get around the constraint of only being able to
retrieve 255 fields from a table, we have split one of our main tables into 2
(in sql server). We would like to create an updatable query that allows
linkage of these 2 tables (linked from PrimaryKey of 1 table to FK in second)
and allows for input of new records - this scenario works okay with Access
tables, but with our linking scenario we are unable to add records across
both tables, getting an error that the foreign key in the second table will
not take null values (since it should not!) - this seems to be an
intermediary step in adding data across the tables...
Any help will be greatly appreciated. I hope the above is clear enough to
get some input... I'd like to find a solution for our current environment
(Access 97 with SQL backend, but I'd also be interested in knowing whether
Access 2000/3 has the 255 field constraint)...
Thanks in advance.
Steve Gregory