Send object even if DB not open

[lcook1974]

Is it possible to have a DB send a query result to and individual even if the DB isn't open? (like every day send results of query that are 15 days old and should have been completed?)

How would you go about doing this?

Larry

 

[boblarson]

No, the database has to be open. You could set up a Windows Scheduler to open the database and then an AutoExec macro to kick off VBA code to do everything and then close itself.

 

[lcook1974]

Would the windows scheduler work if the DB is on a Shared Drive?

( I work for a hospital and that is where the DB resides)

Larry

 

[boblarson]

Would the windows scheduler work if the DB is on a Shared Drive?

( I work for a hospital and that is where the DB resides)

Larry

The windows scheduler SHOULD be able to open a database as if you did. You can provide a shortcut on your machine and have the scheduler run it.

Now, that being said, your computer would need to be LOCKED but not logged off. If you log off it won't work.

Also, this database on the shared drive - do other people use it? If so, is it split (frontend/backend) and with a copy of the frontend on EACH user's machine? It really needs to be that way if not.

 

[lcook1974]

yes it is split...I have several database. This one in particular is linked to an Eye and Tissue recovery Activities DB core tables, and only the front end is used by a few people.

The I.S. department here has requested that most all PC's be "restarted" when you leave so they can push updates at night when everyone is gone.

Thanks Bob!!! I'll be back in touch when they want to go live with this. I have a feeling on how to do the code but the timers always get me.

Larry

 

[lcook1974]

Just re-read this...so I would have to lock my PC every night instead of "restarting it"...correct?

 

[boblarson]

Just re-read this...so I would have to lock my PC every night instead of "restarting it"...correct?

Correct, if you want the scheduler to be able to run the database.

 

[lcook1974]

Great Thanks Bob...you are always a great help and I enjoy reading your posts on other threads...

off this subject:
Do you know why I always have to log in to post a reply? it gets annoying when I have to do it most all my replies.

Larry

 

[boblarson]

off this subject:
Do you know why I always have to log in to post a reply? it gets annoying when I have to do it most all my replies.

It would seem that you may not have cookies set properly to retain them, or when you log in do you check the ALWAYS REMEMBER ME checkbox too?

 

[lcook1974]

I did check the remember box this time...as far as cookies go this is work PC so I think I may be restricted.

I'll check it out...No worries!!!

Thank you again!!!
Have a good day!

Larry