ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shared Worksheet (https://www.excelbanter.com/excel-programming/352174-shared-worksheet.html)

HPK

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!




Peter Huang [MSFT]

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.



All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com