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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-29-2002, 03:11 PM   #1
st3ve
Registered User
 
Join Date: Jan 2002
Location: Cwmbran, S.Wales, UK
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
st3ve
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
Reply

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
General
Tables
Queries
Forms
Reports
Macros
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