By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,062 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,062 IT Pros & Developers. It's quick & easy.

MsAccess interop from C#: TransferText & SaveAsText errors.

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.