Home Forums Microsoft Access Microsoft Access displace input row in Access 2003 and SQL Server 2000 RE: displace input row in Access 2003 and SQL Server 2000

  • November 12, 2012 at 5:57 am

    #1558131

    WendellB (11/12/2012)

    omid.shokri (11/11/2012)

    1- I used SQL Server 2000 as DBMS.

    That wasn't my question. What is the file extension of the Access database that contains your data entry form - .ADP or .MDB?

    2- Refer 1

    3- ID and Identity column

    4- Continuous form

    the ORDER BY clause prevent me from adding a row.

    It is difficult to debug problems where you are using Access as a front-end to SQL Server as you can't really upload the SQL Server database like you can with the Access front-end. Can you script the table and copy the results to a post?

    I used .ADP file.