In my Access97 application I have a Make Table query. With this I'm building a new table from some existing field in other tables, and with a couple of data enterede by the user on a form. The fields made up from the the form has always been created as type Text in the new table.
After converting to Access 2000 those fields are instead created as type Binary. WHY .....
I'm using it the new table to create a .txt document with I'm again is using to merge into a predefined Word merge document. If those fields have the type binary the output to this .txt file is wrong.
1. Can I in some way control what type those field shall be in the new table ?? How ??
2. Can I change the field type afterwards after the table has been created ?? How ??
3. Is there a hold other way to create this merge file ??
I realy hope somebody can help me with this. It seems so simple but I just can't get it to work.
After converting to Access 2000 those fields are instead created as type Binary. WHY .....
I'm using it the new table to create a .txt document with I'm again is using to merge into a predefined Word merge document. If those fields have the type binary the output to this .txt file is wrong.
1. Can I in some way control what type those field shall be in the new table ?? How ??
2. Can I change the field type afterwards after the table has been created ?? How ??
3. Is there a hold other way to create this merge file ??
I realy hope somebody can help me with this. It seems so simple but I just can't get it to work.
