Solved

Recordsetclone ? Underlying table ?

Posted on 1998-09-25
6
689 Views
Last Modified: 2012-06-21
Hi experts,

In a macro in access 2.0 which does some simple
runsql statements, which contain only a few simple delete and update sql's i have an error. This macro run's at night and then i have the error, when i rerun it in the daytime i have no error.

the error : 'Can't open form whose underlying query contains a user-defined function that attempts to set or get the forms recordsetclone property.'

I am not opening a form. I don't have a clue.
In the macro i don't use the recordsetclone property.

Jan

0
Comment
Question by:jan_l_keersmaekers
  • 2
  • 2
  • 2
6 Comments
 
LVL 7

Expert Comment

by:spiridonov
Comment Utility
Post here  your macro code that produces an error.
0
 

Author Comment

by:jan_l_keersmaekers
Comment Utility
it contains statemens as

RUNSQL
Delete * from TITB006

this mdb contains no forms

0
 
LVL 7

Expert Comment

by:spiridonov
Comment Utility
What statement is producing error? Post it here. Where do you see this error?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 3

Expert Comment

by:kaldrich
Comment Utility
Are you running a connection to a database other than Access (via ODBC?)
0
 

Author Comment

by:jan_l_keersmaekers
Comment Utility
no

0
 
LVL 3

Accepted Solution

by:
kaldrich earned 40 total points
Comment Utility
Your macro is too simple to be causing this problem.  Let's try this: build your query in Query Builder.  Instead of using a RunSQL, try OpenQuery to run your built query.  Hope this helps.

Kevin
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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 …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 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

21 Experts available now in Live!

Get 1:1 Help Now