schema.ini created automatically by access

  • Thread starter Thread starter arnold
  • Start date Start date
A

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.
 
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
 
John Nurick said:
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
Click to expand...

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
 
The only ones of which I am aware are those that have already been
mentioned in this thread.
 
Back
Top