471,599 Members | 1,839 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,599 software developers and data experts.

MsAccess interop from C#: TransferText & SaveAsText errors.

Trying to write a C# Windows App to export all objects and content from
2 MSAccess 97 databases for comparison analysis.

very little documentation found.
Have managed to instantiate MSAccess, load database and iterate through
relevant objects.

Call to TransferText raises error: "Bad Variable Type" error.
Call to SaveAsText raises error: "Object Reference Not Set To An
Instance Of An Object" error.

Calls look correct!
I have read an article that talks about the TransferText error being
related to a missing Schema.ini file. Although the resolution suggested
does not explain how to tie in the application code with the Schema.ini
file. (Have Jet Engine 4 SP 8 installed).

Any help or pointers in the right direction would be greatly
appreciated.

Thanx in advance.
Rik

p.s. Calling the Application.Quit() method does not actually close
MSAccess, only the database within the MSAccess environment?


*** Sent via Developersdex http://www.developersdex.com ***
Nov 17 '05 #1
0 1470

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by roy | last post: by
reply views Thread by keefah | last post: by
3 posts views Thread by Jeff Pritchard | last post: by
4 posts views Thread by Annick Van Hoof | last post: by
reply views Thread by stuart | last post: by
2 posts views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.