Hi,
I want to retrieve data from Access 2007 to Microsoft Excel 2007 with shared data access. I'll pick regularly data from Access 2007 to Excel 2007 with the "Get external data from Access." It also works fine, but it is pretty rusty, if there are multiple users in Access database, I can not be allowed or if I download data in Excel file so that other users are not allowed to go into the database. The database is designed for multiple users. It seems as if Excel to retrieve data via an undivided data connection. The data retrieved from Access is a question. Is there anyone who can help?
Bookmarks