Geeks With Blogs

News My Blog has been MOVED to
Michael Freidgeim's OLD Blog My Blog has been MOVED to MS Access
Web Browser control in MS Access form craches when Internet Explorer 7 is installed.
We have MS Access XP application that has form with embedded Web Browser control, that is used to show links.The application was build on development machine with IE 6 installed. It was found that if Internet Explorer 7 is installed on a client machine, attempt to open URL in embedded Web Browser control causes Access to crach with C0000005 error.We came out with the simplest solution( may be not acceptable for others) to completely exclude Access form with embedded control and open links in the ......

Posted On Friday, March 9, 2007 11:24 AM

Search Access database source code
If you have MS Access database(or project ADP) and it is used SourceSafe for version control, the simplest way to search VBA source code is to use Visual Studio “Search in Files” function pointed to <path>\YourDatabase.scc folder. Note that it will also search form and reports properties and controls declarations, which can be quite handy.I am using it with Access XP. May be, latest virsions of Access have integrated search, similar to VS ......

Posted On Friday, March 9, 2007 11:05 AM

Overflow error when opening form with MSCal.ocx in Access 2002
Our Access XP application uses calendar control(MSCAL.OCX).It works fine on most machines, however some sites reported "Overflow" error(6) when they tried to open a form with a calendar.It's possibly related to problems, described in the articles or Our support team managed to workaround the problem by manually copy expected version of mscal.ocx instead of wrong one ......

Posted On Thursday, March 1, 2007 1:50 PM

Possible reasons for Access messages "Data Being Updated by Another User"
I was asked to investigate, why in Access 2000 linked table(to SQL server database) any change in data was refused with message returning "Data Being Updated by Another User".The actual message could be misleading, because it returns if Update SQL returns 0 records back.Access creates dynamic SQL passing in WHERE clause current values of fields.However if column was created as BIT NULL and actually has NULL value, access sends in WHERE columnName=0 , which causes mismatch.The problem happened in ......

Posted On Tuesday, February 20, 2007 1:04 PM

Link Child/Master fields in ADP do not work for Numeric key
A long time ago I reported the problem with MS Access ADP Reports/Forms with subforms/subreports where LinkMaster/Child fields are numeric but not integer (i.e scale greater than zero). I had the join field defined as numeric(28.2).However Access doesn't recognize scale and generate incorrect SQLstatements, egexec sp_executesql N'SELECT * FROM "dbo"."PickSlipOverdues" WHERE((@P1 = "PatronID"))', N'@P1 numeric(28)', 7instead of correct , N'@P1 numeric(28.2)', 7.01 As a result join doesn't work and ......

Posted On Wednesday, September 27, 2006 4:08 PM

problems attempting to install a 2002 access deployment package on a machine with Windows 2003
Someone asked me with relation to my post Access 2003 Package Wizard - a big step BACK. “I was wondering if you have run into problems attempting to install a 2002 access deployment package on a machine with 2003. Does not seem to work.“ I've emailed him the following answer: You should check MSDN article : "You may receive error messages when you install an Access 2002 runtime deployment package on a computer that is running Windows XP SP2 or Windows ......

Posted On Tuesday, May 16, 2006 9:15 AM

Access 2003 Package Wizard - a big step BACK.
I am supporting Access XP(2002) Project application and recently found problems with SourceSafe 2005. Because I've got a new machine, I decided to install the latest Access 2003. The ADP file was retrieved from SourceSafe and I didn't have any major problems with upgrading. However when I wanted to create Setup Project, I found that the old MOD 2002 Packaging Wizard is not available any more, but a new Access 2003 Developere Extensions Package Wizard should be used. I found the following issues with ......

Posted On Wednesday, March 22, 2006 7:17 AM

Access 2002(XP) is not working with Visual SourceSafe 2005

I installed Visual SourceSafe 2005 on the machine where I have Access XP development, that worked fine with VSS 6.0D.

When open Access ADE, it showed strange errors, and didn't check out files.

So I had to return back to VSS 6.0 by running “regsvr32.exe ssscc.dll" command in the VSS
binaries folder, as it is suggested here.  

Posted On Monday, March 6, 2006 11:41 AM

Copyright © Michael Freidgeim | Powered by: