|
Groups should request their database layouts using the
following or similar sceme. Then mail the request as an attachment mailed to Stuart. Table #1: Name
| Field Name |
Type |
Size |
| TableID |
Number (Long) |
- |
| Field1 |
Text |
40 |
| Field2 |
Date/Time |
- |
etc... |
|
|
| FieldN |
Yes/No |
- |
Notes:
1) Repeat Pattern for evey table requested.
2) Fields names should not contain spaces, punctuation, or special characters and should
start with a letter.
3) Use the following Table of Data Types
Commonly used column types
| Constant |
Value |
Access |
VB |
| adBoolean |
11 |
Yes/No |
Boolean |
| adTinyInt |
16 |
Number/Byte |
Byte |
| adSmallInt |
2 |
Number/Integer |
Integer |
| adInteger |
3 |
Number/Long |
Long |
| adCurrency |
6 |
Currency |
Currency |
| adDBTimeStamp |
135 |
Date |
Date/Time |
| adSingle |
4 |
Number/Single |
Single |
| adVarChar |
200 |
Text |
String |
| adLongVarChar |
201 |
Memo |
String |
[csc96b/_private/footer.htm]
|
|