Bill-
With your instruction, I will unhesitatingly choose to learn SQL Sever. Thanks you so much.
Best Regards,
Kevin
发自我的小米手机
在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月25日 上午12:05写道：
I hit Send way too soon. I meant to add this:
I've been working with SQL Server databases as back ends to my Access applications and the more I use them the more I love them. Security is top-notch, backups are scheduled and done without baby-sitting, And as long as you prepare for things I mentioned in my article you will find it very easy to use SQL tables and views.The biggest advantage is the much more powerful engine.If handled properly batch jobs are terrifically faster than in Access. Those complex queries that take forever to return results are instantaneous in SQL.I advise you to learn SQL code if you don't already know it. It will help you when it comes time to build views and stored procedures. The SQL Server Management Studio has some parts that are similar to Access such as building tables and queries in design view, but after awhile you will probably feel more comfortable just writing the SQL code to do that stuff.Regards,Bill Mosca, Founder - MS_Access_Professionalshttp://www.thatlldoit.comMicrosoft Office Access MVPhttps://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881EMy nothing-to-do-with-Access bloghttp://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :Dear All,I am new to sql server, but if I manage to export database backend from access to sql server, and learnt some basic backup skills, do you think it is possible to work in this context without problem? Any suggestions? Thanks in advance.Best Regards,Kevin发自我的小米手机
__._,_.___
Posted by: zhaoliqingoffice <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar