If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Link Issue
I link to a couple of Excel sheets, then query them to get the information
out of them that I want, then append any new data to a table. I then run a form with that data. My problem is, when one user is on that form them other users can't open it but get a "already in use" message. Is there a work around to allow all users on the lan to open that? They don't have to edit the data, just view it. I am using 2003, sp3, split db. Thanks! -- Milton Purdy ACCESS State of Arkansas |
#2
|
|||
|
|||
Excel Link Issue
On Thu, 14 Jan 2010 09:26:01 -0800, golfinray
wrote: One of the VERY few options is not to link, but to import. -Tom. Microsoft Access MVP I link to a couple of Excel sheets, then query them to get the information out of them that I want, then append any new data to a table. I then run a form with that data. My problem is, when one user is on that form them other users can't open it but get a "already in use" message. Is there a work around to allow all users on the lan to open that? They don't have to edit the data, just view it. I am using 2003, sp3, split db. Thanks! |
Thread Tools | |
Display Modes | |
|
|