Excel pivot pointing to access

W

we7dude

There is an access database that I update daily, and there is a excel
pivot pointing to it. as soon as someone have the excel open, I become
a read only in access, which is no letting me to update. any idea how
to do like kick people off the access file (telling people physically
is not possible). thanks a bunch..
 
E

Ed Robichaud

Opening the *.LDB file in an editor (like Note Pad) will let you see who's
logged in. You could email or IM them. FMS (and others) have some
management tools that will handle identifying and notifying users.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
how to link access data to excel's pivot table 5
Changing Links to access databases 1
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Excel How do I create a pivot table in excel 2003? 3
?? Use Excel or Access 3
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Access pivot table in Access 0

Top