[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Operation not supported in transactions (Error 3246)

Posted on 2009-04-14
5
Medium Priority
?
1,232 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 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

656 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