pmcartney3
New Member
My question is not a straightforward one but in simple terms I'm looking for suggestions on what kind of database to use with excel that can be easily accessed offline by remote users.I am one of around a dozen field engineers that use Excel on a daily basis for recording and reporting on a substantial amount of information. The end result I'm after is all engineers having access to data recorded by every other engineer. Recalling information is essential but not necessarily full on queries. The problem is we are all field based so not permanantly connected to a server but do have VPN access to a central server so synchronisation will be possible periodically. A few things to take into account:[*]I work for a huge company with well established IT infrastructure. Getting server changes implemented will be difficult but may be possible if absolutely essential.[*]None of the users are IT professionals so it needs to be simple to save/recall info.[*]It will be administered by me. I'm an instrument engineer and not a software supremo. I'm no expert but I dare say I'm reasonably competent with VBA and just starting to get to grips with XML and starting to learn about SQL.[*]It must be available offline, synchronisation will be possible and conflict resolution can be as simple as newest data wins.[*]Excel is essential, quite a lot of complex calculations are carried out so this is not a case of poor choice data entry platform.I'm half expecting answers shouting mySQL but as of now I'm certainly not confident using it and the server side of things is a little daunting. As I understand it Excel is quite good with XMl and this could work as the data could be divided by customer (40-50 different files?).I'm a little stuck and would appreciate some knowledgeable opinion. I'm happy to clarify any points, it's a difficult situation to explain. Thanks.