upsizing wizard

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I used upsize wizard utility to import access tables to
SQL server and create link in the access application. Now
when I go to edit the record through the form I get the
following message.

'You must use the dbseeChange option with openrecordset
when accessing a SQL server table that has an identity
column.'
..
What is the problem, what should I do? The access
application is an mde file and I am not able to modify the
code there.
Thanks,
Jim.
 
JIM.H. said:
I used upsize wizard utility to import access tables to
SQL server and create link in the access application. Now
when I go to edit the record through the form I get the
following message.

'You must use the dbseeChange option with openrecordset
when accessing a SQL server table that has an identity
column.'
.
What is the problem, what should I do?
Click to expand...

See the Random Thoughts on SQL Server Upsizing from Microsoft Access
Tips page at http://www.granite.ab.ca/access/sqlserverupsizing.htm
The access application is an mde file and I am not able to modify the
code there.
Click to expand...

You will have to make changes to the MDB and recompile the MDE. No
way around this. Besides there will almost certainly be other
problems which will require fixing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top