how stable is link to excel from access?

[CHAOSinACT]

i've got an Access Database that links to to excel spreadsheets. its a project management system. it seemed logical to load certain excel data live everytime a project is loaded so any changes in spreadsheet update in database automatically. now, this is all working fine! well.... 9 times out of 10. but seems to lock up opening excel everynow and then. i close the excel app in taskmanager and then it works next time. eventually there will be multiple users doing this over networks, maybe i should give up on live loading.... any input on this?

 

[namliam]

Live loading is a nightmare, cause anytime any user is in the excel file it is locked from reading by Access.

 

[CHAOSinACT]

not sure thats a prob but wah! really wanted to load live. guess i'm looking over it....

 

[namliam]

excel will just simply lock the file, unless you make it read only, but that defeats the point.

 

[ghudson]

Just use the transferspreadsheet method to import the file from Excel into Access whenever you want to update the data. You cannot import an Excel file if it is opened but you can easily trap for that error.