Search results

  1. I

    VBA error trapping for SQL Server connection

    Hello! I have a front end Access DB 2007 that calls stored procedures (SP) in SQL Server 2010 (ODBC connection through DSN). Today the server went down while a SP was executing. The Access application just hung and could not be closed by any other means than through task manager. How do I trap...
  2. I

    Question Enable all Macros Settings an evil must?

    Why does one have to enable all macros in the trust center in order for VBA to run? I'm making front end applications with Access and having to allow ALL macros to make them user friendly makes a huge hole in general security. I don't use any macros - it's all done by VBA. Users are on a...
  3. I

    Exporting Report to PDF blank fields on some computers only

    Hi all, I have a report (Access 2007) with subreports that is being exported to pdf. It all works fine on PC except for on a virtualbox and a laptop. When the user exports the report to pdf, it leaves some subreports blank! If the report is opened in the DB it pulls data as it should and all...
Back
Top Bottom