Database Tips

Top  Previous  Next


Table Identifiers


It is possible to have tables that do not have a primary key (unique identifier).  However dbQwikSite uses the table primary key to generate code and know how to locate records.  It is best to ensure that tables linked to dbQwikSite pages do have a primary key assigned to them.




MDAC is microsoft's driver software for ADO connections.


Microsoft MDAC Version 2.8 or higher is required to allow all dbQwikSite operations and advanced functionality.


When you start dbQwikSite, it will show your installed MDAC version in the bottom left hand corner of the application. If your version is earlier than 2.8, go to Microsoft's site to download the latest version.