Recent content by jps1320

I have created a Access 2007 application that has a feature that will allow the user to email a report as a PDF attachment. (code below) When I run the application on a computer with Access 2007 and Outlook 2007 installed it works perfectly. However, I have a couple users that have Outlook...

Didn't try the .bat file, but looks like it would work fine too. I'll tinker with it this weekend and post back so future seekers will get a full report. JPS

Well...even though I have read that you can use Vista Task Scheduler to open Access and an Access Database, which in turn runs AutoExec macro upon opening...I couldn't get it to work. The closest I got was to get the database to open, but not run AutoExec. I even tried to append the following...

Thanks, Pat. I've seen info about making a .bat file and using Task Scheduler to open the .bat file, which launches the app and opens the file. Most posts that I have seen say it can be done either way, especially since I am trying to do this locally with full admin privileges. Maybe I'll...

well...I think the idea of starting Access and then opening the file is the correct way to use the task scheduler, but still can't get it to work. Here's what the task action is set to: Program/Script: "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" Additional Arguments...

I am trying to use Vista's Task Scheduler to open an Access 2007 (.accdb) database on a daily schedule. Once open, the database has an AutoExec macro that will launch...run some code...then the last action in the macro is "Quit" to close Access. This is the first time I have ever used Task...

OK...I have found a solution. I derived my solution from a post on MyMSAccessBlog by user "Stephen". Good post with links to different variations on my issue (ex.: managing multiple back-end DBs like Live DB and Test DB). I am a new user to this forum so this URL may get blocked, but I'll...

How to split a database, create install package and move backend db I have built a multi-user Access 2007 database application. I split the DB and then use the package wizard to create an install package for the users to install the front end on their computers. I have created a...