SCHEMA.INI Must I use this file name??? 
Author Message
 SCHEMA.INI Must I use this file name???


I am having a bit of a problem referencing my SCHEMA.INI file for creating
and importing data in an Access table using VB4.0 Enterprise Edition.

I'm using a fixed lenght record file to bring in (attach) the data that I
will be processing. When I'm done I delete this table along with all the data.

This is not a problem. It works fine, I attach the data from the text file,
process and then delete the table... however, for consistency I would like to
be able to have a *single* SCHEMA.INI file in my Windows directory, and here
is where the problem lies.

My program works as long as I have my table definition in a file called:
SCHEMA.INI and as long as this file is located in the *same* directory as
the data text file is.

I tried to tell VB to use c:\windows\schema.ini just like the example in the
book and in the help file.... still it won't work.

I called MS Tech support and they said that they did not know !?!????!!?

Does anyone know if this is a problem, or rather, this is simply the way it
HAS to be done?

Anyways around it?

Thanks for your time.

- Sergio Diaz

Sun, 27 Sep 1998 03:00:00 GMT
 SCHEMA.INI Must I use this file name???

This is the way is must be done. It just doesn't work otherways.

You must see the schem.ini as the header of the data file, normal
header and data are 1 file. In this case header and data are in 1

gr, Herman

Fri, 12 Feb 1999 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. Help! with Schema.ini file and ODBC text

2. How to ignore a column in Schema.ini file

3. Importing Text Files with Schema.ini and Execute SQL Missing first Record

4. Schema.ini With Adhoc ODBC Text File Connections

5. Schema.ini file date formats

6. Exporting to ASCII File with SCHEMA.INI?


8. Where to put the Schema.ini File

9. schema.ini file location

10. schema.ini and multiple files

11. ADO, Text Files and that damned Schema.ini

12. Help -- Schema.Ini file format

Powered by phpBB® Forum Software