Access 2003 adp - function not working since last windows update

  • Thread starter Thread starter Abe Munk
  • Start date Start date
A

Abe Munk

I have an Access 2003 project connected to a 2000 SQL Server. All in-line
functions that requires a parameter is not working by any user that got the
windows updates approxamitly two weeks ago.

Any solution or knowledge of a hotfix would be appreciated.
 
Try decompiling/compacting your ADP project file twice to see if it helps.
Create a shortcut and add the parameters /decompile and /compact to do it;
something like (on a single line):

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\MyProject.adp"
/decompile /compact

You could also use the old trick of changing a reference in the References
dialog window instead.

The official newsgroup for ADP is m.p.access.adp.sqlserver.
 
You did not say what version of Windows you have. They added security
features.
You might search on Trusted Sites.
 
I forgot to mention - the OS is XP PRO SP2

The problem occurs even in a new project. If I try double clicking on an
in-line function I do not get prompted for the parameters. It flashes a
window for a second then nothing happens.

Any computer that is having the problem occurred after the following updates
where installed:

- Security Update for Outlook Express for Windows XP (KB951066)
- Cumulative Security Update for Internet Explorer 7 for Windows XP (KB953838)
- Update for Windows XP (KB952287)
- Update for Windows XP (KB951072)
- Security Update for Windows XP (KB950974)
- Cumulative Security Update for ActiveX Killbits for Windows XP (KB953839)
- Security Update for Windows XP (KB946648)
- Security Update for Windows XP (KB952954)

I tried setting domain in Local Internat Sites but that did not either help.

Thanks for all your help.
 
The problem occurs even without using any code. In the database window if I
double click an in-line function it does not work.
 
No problem here but I don't have SP3 for Office 2003 installed on my machine
and it's a WinXP SP3, not SP2.

I suggest that either you replace your in-line functions with stored
procedures or that you try to install SP3 for Windows XP or that you open a
support call with Microsoft.

If you don't have the latest version of service pack for Office 2003 (SP3),
you should try with it, too.
 
Back
Top