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_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://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: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar