Run Query from outside of Access?

[The_Vincester]

Is it possible to run a query that's inside an Access database from another program? Possibly excel.

I continue to run into walls with the fact that I can't get my company to buy licenses for Access to put on PCs. I'm determined to work around these issues, but there are obvious limitations.

Right now I got Excel sheets linked to a database where it pulls information of a main database that I'll update. They hit a macro button and it fills their sheet with the information I've provided in the database. At the end of each shift, I pull the information back into the database with the updated numbers for the day with a Union Query, then collect all the data into a new table.

The "old" way was cutting and pasting data from 60 Excel sheets every day which took 2 1/2 hours. I accomplish it now in about 10 seconds. Enough patting on the back.

The problem is that I need to delegate some of this out because I simply don't work all three shifts that we have and I want someone to "pull" the data after each shift. Of course, the people that I want to do this do not have Access.

How can I enable them to run these queries? Is it even possible?

Am I missing another way to do things?

Thanks in advance...

 

[twychopen22]

Vincester,
I am not sure if this is what you are looking for but I am running into the same problem. You can call have the query run automatically with the windows scheduler. The other dudes on the shift don't even have to mess with it. You could schedule the query to run at the beginning of each of their shifts automatically. I hope this is what you are looking for. Take a look.
http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/34d0bd7b76a718e9/e4badd56a45f047a?lnk=st&q=&rnum=4&hl=en#e4badd56a45f047a

Oh and if the people do not have access, maybe (I am not sure if this works its an idea I had) you could put access on a server and have it open all the time??? Others should know that one.

 

[TanisAgain]

You still need a licence for each machine!

 

[twychopen22]

Wow, thats good to know! I didn't know that. All the programs I have made have been for single users who had access, teachers, or companies that all had access already. Maybe u will have to find a different way...sorry.

 

[DanG]

What about "Linking"?
I think when you say they are linked you mean like a data query?
But true linking is a real time connection between Access and Excel.
Any changes made in Excel are immediately made in Access and visa versa.
Just a thought.

And twychopen22 is correct scheduler will do the trick, you just have scheduler open Access then a macro (or vba procedure) run the query and exit Access. The easiest way to run the macro for the query is to make your macro and name it "autoexec" that way the macro will run on startup

 

[The_Vincester]

I have considered the scheduler, but anything that could go wrong in that situation probably would go wrong.

If it turns out to be my only choice, then so be it, but I'd like to find a more "elegant" solution.

Are there any ways to execute commands through Data Access Pages?

 

[Pauldohert]

Have you looked at access runtime -then each PC dosen't need full access license.

 

[The_Vincester]

I have looked at that, but don't have a developer edition.

It's too bad because all I really need is a one button form that can run the query!!!

 

[Pauldohert]

Ho hum - the company won't shell out for that either?

 

[The_Vincester]

I was lucky just to get a license for MS Access myself!

 

[twychopen22]

Yeah, usually the companies don't like shelling out money for that stuff, the ydon't understand i guess. P.S. I LOVE the comment about hezbollah!!! (I know that this is not that forum but I had to say it)