Solved

Access Data_Types in ASP adSchemaColumns

Posted on 2004-04-11
7
357 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
classic asp checkbox uncheck and check 2 68
Select distinct 25 115
Microsoft SQL ADO Conn Issue 6 50
Downside of adding characters set in ASP pages 6 29
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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