Add New Record error

[scott]

I'm converting an existing access db app to an ADP. I just noticed that my
data entry form no longer allows adding a new record.

The recordset is a SPROC and I do have a subform based on another SPROC. Is
there a trick to "un lock" the recordset, so I can add a new record on my
form when using SPROC recordsets?

 

[Pat Hartman\(MVP\)]

I believe the answer to your question is no. I have to admit that I don't
use .adp's because of their limitations but I would suggest leaving your
application as an .mdb and just converting the tables to SQL Server. You'll
need to optimize the forms so that they are based on queries with selection
criteria to limit data requested from the server but you probably won't need
to make any other changes.

Despite what you may have heard to the contrary, Jet makes every attempt to
send Select queries directly to the server for processing. That means that
most of the time, you don't have to do anything special. Jet automatically
converts your queries to "pass-through" queries for you. You can verify
this for your self by turning on the SQL Profiler and watching the queries
that Jet sends to the server.

..adp's do not use the same GUI tools as the .mdb so features that you
currently use with the .mdb may not be available with the .adp. Also, MS is
not continuing to develop the .adp since it has not gained wide acceptance.
The next version of Access will still support the file type but it is
unlikely that there will be improvements over the current version.

 

[Dennis]

IIRC, ADPs are deprecated these days. You may want to consider a different
methodology. Why are you using an ADP? What are you trying to accomplish?