Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Odd error message "can't open a form whose query..."

jsteph (TechnicalUser) (OP)
24 Jan 06 9:13
I get the below error in access97:

Quote:

Can't open a form whose underlying query contains a user-defined function that attempts to set or get the form's recordsetclone property
When I run a query.  The query contains one function Len()--not even a user defined one.

There are no forms whatsoever in this mdb--it's a scratch db I created and have just a couple of local jet tables and a couple of odbc-linked tables.  Again--no forms, no reports, no user-defined functions.  I'm just opening a query that looks at a jet table and gets the len() on one of the fields.

I googled the err msg and found nothing, I was just wondering if anyone has seen this?
--Jim
lynchg (Programmer)
24 Jan 06 9:21
Sounds strange, have you tried repairing the database?

If that doesn't do anything I would create a new database and import the tables and queries into the new one.

Sounds like it may be corrupted.
psemianonymous (Programmer)
24 Jan 06 22:50
I've never seen it, my bet is the ODBC table links are causing the weird behavior.
jsteph (TechnicalUser) (OP)
24 Jan 06 22:58
Thanks for the responses.  There's one other possible explanation, but I checked and the timing doesn't add up.  I'm working on a terminal server from home, and I have a few scheduled tasks that are Access db's that run and do a few things.

So I thought maybe it was from one of those tasks, yet none of the task run times were close to when this happened (and they only run a few minutes), plus, the times when I'm on the server and those tasks do run, I see them pop up and I have to minimize them to keep working.  When I got this particular error, the db I was working on was the only thing open.

The db was near max size, in fact as I was moving data I had to compact it once when it got too close to max, but it never showed any corruption signs and worked fine but for that one error.  It hasn't happened again so for now I'll chalk it up to 'one of those things'.
--Jim

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close