Access to SQL newbie

  • Thread starter Thread starter JS
  • Start date Start date
J

JS

I just upsized my Access 2000 tables using DTS in SQL 2000
(sp3). I am now trying to create forms that are derived
from underlying views for data entry by manual entry &
combo boxes. The problem I am having is that I cannot
get the form to allow me to enter new data.

Thanx,
JS
 
Is this problem occurring only for entering new data or if it's also happen
for editing existing data as well?

For the former case, verify that "Allo Additions" is set to Yes.

For the latter, make sure that each of your tables still have their primary
keys set in SQL Server. Access won't allow you to edit data for a table
that has no primary key.

If you are joining multiple tables, set the "Unique Table" property to the
proper table. Sometimes, you cannot do it inside the design view of a form;
so you must set it in the form open event. You can also change the Record
Source property of the form to the table that you want to use as the "Unique
Table", set this property then revert the Record Source property to it's
former definition.

It may also be necessary to replace Views and User Defined Functions with
stored procedure.

S. L.
 
Back
Top