Solved

Access Data_Types in ASP adSchemaColumns

Posted on 2004-04-11
7
352 Views
Last Modified: 2007-12-19
Helllo Just a quickie

I need to know all access field types + there corosponding Data_types in Names not numbers

and all the default values for each + all max field lengnths for each

Im sure somebody has a hany link tucked away

cheers all.
0
Comment
Question by:Skippythekid
  • 4
  • 3
7 Comments
 
LVL 7

Expert Comment

by:brgivens
ID: 10801245
autonumber: adInteger
text: adVarWChar
memo: adLongVarWChar
byte: adUnsignedTinyInt
integer: adSmallInt
long integer: adInteger
single: adSingle
double: adDouble
replication id: adGUID
decimal: adNumeric
date time: adDate
currrency: adCurrency
yes/no: adBoolean
ole object: adLongVarBinary
hyperlink: adLongVarWChar
0
 
LVL 1

Author Comment

by:Skippythekid
ID: 10801278
Nice one cheers do you know the default field sizes for each and max field sizes ?
0
 
LVL 7

Accepted Solution

by:
brgivens earned 300 total points
ID: 10801327
The only datatype with a variable field size is text: 0 - 255, default 50
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:Skippythekid
ID: 10801382
ta dude :)
0
 
LVL 7

Expert Comment

by:brgivens
ID: 10801397
Thanks for the points, dude!  :)
0
 
LVL 7

Expert Comment

by:brgivens
ID: 10801813
BTW... I came across this while working on another question & thought it might be useful for you:

Type                         Disk space          Values
------                        -------------         -----------
Text                          Up to 255 bytes   Variable length text
Memo                        Up to 1.2 GB       Large variable length text
Numeric-Byte             1 byte                 0 through 255
Numeric-Integer         2 bytes               -32,768 through 32,767
Numeric-Long Integer 4 bytes               -2,147,483,648 through 2,147,483,647
Numeric-Single          4 bytes               -3.4 x 1038 through 3.4 x 1038
Numeric-Double         8 bytes               -1.8 x 10308 through -1.8 x 10308
Currency                   8 bytes                Numbers with up to 15 digits to the left of decimal point and 4 to the right
Counter                     4 bytes                Automatically incremented long integer
Yes/No                      1 bit                    Boolean data
Date/Time                 8 bytes                Dates and time values
OLE                          Up to 1.2 GB         OLE objects, graphics, and other complex data
Binary                       Up to 1.2 GB         Variable length binary data

1.2GB is the max database size
0
 
LVL 1

Author Comment

by:Skippythekid
ID: 10801865
Nice one cheers m8

its much appreciated :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now