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
Post a Comment