Search results

  1. T

    Automatic backup of the back end - can it be done

    Server side admin stuff One of the many reasons I prefer to use Access for what it is great at (UI & RAD) and why I stick to SQL Server at the back end. With SQL Server (even the for free SQL Express) you can schedule backups of the entire database, the sections only that have changed since...
  2. T

    ADO vs SQL Insert

    Ado, Ole Db, Dao The major difference between OLE DB (SQL Insert/Update/Delete) is client vs server and security. The first thing to remember is that SQL is broken into 3 distinct categories of languages (DDL - Data Definition Language, DCL-Data Control Language and DML - Data manipulation...
  3. T

    Access 2007 Runtime Problems

    Subform fails to display This is a wierd one. ENVIRONMENT Data: Stored in SQL Server 2005, normalized to 3NF. Link Method: Normal - linked tables from SQL into Access Access File Type: ACCDB Development Environment: Mix of XP & Vista Client Environment: XP workstations, Windows 2003 Server...
  4. T

    Access 2007 Runtime Problems

    I would like to start a single thread that lists all of the problems associated to the use of Access Runtime here. If there are more than say 3 or 4 responses on a given problem it warrants a new thread with links from this central thread. I have already noticed several discussions across the...
Back
Top Bottom