×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Linked ODBC table (MSSQL7) with MS Acess97

Linked ODBC table (MSSQL7) with MS Acess97

Linked ODBC table (MSSQL7) with MS Acess97

(OP)
Hello, I am using Microsoft Access97 and using a linked table from MS SQL7.0. I can link the table with no problem, but when I try to add data or change data, 1 of two things seem to be happening. 1ST I will get a message saying that someone else has changed the current record... which is impossible, since I am the only one who has access to this db... after while it will let me add records, however, when I look at the linked table, every other row is filled across with the word #DELETED
When I look at the table using SQL Enterprise Manager, everything looks fine. Does anyone know what is going on here? I am wondering if perhaps it is just not commiting the changes.. is there anyway to force MS Access to commit the changes immediatly?

RE: Linked ODBC table (MSSQL7) with MS Acess97

Check your SQL (particularly values for variables).

To commit in a record to SQL Server via Access, you could do this via two methods:

1) Use the workspace object and use the begintrans/ committrans methods around each record insertion.

2) Write an SQL string "Commit tran .." and use the dbSQLPassThrough option of the db.execute method.

Hope this works, but I would check your SQL via the query analyser in SQL Server 7.

** I presume you are using DAO (would work for other models aswell)

Cal

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close