Access 2003 adp - function not working since last windows update

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.
 
S

Sylvain Lafontaine

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.
 
K

KARL DEWEY

You did not say what version of Windows you have. They added security
features.
You might search on Trusted Sites.
 
A

Abe Munk

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.
 
A

Abe Munk

The problem occurs even without using any code. In the database window if I
double click an in-line function it does not work.
 
S

Sylvain Lafontaine

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.
 
Top