does anybody know what you have to do to write microsoft access files?
on table pchold format what?
and do i have to buy something from those iway people to do it??

The format you need is SQLMAC.

Example:
ON TABLE HOLD FORMAT SQLMAC

This works fine if you have Microsoft Access Data Adapter and permission to create tables.

Regards,
Mikel

This won't actually create a .MDB file but it will create a table in an Access file that is already defined to the server via an ODBC DSN.

Thanks M and K...do i need to buy that dataadapter from the iway folks? i currently use odbc to read access, is odbc enuf or do i need to buy something? do you know by any chance?