Scenario 2 – Error occurs when opening a connection The error will occur when you call the. Yes I agree that the link provided was a common error message name for two different issues. If so, what is it? The time now is I don’t see that too often. See the visual basic debugger script, example shown above.

Uploader: Samukazahn
Date Added: 9 October 2005
File Size: 23.79 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 41903
Price: Free* [*Free Regsitration Required]

It’s hard to diagnose when you are restricted from the data source.

Extract picture from database without using hard drive. I don’t know if they even backup the logs or anything, I don’t have that type of access.

Question about a run-time error ‘-2147217887 (80040e21) in MS access 2003

By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. I also print the same query and execute it directly in my database and it is working.

See code snippet above. I guess you just learn things as you go. Dirk Goldgar Replied on February 17, We recently had a server upgrade done on our shared website that has caused us a lot of problems.


We need more information about what you have done to trouble-shoot. You can now find them here. If so, the entry for your database in the returned list of records will show you what should be done to allow the log to be truncated. Port 25 has either had the permissions changed, or the access port to send email through the server from MSaccess has been changed altogether.

asp classic – Query creating issue with ODBC drivers – Stack Overflow

Post as a guest Name. It’s possible, unfortunately, that you won’t have the necessary permissions to run that query.

ODBC driver does not support the requested properties. Hello Dirk, Thank you for confirming what I suspected, that it is a server side issue. Open method on an ADO Connection object.

Obc File To Database. To get around this problem either use a locktype other than adLockBatchOptimistic eg adLockOptimisticor use a client-side cursor Scenario 5 – Error occurs with Access, when using Jet. Here is where the debugger takes me when the error pops up: I wonder if the recent upgrade involved a large number of inserts as data was transferred to a new database, and that filled up the log. In reply to dhookom’s post on February 17, I just realized I forgot to comment that this may be 880040e21 cause even though it works interactively.


Home Forum What’s New?

Thanks for your reply. WE use MS access to run queries on our mssql database.

Tech support scams are an industry-wide issue where scammers attempt to trick you into paying for unnecessary technical support services. Classic VB6 and prior forum so please pay attention to what and where you post.

Question about a run-time error ‘ (e21) in – Microsoft Community

ODBC driver does not support the requested properties hi, I think so. I can open datasheet view of all tables from within ms access by right clicking on any table, selecting design view, then I can right click to select datasheet view.

This error is caused when you try to insert too much data into a specified field. I have an idea. ODBC driver does not support the requested properties hi, odbc driver 5 is beta version.

The above web page warns: The error generated looks like: