asked on

Need Read/Write access to Linked Tables

I'm updating a client's Access front ends programmatically to change linked tables from an insecure Access back end to a more secure MSSQL database. The linked tables seem to be read-only, but the application splitter wizard makes me believe that read-write ODBC linking is ossible. What do I need to do to allow insertion and deletion of records in these tables? Thanks!

SOLUTION

bandriese

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ftmickey

ASKER

Is is using SQL or Access forms and objects to do the updates? I know that I can use SQL, but there's a WHOLE lot of code in these applications that takes the approach of assigning a table to the form and then modifying form controls to update the current record. Reading I've done since the original question sounds as if Access links to ODBC tables are read-only by definition, and I'm afraid that may be my problem.

SOLUTION

GRayL

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

bandriese

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

mrnev

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

GRayL

ftmickey: So what cured it? You've split points but I'm afraid I'm none the wiser. I don't think anyone reading this thread in the future, looking for an answer will, any the wiser either.