Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004

    Unanswered: Linked Table to Access

    I've created a linked table to Access. I want to be able to delete records and modify existing records through this linked table. I used the account with sa privelleges yet i am unable to delete/update any records.

    Does anyone know if there is any fix or am i doing anything wrong ?

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Are you getting any sort of error messages?
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  3. #3
    Join Date
    Dec 2004
    Madison, WI

    SQL Server Permissions

    Try going into SQL Server under Roles for that database. Click on the Public and make sure all the user created tables are checked in the rows for all the columns (green checkmark). Also make sure you have permissions which is sounds like you do as well as any other users. Maybe add your login account to the Security and then also to the database Users. It should default to the Public role as permissions. Did you set SQL Server up with Mixed Authentication?
    Last edited by pkstormy; 11-08-05 at 18:27.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Feb 2004
    One Flump in One Place
    Also check that you have unique indexes\ PKs set up for the table. Access won't edit data in a linked table without a candidate key field(s). It will draw this from the BE or request this from you when you link if such a constraint isn't defined in the BE. If you don't specify these fields in the latter instance then Access will link to the data but you get read only acccess.

    pootle flump
    ur codings are working excelent.

Posting Permissions

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