Run .accde with Outlook

[KeythStone]

Hello to All,

I am trying to set Outlook to run an application once an email comes in and so far the issue is Outlook can't recognize my executable files. I tried saving my access database to .accde but to no avail. Is there something else I need to do?

Also, reading online I noticed some chatter about SP1 needing to be installed but I don't believe that's my issue. Thanks for your consideration,
KeythStone

 

[james_lankford]

maybe you could pass it the path to access exe and pass the mdb as a parameter

"C:\Program Files (x86)\Microsoft Office\OFFICE11\msaccess.exe" "C:\Users\jamesl\Documents\db1.mdb"

 

[KeythStone]

So an update,

I'm able to open my .accde file with outlook no problem. The issue now is that I cannot run my macros which were coded in the original .accdb. So is this the problem I keep hearing online about compiled files dropping the code? And do I need to re-write the code/make new macros in the .accde version?

Basically, once an email comes in I can AutoExec to begin the macro running process but I receive a message, "the expression entered has a function name that MS access can't find."

Any thoughts?

I believe this thread has just become an access topic.

KeythStone

 

[Derek Brown]

You must be using either 2007 or 2010 (you made reference to .accdb). Are you using XP or Windows 7?
Can you explain exactly what the macro will be doing?

 

[boblarson]

So an update,

I'm able to open my .accde file with outlook no problem. The issue now is that I cannot run my macros which were coded in the original .accdb. So is this the problem I keep hearing online about compiled files dropping the code? And do I need to re-write the code/make new macros in the .accde version?

Basically, once an email comes in I can AutoExec to begin the macro running process but I receive a message, "the expression entered has a function name that MS access can't find."

Any thoughts?

I believe this thread has just become an access topic.

KeythStone

Make sure that the procedure is a FUNCTION and not a SUB.

 

[KeythStone]

Thanks,

To Derek: Using Windows XP, Access 2007.
The Macro will run a series of modules (converted macros) which publish reports driven by a query. I had to convert macros to VBA in order to 'date stamp' the output to file name. My next task is to have an email kick off the whole process. I converted my accdb to accde in order to have an executable file to work with. Outlook will open the file but when I AutoExec to run a macro it comes back with the aforementioned message...no function found.

Bob: I looked at the original .accdb version and it says procedures are as function.

Thanks again,
KeythStone

 

[Derek Brown]

Can you post the Outlook code that opens/runs to Access database, please?

 

[KeythStone]

To All,

Thanks. Everything is working fine. So far...