How to Show User Define Function?

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

Guest

Hi,
I have created a couple of UDFs in the SQL Server. However when I create
an .adp MS Access (2000 version) file and when I look at the View and Stored
Procedure, I just could not find one of the UDFs that I created...

Is there any way to have them show on the .adp file? Since I could not find
them in any objects, I could not use them as a record source for any forms..
Thanks

Ed
 
It's a limitation of Access 2000; if I remember correctly. In your case, an
easy solution would be to set the RecordSource to something like:

Select * From MyUDF( ... parameters list ...)

You must rebuild this string every time the value of one of the parameters
changes but it's not a big deal.

A better idea would be to upgrade to A2003 as they are numerous bugs with
Adp2000. (There are still many bugs with Adp2003 but a lot less.)
 
Thanks for the answer...

I do have another qestion...

I am using MS Access 2003 when I am at work. However, I found out everytime
when I created a .adp file using 2003, there is a text showing on the top of
the application "Access 2000 version" when I looked at the database windows
which is the same as hitting F 11, is it supposed to be correct or I am
missing something?

Thanks again.

Ed
 
You are correct: A2003 is compatible with both format A2000 and A2002/2003
and it defaults to the A2000 format.

You can change that in the Advanced tab options or convert between formats
by using the Convert Project function in the Database Utilities sub-menu.

However, the fact that you can save under the A2000 format doesn't mean that
the full functionality of the A2003 version will be available under Access
2000 or 2002; as functions particular to the A2003 or the A2002 versions
won't work under a previous version.
 
i would reccomend using something newer than access 2000

some drunk PM at Microsoft made that decision that 'oh, it's allright
SQL 2000 and Access 2000 dont need to play nice together'

that friggin idiot should be fired

i mean- - the products came out in the same year; they should work
optimally with other year 2000 products
 
Back
Top