Forms with record source of SQL Server table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If this type of question would be better posted in another forum, please let
me know...

I have upsized a backend database into SQL Server.

I now have one form in a front end .mdb with a relatively simple query as
its record source, and it works fine.

But other forms, with relatively simple queries as their record source do
NOT allow me to update any values.

As far as I can tell, all properites in the tables, the queries and the
forms seem to be the same style. What kinds of things should I be looking
for that would cause my problem.
 
In order to be able to update SQL Server tables, the tables must have a
primary key defined. Do they all?
 
Back
Top