I have an Access database that we use to export files in the correct format, and this database is on a server (3-4 of us run these exports, so it know it is not the database).
I just got someone else’s pc after they left as it had other software on it that I need to continue some of his roles.
The only problem being that when I export now it fails with the following error:-Error 3085 – ‘Undefined function ‘mid’ in expression.’ occurred in…..I have created my own database and made a query to test the mid functionality and it work.
I have looked at the Reference Library and have nothing listed as Missing:I have the following ticked:- Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
I tried unchecking the all (only the bottom 3 would) saving it closing down then rechecking them, this did not work.
I have also had IT remove Microsoft Office 2003 from my pc, they reinstalled it without Access and installed a standalone version of Access 2003, to see if that would make a difference - it did not!
Not sure what to try now?
DetailsC –
Windows XP Professional SP3Access 2003 (11.8166.8221) SP3
Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) .NET Framework Version 2.0.50727 SP1
I just got someone else’s pc after they left as it had other software on it that I need to continue some of his roles.
The only problem being that when I export now it fails with the following error:-Error 3085 – ‘Undefined function ‘mid’ in expression.’ occurred in…..I have created my own database and made a query to test the mid functionality and it work.
I have looked at the Reference Library and have nothing listed as Missing:I have the following ticked:- Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
I tried unchecking the all (only the bottom 3 would) saving it closing down then rechecking them, this did not work.
I have also had IT remove Microsoft Office 2003 from my pc, they reinstalled it without Access and installed a standalone version of Access 2003, to see if that would make a difference - it did not!
Not sure what to try now?
DetailsC –
Windows XP Professional SP3Access 2003 (11.8166.8221) SP3
Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) .NET Framework Version 2.0.50727 SP1