News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, May 22, 2008

Why SQL Server drops connection

Some days ago my client asked me why 2 workstations loosing connection every 30 minutes. Only restart of PC (!) helps to run application again! First guess was that something wrong with network for these PCs, but no, network was ok. Finally he noticed that DNS settings are different, both DNS servers are the same, one - local server and other – external, but in other order. Don’t know which one exactly caused this problem, but certainly this is not a good configuration, I would better leave only one, local server, as DNS server, and let it decide how to deal with external DNS requests.

Anyway – another option is to run Cliconfg and create an alias to SQL Server using TCP/IP library and its IP address, this always works fine for me.

Labels: ,

Tuesday, May 13, 2008

Microsoft Access Video Tutorials

Bob Heifler from pointed me to these video tutorials, which can be useful mostly for novice Access users:

How to write Visual Basic for Applications (VBA) functions

How to create a Subroutine using VBA programming code

How to write error trapping code for VBA functions and subroutines

Use Access Events to trigger Visual Basic for Applications (VBA) Programming Code

Data Validation code for Microsoft Access forms

Methods for debugging Visual Basic for Applications(VBA) program code

Create different types of pop up user Message Boxes with VBA code

Conditional Formatting of form and report controls without needing to write VBA programming code

Microsoft Access 2007 Tutorial - How to use File Attachment Controls

How to display Calculated Values in Microsoft Access Forms or Reports

Microsoft Access 2007 Anchoring Fields so they stretch to the changing size of a form or report

Microsoft Access 2007 Tutorial - Data Collection By Email

Microsoft Access 2007 Tutorial - Outlook Task to Scheduled Reoccurring Access Imports or Exports

Microsoft Access 2007 Tutorial - How to show Date Picker

Microsoft Access 2007 Tutorial - Alternating Row Color in Reports and Datasheet Views

Microsoft Access 2007 Video Tutorial -Queries Part One - Simple query formulas combining field values, arithmetic on field values, creating alias field names, and use of NZ function

Microsoft Access 2007 Video Tutorial - Queries Part Two - Query Table Joins

Microsoft Access 2007 Video Tutorial - Queries Part Three - Query Criteria Methods and use of Like Operator and Wildcard

Microsoft Access 2007 Video Tutorial - Queries Part Four - Action Queries - Make Table Query, Update Query, Append Query, Delete Query

Microsoft Access 2007 Video Tutorial - Queries Part Five - Using Aggregate Functions in Group By Queries

A single function to get any number of stored public variable values


Monday, May 05, 2008

How to deploy Access 2003 runtime with SP2/SP3 applied

Tony Toews, Access MVP, mentioned this post - Nested msi with custom action : msp file.

Update: Sascha Trowitzsch, Access MVP, have written a tutorial on how to create the patched runtime.

Labels: ,