Replies

The exact reason that Microsoft created the registry entries is explained in knowledge base article # 239105 – Jet 3.5 Text ISAM Allows Users to Append Lines to System Files

regards,
Wayne

The exact reason that Microsoft created the registry entries is explained in knowledge base article # 239105 – Jet 3.5 Text ISAM Allows Users to Append Lines to System Files

regards,
Wayne

You can run out of autonumbers if you purge records from the table (e.g. archiving to a linked database). The autonumbers are not re-usable. We have in fact experienced this in our business.

regards,
Wayne

You can run out of autonumbers if you purge records from the table (e.g. archiving to a linked database). The autonumbers are not re-usable. We have in fact experienced this in our business.

regards,
Wayne

There is one limit – IF you are using an autonumber field as a primary key;
please see Microsoft Knowledge Base Article – 97520
…The maximum value of the Counter data type is the same as the maximum value of a Long Integer. A Long Integer is 32 bits long and has a maximum positive value of 2,147,483,647 and a minimum negative value of -2,147,483,648.

If you use a Counter as the primary key, a table can contain up to four billion records. The maximum number of records in the table is also limited by the maximum size of a database.

regards,
Wayne

There is one limit – IF you are using an autonumber field as a primary key;
please see Microsoft Knowledge Base Article – 97520
…The maximum value of the Counter data type is the same as the maximum value of a Long Integer. A Long Integer is 32 bits long and has a maximum positive value of 2,147,483,647 and a minimum negative value of -2,147,483,648.

If you use a Counter as the primary key, a table can contain up to four billion records. The maximum number of records in the table is also limited by the maximum size of a database.

regards,
Wayne

the registry contains the valid extensions for ISAM formats. the following registry key contains the values for import and export filters.

HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0ISAM FormatsText

modify the ‘Export Filter’ data to contain the ‘dat’ extension

regards,
Wayne