Export Macro giving 2095 error

[discotom]

Hi

I have a specialised membership database that my brother created for me years ago. There are three files - the main.mdb file, its .mde file and another .mdb file that executes macro code to interrogate the first main.mdb file and export the data into a .csv file.

It was all working fine until my HDD drive died. I then restored the files but upgraded my office to 2013. I now get a 2095 error -

error code 2950
Your network access was interrupted. To continue, close the database, and then open it again.

I did some research and this seemed to do with security permissions...I therefore added the file locations to be trusted locations, but the error still occurs.

Any ideas???

Thanks

Tom

 

[Trevor G]

Welcome to the Forum Tom,

Have you adjust the Macro Settings as well to Enable all.

Have you also considered converting the Macro to VBA so you get the Error Handling and if you do and it still persists then you can post the code and we can look to help from there.

 

[boblarson]

Welcome to the Forum Tom,

Have you adjust the Macro Settings as well to Enable all.

Have you also considered converting the Macro to VBA so you get the Error Handling and if you do and it still persists then you can post the code and we can look to help from there.

To supplement what Trevor wrote, just putting it in a Trusted Location doesn't necessarily work. You need to open the Trust Center and go to MACRO SETTINGS as he wrote and make sure that ENABLE ALL is selected instead of DISABLE, DISABLE WITH NOTIFICATION, OR DISABLE WITH NO NOTIFICATION.