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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentUser issue 2
Separate Form 0
Add new records into source table on Form 8
Change Record Source of a Form - Twist 2
Using DSUM to get running total on a filtered form 0
Using Combo Box on Form with Sql view to filter 5
Combo to "Find a record..." - FORM with SQL 1
Changing control record source on save or open 3

Back
Top