Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UDB Linked Tables (MS Access 97)

    I have linked a number of tables from a UDB database to MS Access 97, all bar one table can be seen and manipulated as expected. However one table in table view shows that all the records as #Deleted. I can see the records via a pass-through query which returns them as read only. I have dropped the table and re-linked several times. I have rebuilt the UDB table but I still have the same problem. Has anyone come across this before?

    Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UDB Linked Tables (MS Access 97)

    I have no experience with this myself; the following is from searching the newsgroups.

    1. Does the offending table have a primary key? This is required if you want the table to be updateable in Access.

    2. It seems that some field types in the primary key can cause problems in Access, such as Timestamp and Decimal.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UDB Linked Tables (MS Access 97)

    There may be something in this , I do have a primary key which includes a timestamp. I think I may create a view breaking out the timestamp to see if this helps.

    Thanks
    Caz

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: UDB Linked Tables (MS Access 97)

    The reason Timestamp is a problem is because it doesn't have an exact equivalent in Access and Access doesn't recognize the datatype, which is not the same as an Access datetime field.
    Charlotte

Posting Permissions

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