ACCESS 97 /2000 LINKED TO SQL SERVER 1

[JBuyna]

Hello,

I have been experiencing a problem with data from a Auto number field not showing up on the MS Access 97 /2000 client form.

The data is incrementing fine on the SQL server but, it just does not appear on the linked form when I ADD a new record.

Does anyone have a good direction I should be looking in or better a solution.

 

[Lemonizer]

See

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8075

I had the same problem, and this is fixed

 

[JBuyna]

Thank you for the info it seems to work. I also tried another command called refresh and that also seems to work.