473,890 Members | 3,926 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.Qui t() 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 1602

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2367
by: roy | last post by:
I try to call com written in VB 6.0. When I use VS.net Studio to do the debuging, some time it works fine, some time I got the following message: Server Error in '/GISOnlineReservation' Application. ----------------------------------------------------------- --------------------- Configuration Error Description: An error occurred during the processing of a
0
2299
by: keefah | last post by:
Hi, I'm writing a C# web app that uses Outlook to send email. I use a reference to the Microsoft Outlook 11.0 Object Library, but it's giving me problems. I tracked down some stuff on the Net about the global assembly cache (GAC) and primary interop assemblies (PIA) and so forth, and did all the recommendations, in terms of tweeking Office, installing the .NET Office stuff for framework 1.1, etc. I got it to the point where it compiles ok,...
2
4710
by: BigData | last post by:
I am attempting to create a delimited text file by using DoCmd.Transfertext as shown here. DoCmd.TransferText acExportDelim, "ExportSpec", "QryFinalExport", "Fileout.txt" This works fine as long as I load the .mdb or .mde directly and run. However, for various reasons, I need to reference this .mdb/.mde from my main .mde and then run the transfertext in the referenced .mde.
3
12237
by: Jeff Pritchard | last post by:
Anyone know where can I get the correct syntax for the SaveAsText function. I found it once but can't now. The one commonly seen is not correct SaveAsText acForm, "FormName", "FileToSaveTo" The last two args are fine but the acForm is wrong. I thought it was a number from 2 to 6 Query 2
0
1196
by: chris | last post by:
Hi, I'm trying to import some text files in a simple access table, but sometimes it miss some rows after import. here is the code: Public Function OpenMyApplicationData() As Boolean Dim Upid As Boolean Dim LastBD As Integer Dim dbs As Database Dim fileN As String Dim tableN As String
4
1544
by: Annick Van Hoof | last post by:
Hi, I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6). This works almost all the time (I have uptimes of 100% on most days), but then all of a sudden a few days in a row I have the following phenomenon: ..aspx still get processed, but as soon as any of them try to read/write to a MsAccess database (using DSNLess OleDBConnection) it's timing out. This happens for a period of about 40 minutes and then all of a...
0
1641
by: Daron | last post by:
I am posting this as I have not been able to find a direct posting with a specific solution, just work arounds (usually the need to create custom import routines.) I found the solution! I am using Access 2003. The problem: When using the TransferText command in code, the first record in the text file is skipped, even with the HasFieldNames set to False.
13
5317
by: MLH | last post by:
Would like to run the control panel's Internet Date & Time program from VBA - emulating opening it, clicking the Internet Time tab and the Update Now button. I don't really care for the user to see all this. Would just like to sync the system time with the facility built-in to XP and automatically w/o asking the user to go through the steps manually.
0
423
by: stuart | last post by:
I seem to have a problem with the use of the TransferText function. In 2 applications that I have, every few months, it seems to not export a few records from a table. In another application, every 2-3 months the users would start getting run time errors after they exported data from my program. Is anyone aware of problems with this function with these kind of results. The following is a code fragement:
0
9979
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9823
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10827
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10463
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8017
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7170
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5854
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6049
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3281
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.