Results 1 to 2 of 2

Thread: Linked Tables with SQL 2000 and Access 97

  1. 05-30-2003, 05:39 AM #1
    AnnetteBean
    AnnetteBean is offline Registered User
    Join Date
    May 2003
    Posts
    30

    Linked Tables with SQL 2000 and Access 97

    I have created a SQL 2000 database and using Access 97 as a front end.

    I deleted the contents of a table using SQL and since then the records shown in Access are shown as #deleted. There are no uncommited transactions or stored procedures running. You can add more records through Access and these are shown in SQL however you cannot delete records through Access.

    I have re-created the table with both the same name and a different name and it makes no difference.

    Has anyone come across this before.

    This has now been resolved as Access didn't like a data type that had also been amended in SQL.
    Last edited by AnnetteBean; 05-30-2003 at 07:38 AM.
    Reply With Quote Reply With Quote
  2. 05-30-2003, 08:25 AM #2
    fatherjack
    fatherjack is offline Registered User
    Join Date
    Nov 2002
    Location
    cornwall
    Posts
    187
    I have seen this problem before.

    It can be caused by the field data types in SQL not being accepted by the Access front end. BigInt and TinyInt were the culprits, changing them to an alternative type cured the problem.

    HTH
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules