News, links, downloads, tips and tricks on Microsoft Access and related
Friday, February 27, 2009
Tuesday, February 24, 2009
Learn Access from Crystal
Thursday, February 19, 2009
A nice tool SQL and PL/SQL Formatter (actually a web page) to format SQL language (Access, T-SQL, etc) to a number of useful formats – html, VBA, XML, whatever you can imagine. Here how html output looks like for T-SQL:
WHERE Datediff(d,tblBill.BillDate,Getdate()) > @intDays
Wednesday, February 18, 2009
Access 97 crash on Server 2003
If you would run Access 97 application on Server 2003 SP1 or SP2 – you probably experience a crash of Access while pressing a button, whatever. In order to make it running – you have to either switch off Data Execution Prevention (DEP), or add Access to exceptions list in DEP dialog.
Monday, February 16, 2009
KB960715 (IE7) is breaking Access apps
Graham Mandeno, Access MVP, have found, that latest security update for IE7 breaks Access applications using some of Microsoft ActiveX controls. Details below:
Access applications that incorporate certain VB6 ActiveX controls are failing on computers when the "critical security update" KB960715 is installed.
The update sets "kill bits" that disable certain third-party and Microsoft ActiveX controls, including the following:
Microsoft Animation Control 5.0
Microsoft Chart Control 6.0
Microsoft Animation Control 6.0
Microsoft DataGrid Control 6.0
Microsoft FlexGrid Control 6.0
Microsoft Hierarchical FlexGrid Control 6.0
Microsoft Masked Edit Control 6.0
Microsoft WinSock Control 6.0
Any form that uses these controls will give errors such as "There is no object in this control".
Any attempt to delete the ActiveX control and rebuild the form gives the error "Microsoft Access does not support this ActiveX control".
Another KB article, KB957924, is a cumulative update rollup for VB6.
It includes newer versions (184.108.40.206) of the above controls that do not have the security vulnerability.
Unfortunately, this update may only be installed if you have VB6 installed.
However, it is possible to install KB957924 on a machine with VB6 and then deploy copies of the new OCX files to the affected end-user machines.
This workaround is unwieldy, as it requires an administrator to install and register the updated OCX files on every end-user machine.
Microsoft should add the "safe" versions of the affected OCX files to the KB960715 update, so that instead of killing the old versions of those controls, the new, safe versions are installed and registered.
Furthermore, Microsoft should create another download which includes the "safe" versions of these OCX files so that machines that have been adversely affected by KB960715 can easily be updated without the need to have VB6 installed.
And some comments from other Access MVP, Sascha Trowitzsch:
BTW: I am using two tools to activate/deactivate ActiveX controls:
Monday, February 09, 2009
SQL-DMO and SQL Server 2008
If you have moved to Microsoft SQL Server 2008 and missed SQL Distributed Management Objects (SQL-DMO or SQLDMO) library - do not panic, you can download it as a part of Microsoft SQL Server 2008 Feature Pack. Actually you get Microsoft SQL Server 2005 Backward Compatibility Components, but it still works with 2008 server.
Labels: SQL Server