Re: New to SQL server

Doug;

SQL Server is the best flavor of Access. It is called 'Access Data
Projects' or the ADP format.

Learn it, love it.. laugh at people that still use MDB

-Aaron


Douglas J. Steele wrote:
First of all, remember that Access is a full development environment: forms,
reports, code, etc. plus a database. SQL Server is only a database. However,
as a database, it has far greater capabilities than Access. It can hold far
more data than an MDB file, it has logs and the like to ensure
recoverability in case of a problem and it has far better security than
Access. Even if you move your data into SQL Server, Access is still an ideal
client for your application.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"ironwood9 via AccessMonster.com" <u12024@uwe> wrote in message
news:69714c57b5170@xxxxxx
I am just learning SQL server - I'm going through these videos from a
company
called Learn Key - 18 videos - it's the most , comprehensive, educational,
interactive, user friendly learning materials I've ever seen. A-nyway,
what
is the big advantage with SQL server ? MS Access alone has always met my
needs, but everyone makes such a big deal about SQL server. I'm not
trying
to be negative, I really want to know.

Any input would be greatly appreciated - SQL server dba's are in HUGE
demand -


--
Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: A little help with access forms.
    ... This is an upsized database and it does have the upsize_ts field, however, I ... I lay no claim to this "design". ... I didn't say Access, I said .mdb file. ... get my users over to SQL server. ...
    (microsoft.public.access.conversion)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)