Solved

Operation not supported in transactions (Error 3246)

Posted on 2009-04-14
5
1,190 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

717 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