SQL Server

[Van T. Dinh]

Have you checked whether there is a PK Field in the Table?

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I have a form where users enter data, which is updated to

tables; from which users print reports. After using the
Upsizing Wizard to create a DB in SQL Server (which sits
on my pc, for testing purposes), I'm not able to enter
data in one of the tables; but can in another.

 

[Van T. Dinh]

Are you using Access Database (MDB format) or Access Project (ADP format)?

--
HTH
Van T. Dinh
MVP (Access)

Yes, every table (3) upsized has a primary key assigned to it. I just

finished going through the Upsizing Wizard again and ran into the same error
message when trying to add records to a form: "You can't go to the
specified record." The Add Record buttons on the form, and the main toolbar
are also inactive.

I just noticed that the form that is working properly has a data source of

a _table_ whereas the form not working has a data source of a _query_.
Which begs the question; are other Access objects upsized the way tables
are?

 

[Van T. Dinh]

Well... I wouldn't recommend the ADP Project.

Microsoft recently advised that the preferred method is stil MDB format with
ODBC-linked Tables from the SQL Server.

Note that the SQL syntax is *different* from JET SQL syntax. If you use
ADP, you WILL need to check ALL Views / SP that the Upsize Wizard creates
for you. You will also have to re-create those Queries that the Upsize
Wizard can't handle. In addition, all SQL Strings in Forms / Reports / code
will need to be check.

This is NOT easy if you are only familiar with JET SQL.

--
HTH
Van T. Dinh
MVP (Access)

I'm working around the form issue for now.

I created a front end/back end to my mdb file; upsized it and followed the

instructions to create an Access Project. After that, I noticed that my
queries don't work the same way and some of the VB coding I put in don't
work either. In one area of VB, I get the following Run-time error 30025
message:

 

[Guest]

Thanks for the advise, it is much appreciated.