I have used make table queries for a long time sending tables from one access database to another database. Yesterday I tried to send a table from an Access 2003 to an Access 2000 database. One of the fields - contains a 5 character code and then a _ and then 6 digits - like CGTDD_234234.
When I send this column to the other database using a make table query in some cases the _ disapears, I have checked the dataset and all have underscores does anyone have an idea what is happening.
Thanks for your help access-programmers.co.uk is a fantastic resource.
Cheers,
Oliver
When I send this column to the other database using a make table query in some cases the _ disapears, I have checked the dataset and all have underscores does anyone have an idea what is happening.
Thanks for your help access-programmers.co.uk is a fantastic resource.
Cheers,
Oliver
