deployment - Deploying Access as a client-server application -


I am using Access as a front end (2003 format) with a SQL Server 2008 backend. Each user already has Access 2003 or 2007 installed. I'm curious as the best deployment configuration to use for efficiency and maintenance.

Do I have to do it on the server? Should add MDB file and keep it shortcut on each machine? (Only two to three users will be one at a time.) Or copy the file on each machine? And if I am using a third-party ActiveX, then it needs to be installed on each machine, even though the .MDB is on the server (I believe this, but I am currently checking), or just the server On?

Access files may be problematic when multiple users open at the same time. I have a copy of the file on each user's machine.

And yes, each machine needs to establish an active exchange - even if MDB is on the server.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -