Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Worksheet
I am developing a Excel-solution which consists of 1 shared database on a
server and 8 clients connected to the server. Each client has its own sheet in the shared database which is loaded on startup of the clients, and every modification in the client is saved in the database with the ".save" methode of the shared database. Now I have the problem, that sometimes the shared database is locked so that I cannot save my changes and I don't know why this happens. I am looking forward for some help. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Worksheet
Hi
The Excel application is designed as desktop application which is mainly talking with End User. Imaging there are more than one user is trying to save a change to the same workbook which may cause problem. For your scenario, I think you need a database application, if you have office software, you may try the Access which is designed as a small database. Or you may try the MSDE version which is free. Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A http://www.microsoft.com/downloads/d...4d1-a0bc-479f- bafa-e4b278eb9147&DisplayLang=en Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Shared Worksheet | Excel Discussion (Misc queries) | |||
Protecting a shared worksheet | Excel Worksheet Functions | |||
users on shared worksheet | Excel Worksheet Functions | |||
Shared Worksheet | Excel Discussion (Misc queries) | |||
Shared worksheet | Excel Worksheet Functions |