• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data conflict in shared workbook. How to avoid?

K

kulasart

New Member
Dear All,


I'm facing with huge dilemma right now. I have to store large amount of data that have to be shared.

Each user that will have access to these data must have ability to add/edit/delete every single record. Based on the data users need to be able to pull some data under relevant conditions (something like SQL SELECT statement).

I can handle myself with everything described above however there is a one issue, which I have no idea how to solve it.


When I share workbook over the local network, I can't prevent users from editing row that has been removed few second ago by another user.

Same issue occurring when 2 or more users want to add new row with data and save file (excel is asking which data should be save and it doesn't matter what user chose - only one row will be saved an the other will be ommited).


I can't use MS Access because my company don't want to spend extra money on it so I have to find out solution using Excel only.


Do you know any "magic tricks" that could help me?


Ps. I'm using MS Excel 2007.
 
Lukas


Firstly, Welcome to the Chandoo.org Forums


What about a free DB like mySQL?

http://www.mysql.com/
 
Hui,


Open Source SQL server was my first thought.

Unfortunately IT Department have some strange restrictions and they don't allow to use any new software...


I was thinking about using *.mdb file as a database (don't need Access to create it) and excel (with forms) as its interface, but till now i can't find information whether it could solve my problem (will support SQL transactions) or not.
 
You must log in or register to reply here.
Back
Top