469,347 Members | 19,297 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

Bizzarre problem involving Excel-Access :x HELP


I've got an access database on a server, and in a client PC I've got an excel spreadsheet... I run a query from the client PC involving some maths to develop different price lists from values stored in the DB on the server...

Problem #1: I dont want the client PC to be able to control the queries, is there a way to store the access query on the server PC and have the excel worksheet just access it on the server each time?

Problem #2: The server is shut down sometimes, but the client pc may run at times when the server is down and will still need to print reports and invoices, thats why I load it in excel and it keeps the data there even when I close it... When the worksheet loads I run a macro to 'update' all data from the Server DB... If the server is down then it says connecting to db... for a while and then comes up with an error and prompts to look for another DB...
Is there any way I can just cancel and do not update if the server is down? (The way I'm updating is that I just ran a 'get external data' query the first time, and I just use the 'Update' command when I need new info, and I recorded the action in a macro to use every startup.

Thanks a lot in advance -
Sep 20 '06 #1
1 1319
1,418 Expert 1GB

When I create a query in Excel it gives me the right to choose where to save the query...

Maybe in this moment you can assign the server...

And for the second pb I'ven't idea!

Sep 23 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Matthew Wieder | last post: by
4 posts views Thread by IMS.Rushikesh | last post: by
22 posts views Thread by Howard Kaikow | last post: by
1 post views Thread by Steven | last post: by
18 posts views Thread by lgbjr | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.