从SQL Server到MS Access 2007 [英] From SQL Server to MS Access 2007
问题描述
您是否可以从在SQL Server中具有良好背景的开发人员的角度，推荐一个学习MS Access的良好资源.
Could you recommend a good resource on learning MS Access from the perspective of a developer with a good background in SQL Server.
在诸如
- 多用户访问支持
- 安全性；数据库和前端Access界面(Forms，Reports)
- 部署
基本上，如果您同时具有SQL Server和MS Access开发的经验，您将向具有SQL Server经验的其他开发人员提供最佳实践建议，该经验需要在MS Access中开发应用程序(数据库和前端).
Basically if you have experience in both SQL Server and MS Access development what best practice advice would you give to your fellow developer with SQL Server experience that needs to develop an application in MS Access (both the database and the front end).
有问题的应用程序将托管在服务器上，并由多个用户共享(10至20).它只需要用MS Access 2007编写.要使用表单和报表访问数据(不能直接访问表).将有3种不同的用户类型-这意味着不同的访问权限.全部都在Intranet设置中.
The application in question will be hosted on the server and shared by multiple users (10 to 20). It needs to be written exclusively in MS Access 2007. Data to be accessed with the use of Forms and Reports (no direct access to the tables). There will be 3 different user types - which implies different access rights. All within an Intranet set-up.
我意识到这个问题涉及面很广，但是我希望以此作为一个很好的起点，对此我将不胜感激
I realise that the question is quite broad but I am hopping to use the answers as a good starting point and I will appreciate any input on this
谢谢
编辑
到目前为止，谢谢您的回答.只是想澄清一下，在这种特定情况下，MS Access是唯一的选择
Thank you for you answers so far. Just wanted to clarify that in this particular scenario, MS Access is the only option
推荐答案
不幸的是，Access受到不良的传闻和传闻的困扰，其中很多确实过时了.
Unfortunately Access suffers from bad press and hearsay, much of it very out-of-date indeed.
这里有一些有用的注释:
There are some useful notes here:
https://stackoverflow.com/questions/469799/what是用于ms访问的合适方法
ms-access标记中还有许多其他有用的线程，这些线程是由对Access有丰富经验的人编写的，而不是某些注释中所表明的.
There are a number of other useful threads within the ms-access tag, written by people with a fuller experience of Access than seems to be evinced in some of the comments.
我想对于具有SQL Server经验的人来说，主要困难将是适应于更为有限的Jet/Ace SQL.
I would imagine the main difficulty for someone with SQL-server experience will be adjusting to the more limited Jet/Ace SQL.
这篇关于从SQL Server到MS Access 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
