Acc2003 Project Stopped Running User Defined Functions with Parame

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

System: Windows XP / Office 2003 / SQL Server 2000
All updates installed (windows / office / sql)

This is a new behavior detected today. The same solution worked fine since
last operation.

Access 2003 database, connected to a remote SQL Server;
All tables are accessed OK
All views are accessed OK
All functions without parameters are accessed OK
All functions with parameters are NOT accessed:
- the system does not display the parameter input value
- the system shows a blank window that quickly disappears

Trying to export the query to excel (using the “analyze with†button):
- the system displays a message stating that Microsoft access cannot start
the OLE server

Notes:
This behavior is NOT noted on genuine access databases
This behavior is ALSO noted on projects connected to Local SQL databases

Done:
- Compression / repairing of the project without success.
- Reinstallation of MS OFFICE with no success
- tried to install MS JET SP8 but the system states that a newer version is
installed and aborts
- tried to install MDAC 2.8 but the system fails by stating that MDAC is a
part of the current operating system, aborting.


Any Ideas?
 
Are talking the User Defined Function (UDF) in SQL Server2K, or function you
wrote in Access VBA?

If it is former, all you have tried to fix the problem is relevant, 'cause
UDF runs inside SQL Server. If you have Enterprise Manager (with full SQL
Server, not MSDE), you could try the UDF there without Access project.

If it is latter, well, I can hardly say anything without seeing the code.
 
Thanks for your reply

It's a MS SQL User Defined Function located at a remote server.

The User Defined Function works in sql Query Analiser.

But most importantly:
- the same project in another PC ( I just copied it) WORKS.

So I have certainly some problem with ADO / MDAC?
 
I've got the exact same problem, where by only functions with
parameters cannot
be run by certain users. Although every users has the same rights it
surprises me that they cannot run the functions(UDF). I have given
right of data writer and reader and still no luck. Any ideas.
 
Rui,

when you write:

What do you mean by accessed?
How are you trying to run the UDF?
Are you trying just to run it from the database window?
Where do you expect the parameters to come from? Are you expecting access
to prompt you for them? It should if you run from database window. It does
for me.
What kind of UDF is it, 'table valued' or 'scalar valued'?

When you writeHave you also tried to 'decompile' your project? If not, do it (on a copy)
as follows:

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" /decompile
"C:\path\to\your\project.adp"

--Malcolm
 
Back
Top