schema.ini created automatically by access

[arnold]

I was exporting/importing data from Access 2002 tables to txt files once
and schema.ini file was created automatically in the same directory with
table.txt
Now I can not remember how it happened - I would like to have shema.ini.

Could you please remind me how to do it.

Thanks.

 

[John Nurick]

As I said in another post, Access creates schema.ini automatically in
some circumstances, but normally you need to create it yourself, either
manually (in a text editor) or by writing and running VBA code.

For documentation of schema.ini, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

This article describes how to create Schema.ini based on an existing
table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512

See also:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090
http://www.devx.com/tips/Tip/12566

 

[arnold]

As I said in another post, Access creates schema.ini automatically in
some circumstances, but normally you need to create it yourself, either
manually (in a text editor) or by writing and running VBA code.

For documentation of schema.ini, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

This article describes how to create Schema.ini based on an existing
table in your database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;155512

See also:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;149090
http://www.devx.com/tips/Tip/12566

Hello, John
Thanks for your quick reply.
Could you please list those special circumstances, when Access creates
schema.ini automatically?
I don't have a problem to create it manually - it's not my point.
I just want to have a control over situation and behaviour of Access.
Best regards,
Arnold

 

[John Nurick]

The only ones of which I am aware are those that have already been
mentioned in this thread.

 

[arnold]

The only ones of which I am aware are those that have already been
mentioned in this thread.

Thank you for your help.