UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Linking to an Excel Spreadsheet    
 
   
rruferuoff
post Apr 4 2006, 04:39 PM
Post #1

UtterAccess Addict
Posts: 112
From: Florida
Hello,

I linked my database to an excel spreadsheet stored on my company's server. I can run queries, reports, etc., but my problem is that whenever I have the database open, other users cannot access the Spreadsheet.

Is there any way to get around this. I am a newbie, so, please explain in lay terms...

Thanks.
Stephen
Go to the top of the page
 
+
Peter46
post Apr 4 2006, 05:38 PM
Post #2

UtterAccess VIP
Posts: 7,440
From: Oadby Leics, UK
No.(Unless they open it first)
Go to the top of the page
 
+
rruferuoff
post Apr 4 2006, 06:00 PM
Post #3

UtterAccess Addict
Posts: 112
From: Florida
Would it be better to automate an import?
Go to the top of the page
 
+
HiTechCoach
post Apr 4 2006, 08:14 PM
Post #4

UtterAccess VIP
Posts: 18,427
From: Oklahoma City, Oklahoma
You could also use VBA to copy the spreadsheet and then link to the copy. Then you can just copy the spreadsheet as needed.
Go to the top of the page
 
+
rruferuoff
post Apr 6 2006, 10:16 PM
Post #5

UtterAccess Addict
Posts: 112
From: Florida
So basically do a quick copy of the spreadsheet prior to link and have it refresh every so often or have users refresh???
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 11:46 AM