Solved

Operation not supported in transactions (Error 3246)

Posted on 2009-04-14
5
1,156 Views
Last Modified: 2012-05-06
I recently upgraded to MS-Access 2007 and now get the following error when I attempt to  "Paste Append" (from the menu)  records into a sub-form. I was able do this fine (and often) in Access 2003.
0
Comment
Question by:ortep1
  • 3
5 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24155095
0
 

Author Comment

by:ortep1
ID: 24157091
hi gary...i read that article before i submitted to ex-exchange...it does not provide a solution or even a viable workaround.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24157111
Yup, unfortunately you're right!
Not everything has a solution
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24261346
From the attached link
This is a very frustrating problem that occurs in MS Access 2007. This is a known bug in MS Access

As I wrote not everything has a solution.
Unfortuantely this is the correct answer to the question.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now