Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2011
    Posts
    29

    Unanswered: Access 03 - SQL Server Exress 12

    Attachment 1.jpg shows the structure of table dbo.tblCustomer in Management Studio. Attachment 2.jpg shows the contents of the table dbo.tblCustomer. Records 1 and 6 have fields in Greek. Attachment 3 shows the tabular form in Access 03, based on ODBC-linked table dbo.tblCustomer. (In the production project I intent to use ADO with no linked table).

    Does anyone know why I get the "Deleted" fields for records 1 and 6? In the table (Management Studio) I see the records fine.

    Regards,
    John
    Attached Thumbnails Attached Thumbnails 1.jpg   2.jpg   3.jpg  

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    My guess is that Access can't cope with Greek in the table and this is the result. If you have an Access table with corruption/foreign characters then you will often see 'Deleted'.
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Sep 2011
    Posts
    29

    Access 03 - SQL Server Exress 12

    I can safely say that Access with Jet/ACE can handle Greek. I have been using it in a commercial product (Visual Dentist: Dental Software) since 1997.

    When I use ADO (see below) in the On Open of the form there is no problem. The contents of the record appear fine.Please see attachment.

    Code:
    Dim con As New ADODB.Connection
    Dim rst As New ADODB.Recordset
    Dim cmd As New ADODB.Command
     
    'OLE DB (ADO) Native CLient
    con.ConnectionString = "Provider=SQLNCLI11;" _
             & "DataSource=MSSQLSERVER;" _
             & "Server=(local);" _
             & "Database=JP2;" _
             & "Uid=sa;" _
             & "Pwd=p5p6p7p8;" _
             & "DataTypeCompatibility=80;" _
             & "MARS Connection=True;"
    con.Open
    con.CursorLocation = adUseClient
    con.CommandTimeout = 0
      
    rst.Open "dbo.tblCustomer", con, adOpenForwardOnly, adLockOptimistic
     
    Set Me.Recordset = rst
     
    con.Close
    Set con = Nothing
    Set cmd = Nothing
    Set rst = Nothing
    John
    Attached Thumbnails Attached Thumbnails Greek.jpg  
    Last edited by JohnPapa; 02-06-13 at 09:40.

  4. #4
    Join Date
    Sep 2011
    Posts
    29

    Access03-SQL Server Express 12 - ROWVERSION

    Another issue that may or not be related.

    Attachment Michael4 shows the ROWVERSION field that was defined in simple table with 2 entries. You can see the binary value of the RV field.

    Attachment Michael5 shows the Access 03 form populted by using ADO. There are no values in the RV field. Any ideas why?

    Thanks,
    John
    Attached Thumbnails Attached Thumbnails Michael4.jpg   Michael5.jpg  

Posting Permissions

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