By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Bizzarre problem involving Excel-Access :x HELP

miffe
P: 7
Greetings,

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 -
miffe
Sep 20 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

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.