Professional Web Applications Themes

VBA in Access linked to SQL tables not working - Microsoft SQL / MS SQL Server

I have an Access database and I moved the tables to a SQL Server. I am trying to update some records using VBA and the Addnew and Update commands. When the code is executed the system locks up. There is no error message. In my Access front-end, I use similiar code and it is working. This is the first time I added code since I moved the tables to SQLS. Can anyone help?...

  1. #1

    Default VBA in Access linked to SQL tables not working

    I have an Access database and I moved the tables to a SQL
    Server. I am trying to update some records using VBA and
    the Addnew and Update commands. When the code is executed
    the system locks up. There is no error message.

    In my Access front-end, I use similiar code and it is
    working. This is the first time I added code since I moved
    the tables to SQLS.

    Can anyone help?
    Gerry Guest

  2. #2

    Default Re: VBA in Access linked to SQL tables not working

    Be sure to have a primary key defined for your table. Else, sqlserver is
    going to lock your entire table during DML operations.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Gerry O" <com> wrote in message
    news:03c501c350a6$0299c150$gbl... 


    oj Guest

  3. #3

    Default Re: VBA in Access linked to SQL tables not working

    You can post some codes here so we can see what's going on. Also, you might
    have better luck posting this question in an Access Adp group. There are
    more experts in that area there.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Gerry Oldenski" <com> wrote in message
    news:#phx.gbl... 


    oj Guest

Similar Threads

  1. Problem: Cannot query linked Access tables in CFMX 6.1
    By MikeLF in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 4th, 07:04 PM
  2. Connecting to linked SQL tables through access
    By Bonnie in forum ASP Database
    Replies: 4
    Last Post: December 19th, 07:31 PM
  3. Replies: 1
    Last Post: September 2nd, 10:46 PM
  4. problems with linked access tables in ASP
    By Laura in forum ASP Database
    Replies: 6
    Last Post: August 20th, 06:22 PM
  5. Access query of linked tables returns EOF
    By Bob Barrows in forum ASP Database
    Replies: 1
    Last Post: July 3rd, 07:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139