Professional Web Applications Themes

SQL Version - Microsoft SQL / MS SQL Server

I have purchased Office XP Professional which has Access. Access has some Visual Basic programming ability and some SQL ability. This was an Dell OEM installed computer so I recieved no doention or help whatsoever. I have tried to use the SQL functions with virtually no success, especially with wildcards and string manipulations. Does anyone know exactly what version of Visual Basic and what version of SQL is bundled with Office XP Professional? Any good references on how to use the functions of VB and SQL of these versions?...

  1. #1

    Default SQL Version

    I have purchased Office XP Professional which has Access.
    Access has some Visual Basic programming ability and some
    SQL ability. This was an Dell OEM installed computer so I
    recieved no doention or help whatsoever.

    I have tried to use the SQL functions with virtually no
    success, especially with wildcards and string manipulations.

    Does anyone know exactly what version of Visual Basic and
    what version of SQL is bundled with Office XP Professional?

    Any good references on how to use the functions of VB and
    SQL of these versions?


    Ron Guest

  2. #2

    Default Re: SQL Version

    Ron wrote: 

    I don't believe the SQL available within Access has anything to do with the
    SQL language in SQL Server. I believe it is it's own little world that is
    part of the Microsoft Jet Engine. So the same functions you find available
    in SQL Server are not likely to be available through Access.

    The online help in Access includes a references section for Visual Basic and
    for SQL. Look for:

    Microsoft Access Visual Basic Reference
    Microsoft Jet SQL Reference

    in the table of contents



    --
    Steve Troxell
    Krell Software
    Professional Database Development Tools for MS SQL Server
    http://www.krell-software.com



    Steve Guest

  3. #3

    Default Re: SQL Version

    > I have tried to use the SQL functions with virtually no 

    Access SQL != SQL Server SQL
    http://www.aspfaq.com/2214


    Aaron Guest

  4. #4

    Default Re: SQL Version

    Hi Ron,

    Access is not the same as SQL Server, and has very limited functionality.

    If you want SQL Server functionality, you can get MSDE from microsoft, which
    is a 'desktop' edition of their SQL Server product.

    "Ron" <marc.usda.gov> wrote in message
    news:0c6901c35d06$2586e410$gbl... 


    Curtis Guest

  5. #5

    Default Re: SQL Version

    MSDE is on the Office Professional CD. It's syntax is supposed to be
    identical to SQL Server. No Enterprise manager or QA, but the same engine
    as SQL Server. 2GB file size limitation and (I think) 5 concurrent
    connections is the max.

    --
    Kevin Hill
    3NF Consulting
    www.3nf-inc.com/NewsGroups.htm



    "Curtis Wensley" <cwensley at sydneyplus.com> wrote in message
    news:phx.gbl... 
    which 
    >
    >[/ref]


    Kevin Guest

Similar Threads

  1. Replies: 0
    Last Post: October 12th, 01:41 AM
  2. Replies: 0
    Last Post: October 12th, 01:14 AM
  3. Replies: 2
    Last Post: October 2nd, 12:17 PM
  4. Replies: 0
    Last Post: September 22nd, 05:27 PM
  5. Replies: 0
    Last Post: September 16th, 02:29 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