vba compile error function or interface marked as restricted VBA Error when interfacing from Access to .NET com dll

Question

I have a com dll created in VB.NET that has been working for a number of years. The dll takes information from MS Access and creates orders on eBay using their Soap api. All of a sudden I started getting the error message "vba compile error function or interface marked as restricted, or the function uses an automation type not supported in Visual Basic" when I compile the Access application. The error is on a line where a property of type decimal in the dll is updated with data of type decimal from an DAO recordset. This part of the code has been stable for quite a while so I am at a loss as to why all of a sudden this error starts. Any suggestions would be appreciated.

did your COM interface (VB.NET) changed? do you still see the called method? — Jeandey Boris
– Jeandey Boris, Commented Jan 25, 2017 at 13:12

DougM · Accepted Answer · 2017-01-25 18:19:45Z

1

For future reference. It appears that MS Access type decimal is not equivalent to VB.NET type decimal. MS Access sees VB.NET double as equivalent to its type decimal. Once I converted my property to a double data type the compile error went away.

answered Jan 25, 2017 at 18:19

DougM

1391 gold badge4 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

vba compile error function or interface marked as restricted VBA Error when interfacing from Access to .NET com dll

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related