Solved

Operation not supported in transactions (Error 3246)

Posted on 2009-04-14
5
1,148 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

863 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

26 Experts available now in Live!

Get 1:1 Help Now