| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel data connection to Access
We have multiple users with a back end database. All users have XP2003
except one just started using Office 2007. 2007 user made a worksheet with query connections to the back end database. When he is in this spreadsheet it locks the database. I have never had any problem having queries open with 2003 locking the database. Any answers? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data connection to Access
This is a shot in the dark, but does the Excel user have the same read/write
privileges to the directory the back-end is located in. If not, your Excel user might have a lock file locally on his drive, preventing other users from getting to the database. -- Kevin Backmann "Sharon" wrote: We have multiple users with a back end database. All users have XP2003 except one just started using Office 2007. 2007 user made a worksheet with query connections to the back end database. When he is in this spreadsheet it locks the database. I have never had any problem having queries open with 2003 locking the database. Any answers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
| Data Connection Security in Excel 2007 | Setting up and Configuration of Excel | |||
| internet connection via excel macro at timed intervels & save data to excel file. | Excel Worksheet Functions | |||
| Connection to external data sources in Excel | Excel Discussion (Misc queries) | |||
| Can Excel and access update each other like a two way connection | Excel Discussion (Misc queries) | |||
Hybrid Mode
