Hi there
Indeed you are correct in that one of the project files is a
Microsoft Access Database file. And you are correct in that this
file is the reason we advise folks against working with projects
stored on a network. Not only do you see slow performance, but you
also see frequently corrupted projects causing all sorts of
nightmares, headaches and other unwanted behavior.
No, there is no way to use SQL server nor am I aware of any
plans on implementing it.
So the question here is why are the users insistent on
storing projects on the server? Or is that the IT perspective? That
all projects should be stored on the server so you may back them
up? If so, note that we typically recommend users work locally and
periodically copy the projects to the server for backup. I even go
a step further and recommend also burning to CD-ROM as it's always
been my experience that restoring from your own backup is
infinitely more efficient than contacting IT and trying to advise
what needs restoring.
Cheers... Rick