Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 01-29-2002, 03:11 PM   #1
Registered User
Join Date: Jan 2002
Location: Cwmbran, S.Wales, UK
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Forcing the field type

Is it possible to force the field type in the table resulting from a query?

Reason: Access2000 keeps giving me tables with field type = Binary!...according to MicroSoft this field type does not exist!!
These binary fields appear to be generated when the resulting data is 'mixed' eg.
"Q3 space 2000/2001". Also, If you then compact without removing the binary fields, it is well nigh impossible to re-open the database. Anyone else notice this? .. It doesn't seem to happen with Access97 How about Access2002?

Together we'll get there ....?....wherever there is
st3ve is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 01:56 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World