General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
Hi Borislav,
Essentially your new code utilizes a different connection string than my original code. You added more error checking code as well.
I sucessfully connect as before and create the cursor curMDB with the one record in it.
The sqlexec result however is the same.
The contents of MyErrorFile.TXT reveal the error as previous:
Can not retreive data from:
National Ancillary Data. Reason:Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'National Ancillary Data'.
However, opening the database in Access, I can view the data within the table as well as export it to a CSV file.
Attempting to attain this result via CREATEOBJECT('ACCESS.APPLICATION'), I can create a RecordSet with the data in it. I am trying to avoid having to loop through each field with the record for each record in the data set. I thought that I could take advantage of the object's SaveAsText method or perhaps some other method that I am not aware of to get the table into a CSV file. I did notice that the object's AutomationSecurity value is set to 2 (Medium). I have tried altering this value to 1 and 3 (the only other options) with the hopes that doing so would soften the security. However this seemed to have no effect. I don't have any first hand experience with Access and I am trying to fight my way through this. Any thoughts along this line?
Thanks again for all your time and effort.
Vince
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only