Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36

    Unanswered: Can't connect with full access!

    i have a database that i am trying 2 convert from access to SQL Server...

    but when i try to read the SQL Server tables through MSAccess i can't enter or edit data... the database properties, and the user permissions are NOT readonly in both access and SQL Server - so whycan't i write data?

    Thanks Kris

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What was the error and ensure the login used to connect from MS Access to SQL server does have required privileges.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36
    no error i just can't add or edit data ...


    special privalages?? - i dun no exactly what u mean but i dun think there should be

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    ata bare minimum the user account that you are using should have read select update insert and delete permission on the tables.

    are you using a sql login to connect to the sql server or are you using a trusted operating system account?

Posting Permissions

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