March 8, 2005 at 4:07 am
Dear All,
In Access, we can develop simple application to query and update database. Does SQL Server provide such function as in Access?
Thank you very much.
Rgds
Victor
March 8, 2005 at 4:58 am
If you are talking about adding screens with logic behind them, then the answer is no. There are a few tools in sql server such as enterprise manager, which allow you to edit/add data into tables etc. However, the front end is like looking at an open ms access table. However, these are admin tools and allow the user too many priveleges, which is extremely dangerous.
There are hundreds of applications that can interface with sql server. MS Access application can be developed to work with sql server database backend, if you so wish. As can excel. There is an option in access to upsize to sql server which you may want to check out.
Basically, there are hundreds of third party tools that can be used.
SQL server is primarily a database management system. It is not intended to act as a complete application.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply