Category Archives: Design and Tables
Explore Your Data With SubdataSheets
Having worked with Access since the days Access 2, I am always interested in changes that will improve life for my clients. Each new version has had many new features suited to the developer or that improved the inner workings … Continue reading
Everything About AutoNumbers
AutoNumber and identity fields have some benefits—and some costs. In this article, Russell Sinclair covers just about everything you can do to manage AutoNumbers in ADO, ADOX, and DAO. Since most AutoNumber fields are used as primary keys, this is … Continue reading
Decomposing a Badly Designed Table
Many users have decided that they don’t need the full power of an RDBMS and that Excel is the right choice for storing data. It’s not a bad choice, until the application grows to the point that they do need … Continue reading
Access Traps for the Naive Developer
We all love Access, but our favorite tool has many “features” that lead the naive developer into error. You may not appreciate the cost of these less-than-helpful additions but, should you upgrade to an enterprise database, you’ll regret every one of … Continue reading
Do More for Less – Transferring Logic Through Your App
You’re probably doing too much work–you should be taking advantage of your DBMS’s facilities to get more done in less time. Andrew Wrigley discusses how the principles of declarative design, cascading, and overriding let you have Jet, SQL Server do … Continue reading
