Rabu, 07 September 2016

Re: [MS_AccessPros] Start Access application remotely

 

Valentino-


Your original message did post, but it's not clear what you want to do.  What do you mean by:

I would like to have the possibility for the user to interact with his own local  computer fulfilling some data before to run the procedure .

??

Where does the data that you want to "fulfill" reside?  Is it in the database that you call with a batch procedure?  If so, I would think you could build another database for the user that has linked tables to the database you call.  You could let the user update information via forms on the linked tables, then invoke the other database's procedure - perhaps by calling Windows to run the batch file.

Hope that helps...

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Sep 7, 2016, at 7:01 AM, valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



I see that my first message do not reach the Group, I try again 




Good morning to all, 


I have an VBA procedure inside an access database  that take quite long time to be performed that update some articles information  in our main database using ODBC driver.


I can run this procedure using a batch file that start every morning.


The tool is working in good way but I would like to have the possibility for the user to interact with his own local  computer fulfilling some data before to run the procedure .

I do not want to give remote access to this computer as well as I do not want that the operator run this procedure locally engaging his computer for long time.

The idea is to create client database connected with "Server" with some table to fulfil data 

The question are:


1) How can I run access tool using a string locally that start access remotely;

2) In order to advice the operator that the procedure ended in correct way I was thinking that at the end, the procedure fulfil a connected "client"  local table connected with a mask that the operator can see in his client 


For point (1) I need a suggestion,  

looking on internet I see that is possible with powershell or with a software dedicated PSExcec 

I did some test with no success somebody can help me or giving some good website where looking?


The other question (2)  is how advice the operator that procedure completed, but I think that this is possible with a mask with inside the connected table that is refreshing on regular base



Thank you 



Valentino 






__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar