Hi Guys, Looks like great packages and great pricing - hope it is what I am after! I am an Access developer in the initial stages of developing "long-range" or internet accessible apps referencing a central DB. Whilst I understand that ASP.NET is the preferred approach I only have a small group of users and would prefer to stick with an Access front-end. I understand that a local Access system can be set up to point to an SQL Server database with a fixed IP address. My database is quite small, as is the throughput and I am wondering if your MAX membership would cover such a setup ? Regards, Joe
Not sure what you mean by... I understand that a local Access system can be set up to point to an SQL Server database with a fixed IP address. Are you trying to get your Access database to connect to our SQL server?
Hi Ray, Yes, an MS Access front-end holding forms and reports on the local machine, linked to tables and views on your hosted SQL Server. Regards, Joe
If you are trying to upsize your Access database to SQL I suggest you look at this link. http://support.microsoft.com/kb/237980 If you are planning to use Access as an Interface to manage your SQL database I suggest you do not do that and download Microsoft SQL Server Management Studio instead. The express version is free to download from Microsofts webpage. http://www.microsoft.com/downloads/...c2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en
If you want to use Access as a front end to SQL Server you simply create a new database project named *.adp and you will be prompted for the datalink properties (ie. server name, username, password, database name). I have done this successfully using Access 2003, 2007 and 2010 to SQL Server 2005 express and 2008.
