Run-time error '2001' - you cancelled the previous operation

[niallo32]

I get the above error message when I try and run an Access Form on any Client or Terminal Server session on our Network.

When I press 'Debug' - the following appears in Visual Basic

'DoCmd.OpenQuery ("qry products to be ordered")'

If I press Run Sub/Userform - the original error appears.

I rebooted the File Server where the database was...same error occurs with Office 2000 & Office XP

Thanks

 

[smedvid]

Ok u have some details to fill in first...
1. Has this ever worked previously?
2. Is the problem reproducible on all environments (PCs) or just some?
3. Does the query "qry products to be ordered" exist and will it run stand-alone through the Query Tab in MS Access?
4. Do all the tables/views/queries referenced in the "qry products to be ordered" query exist?
5. Have you tried to Compact/Repair?
6. What Version of MS Access are you using?

Provide some info and perhaps a snapshot of the SQL used for the query and it may enlighted others on the nature of the issue...


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...