UDF cannot find in MS access 2007 with MS 2008 server

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member201110 · Accepted solution]

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

[Former Member]

Hi,

Thanks and it works.

Anna

[Former Member]

Hi Anna,

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

Thanks,

Gordon