Skip to Content
author's profile photo Former Member
Former Member

UDF cannot find in MS access 2007 with MS 2008 server

Hi,

Customer before use 2000 server and 2004 SAP Business one. This year they will upgrade system to 2008 server and 8.81 SAP Business One. They will use MS access to access Business One data and do some printing job. However, after upgrade we find the MS access program cannot find UDF of B1 database. It can only retrieve normal table field but missing UDF. Anyone can help how to retrieve those UDF?

Anna

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 06:12 AM

    Hi,

    I try to re-add table into MS Access but still missing UDF. However, i find that there are some tables can get UDF such as INV1 those detail files can show UDF properly but OINV also cannot get UDF. DOn't know what happen and how to check? Why type will affect? Do i need to change the UDF's type? I try to connect B1 database to EXCEL and export data to EXCEL and all UDF can export properly. Just cannot show in Access. Any idea? Please help.

    Anna

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Anna,

      What connection method are you using to connect from Access to SQL? Are you using the SQL 2008 Native Client? If not then I recommend you try this connection method.

      Since SBO 2007A, alphanumeric UDFs will automatically be created as the SQL datatype nvarchar(max). This datatype was not available in SQL 2000 so this may explain why UDFs that were created when your client was running their old system are still viewable in Access but newer UDFs don't appear. Using the SQL 2008 Native Client should allow you to read these newer UDFs.

      Kind Regards,

      Owen

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2011 at 02:51 PM

    Hi Anna,

    Check what is the type of UDF. It may be changed.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 01:44 AM

    Hi,

    Thanks and it works.

    Anna

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.