Using your existing Access Database (use at your own risk)
If you use your existing database make sure that it is in MS Access 97 format.
Try to make the field definitions like the ones outlined in our default
database.
ID field is REQUIRED
| C:\mdb2\____CO~1\_____O~1\music22.mdb | Tuesday, March 09, 2004 |
| Table: MUSIC | Page: 1 |
| Properties |
| Date Created: | 9/23/1996 5:59:12 PM | Def. Updatable: | True |
| Last Updated: | 11/12/2000 10:48:27 PM | OrderBy: | MUSIC.Artist |
| OrderByOn: | True | RecordCount: | 752 |
| Columns |
| Name | Type | Size |
| Song Title | Text | 150 |
| AllowZeroLength: | False |
| Attributes: | Variable Length |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | 3960 |
| DisplayControl: | Text Box |
| Ordinal Position: | 1 |
| Required: | False |
| Source Field: | Song Title |
| Source Table: | MUSIC |
| Artist | Text | 150 |
| AllowZeroLength: | False |
| Attributes: | Variable Length |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | 1950 |
| DisplayControl: | Text Box |
| Ordinal Position: | 2 |
| Required: | False |
| Source Field: | Artist |
| Source Table: | MUSIC |
| Tempo | Text | 10 |
| AllowZeroLength: | False |
| Attributes: | Variable Length |
| Collating Order: | General |
| ColumnHidden: | False |
| ColumnOrder: | Default |
| ColumnWidth: | Default |
| DisplayControl: | Text Box |
| Ordinal Position: | 3 |
| Required: | False |
| Source Field: | Tempo |
| Source Table: | MUSIC |
| Type of music | Text | 90 |
| AllowZeroLength: | False |
| Attributes: | Variable Length |