MsAccess interop from C#: TransferText & SaveAsText errors.

  • Thread starter Richard Beacroft
  • Start date
R

Richard Beacroft

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top