Export to Excel Locks Back End Database

J

J Brzezinski

I have Access app split between front and back end
databases with front end on user machines and a common
back end on a network drive. When a front end user is
exporting a datasheet to Excel, the entire back end data
base seems to be locked so that additional users cannot
open their front ends and connect to the back end.

Is there a way around this problem?

joe
 
Top