AutoHotkey Community

[Toxey]

I tried that twice, once within my program, and once just by itself, and got the same error (apparently I only got the other error once):

---------------------------
COM Error Notification
---------------------------
Function Name: "Open"
ERROR: (0x800A0E7F)
PROG:
DESC:
HELP: ,0

Will Continue?
---------------------------
Yes No
---------------------------

I'm going to try a few things, and I'll post if I have any success. Thanks, Sean.

[Toxey]

I installed a Office 2000 on this machine (with Access) to see if it would solve any missing or corrupt file issues, and no luck

I also tried to run SFC, but not having the original physical 2000 disk on this dinosaur machine makes that difficult. I did manage to change the registry to look at a copy of the i386 folder from another machine, but no luck there either.

I'm going to let this fall back off my to-do list. I love a mystery, but not one without clues.

[Sean]

My only suggestion remained is to try to re-install and/or update to the latest MDAC.

[The Unknown Jobber]

[Toxey]

I'm not sure if anyone has posted this type of example, but I could not find it, so here goes. I hope this helps someone trying to solve the ADO riddle for dBase databases. Reading records and updating fields.

I cannot stress enough how much reading the msdn info on ADO helped me figure this out. http://msdn.microsoft.com/en-us/library/ms681025%28v=VS.85%29.aspx

I don't have an example dbf file to share, but assume that wrkorder.dbf contains a unique key field of WKORDNUM (work order number), a bunch of other fields, and two long string fields called NOTE1 and NOTE2 that are (not too surprisingly) for notes. varOurWkNum is just a work order number used to pick a specific record.

In my program, I grab the two notes, remove certain references, put them all at the end of the 2nd note and put an ETA date at the beginning of the 1st note. There's a lot of fancy formatting and frippery at work.

For simplicity, this example will just read the two fields, change them slightly, and write them back.

[Toxey]

Side note to my last post.

Be careful with fields and dbf's that are indexed.

I don't believe we have any method of accessing and modifying NTX indexes on clipper databases through ADO COM, so I'm personally avoiding the problem.

Okay to modify unindexed fields (I hope), and don't delete or add an records. Basically, just sneaky modifications of "unwatched" fields.

So it's less useful than I first said, but it's still darn useful, and I will be on the lookout for a solution to the index problem.

[captainspacedog]

I have adapted the examples in this post to pull data from Access Databases.

I am having a bit of trouble figuring out how to write data to a table.
Does anyone have an examples they have adapted, that they would be willing to share.

Thanks

[make it useful]

Hi

The following code attempts to run a stored procedure and work with the record set it returns.

Since i need to set timeout, and i will be adding parameters later, i need to use ADOB.Command.

Problem is that i cant seem to set the CursorType for the recordset and get it to stick.

[doyle]

Any way to use the ADO functions to insert data into a database?

I have edited the function so the SQL is INSERT INTO, and not SELECT.

I get error code 0x80040E4D.

DESC: Authentication failed.

[tank]

then the problem is not the call its the credentials are either invalid or your credentials do not have insert privs for your table/database better get with your DBA
_________________

We are troubled on every side‚ yet not distressed; we are perplexed‚
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;

[doyle2]

[tank]

granting or revoking privilidges has nothing to do with ahk and must be done in the database by a user with priviledges to do so
_________________

We are troubled on every side‚ yet not distressed; we are perplexed‚
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;

[doyle2]

I understand that.

[Rob T]

I have this ADO function I use in VBA which executes SQL on the database.

[tank]

Executing a query is executing a query weather is select or create for drop the only difference is permissions expected return What error are you receive Are you sure you have permission to do what You need to do
_________________

We are troubled on every side‚ yet not distressed; we are perplexed‚
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;