|
| 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
January 14th, 2010, 05:26 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
January 15th, 2010, 04:02 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
