 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2006Excel linked table
Hello! Is it possible to have a linked table to an Excel spreadsheet and allow many user to read ONLY the data. I know that an Excel spreadsheet cannot be a multi-user document, but what I want is that many users get connected to the Access database and view the data. I don't need to have in any case to modify or edit the data of the spreadsheet. if I link Access to an Excel spreadsheet and try to open the linked table from more than one computer, I get the message that stats that the table is already opened exclusively by another user.. One of the solution is to import the spreadsheet into access and keep working only with Access, but I can't do that everyday since it will slow down the loading of the Access application. Thanks for any suggestion or advice. Hi Warrio, Do you absolutely want to use Access. With the proprieties set to Read Only, your Excel spreadsheet could be viewed by many users. Have a good day, Céline > Hello! > [quoted text clipped - 14 lines] > > Thanks for any suggestion or advice. Hi Céline!! Thanks for your response, but all my application is made and works in Access.. and what Access do when you link it to an external spreadsheet, it tries to open it exclusively! and this even if the attribut of the file is set to Read only. so is there a way to make access get connected more than once to a linked spredsheet?? Thanks for any adivice > Hi Warrio, > Do you absolutely want to use Access. [quoted text clipped - 21 lines] >> >> Thanks for any suggestion or advice. Hi Warrio, And if you activate the multi-user option in this external spreadsheet would it work ? Open the spreadsheet, menu Tools, Share spreadsheet (or something like it. I work in French ;-) and in French the command is "Partager le classeur") Céline > Hi Céline!! > Thanks for your response, but all my application is made and works in [quoted text clipped - 33 lines] >>> >>> Thanks for any suggestion or advice. Salut Céline! J'ai déjà essayé cette commande également et ca ne marche pas vraiment! Merci quand même! et bonne journée à toi. > Hi Warrio, > And if you activate the multi-user option in this external spreadsheet [quoted text clipped - 40 lines] >>>> >>>> Thanks for any suggestion or advice. Bonjour Warrio, Vous devez importer les données dans Access :-( Voir ci-dessous la réponse d'un MVP à ce sujet. Céline ----------------------------------------------------------------------------- Question : Hi. I have a spreadsheet which is linked as a table. My problem is that the Jet engine gives me an error in my query if more than one person tries to open it. It says that is "opened exclusively." Is there a way around this? Réponse 18 mars 2005 : Not on a spreadsheet. Excel allows only 1 person to edit a file at a time. The only work around is to import the data into Access. Arvin Meyer, MCP, MVP Microsoft Access Free Access Downloads http://www.datastrat.com http://www.mvps.org/access Lien : http://groups.google.ca/group/microsoft.public.access/browse_frm/thread/504cb884 a2693448/012797eb6f791cd1?lnk=st&q=access+linked+excel+table+opened+exclusively& rnum=2&hl=fr#012797eb6f791cd1 > Salut Céline! > J'ai déjà essayé cette commande également et ca ne marche pas vraiment! [quoted text clipped - 47 lines] >>>>> >>>>> Thanks for any suggestion or advice. Merci pour tout!! > Bonjour Warrio, > Vous devez importer les données dans Access :-( [quoted text clipped - 70 lines] >>>>>> >>>>>> Thanks for any suggestion or advice. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.