Access 2000 SCHEMA.INI file. 2

[Sanibel]

I have created a macro to export a table to a delimited text file using a Schema.ini file. When I execute the macro I get an "option is invalid" error on one of the fields so I need to modify the schema.ini file. The schema.ini file was created via the Advanced button on the Export command and I was expecting to find the file in the same folder as the exported text file. Searching through my entire file location, network and local, I can find no file called schema.ini although I can partially examine it from the Specs button on the Advanced page of the the Export command. I know I must be missing something simple but can anyone tell me where the schema.ini file can be found.

Thanks

 

[PHV]

I think the schemas are stored in the MSysIMEXSpecs and MSysIMEXColumns system tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

You can view the system tables by selecting Tools->Options->View->System Objects.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]