Experts,
Here's my problem. We use an Excel spreadsheet as a form for creating new part numbers at our Engineering facilities. The form, when opened uses 22 Access Queries to get the latest data from a master Access database for the various pull downs in the form. This works great and keeps us from having to constantly issue a new version of the form, each time we add or remove data from the pull-downs.
Now that we have expanded our Engineering facilities from San Diego, to Montreal and the Philippines, the users there are having a hard time getting the form to access the database here on our server in San Diego. It works, it's just painfully slow. So here's my question....
Is it possible to edit the Access query so that it is different based on the users log in location? I can detect the server they log into, and if I could then change the query to access the database on THEIR server, then everyone would have a quick connection and all we would have to do is use a script to update the two external databases to the changes made in the master one, on a nightly basis.
Everyone following me here?
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar