Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Advice for using Access as Front-End

Author  Topic  Neal44 Starting Member 17 Posts Posted - 2011-03-09 : 11:06:42 Hi, Some of our business requirements typically use Access (ACCDE (formerly MDE)) as a front end to SQL. We have found that the linked tables where there are 1 or 2 key users read/writing to the SQL Server database has been successful and the projects work effectively with relatively few (if any) issues. We are now asked to support a new project which uses Access (ADP) linked to another SQL Server which has certain issues on updates (a separate matter). ACCDE vs ADP As far as I know the main differences appear to be that in the ACCDE environment you can select the tables you wish to link in one or more data sources and displays the objects as read-only (although it is possible to update these via code/queries), whereas the ADP is linked exclusively to one SQL Database and all table/stored procedure/view objects within the SQL db are displayed. I don’t know whether there are any differences in SQL performance when using either ACCDE or ADP. But the new project uses several ADP’s connected to the same SQL database which surely isn’t ideal for table/record locking etc. Any previous experiences or ideas please? Thanks in advance, Neal