Excel Link Issue

  • Thread starter Thread starter golfinray
  • Start date Start date
G

golfinray

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!
 
On Thu, 14 Jan 2010 09:26:01 -0800, golfinray

One of the VERY few options is not to link, but to import.

-Tom.
Microsoft Access MVP
 
Back
Top