MS Access Vs SQL

[mark | r]

whats the difference in terms of workflow between access and MS SQL
Databases? is SQL as easy to use as access?

mark

[John Blessing]

Re: MS Access Vs SQL


"mark | r" <mark@nmd.freeu k.com> wrote in message
news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=blue]
> whats the difference in terms of workflow between access and MS SQL
> Databases? is SQL as easy to use as access?
>
> mark
>[/color]

As easy? Probably not.
More robust, scalable? definitely.

Remember, the program MS Access is a front-end to interacting with an Access
database.

Just like Sql Server Enterprise Manager is to a Sql Server database.

So, when you say easy to use, are you talking about the front-end program or
the actual database?

If you are happier using MS Access, you can link to a Sql Server database
from it and still do most things you want.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[Mark Schupp]

Re: MS Access Vs SQL

nit picking but:

SQL = Structured Query Language (from IBM originally, supported by most
DBMSs)

Microsoft SQLServer = Microsoft DBMS product.

--
Mark Schupp
Head of Development
Integrity eLearning

https://www.ielearning.com

"mark | r" <mark@nmd.freeu k.com> wrote in message
news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=blue]
> whats the difference in terms of workflow between access and MS SQL
> Databases? is SQL as easy to use as access?
>
> mark
>
>[/color]

[WIlliam Morris]

Re: MS Access Vs SQL

And tomatoes aren't actually vegetables, they're fruit.

Yep, nit picking alright.

"Mark Schupp" <mschupp@ielear ning.com> wrote in message
news:#4GiSVRiDH A.964@TK2MSFTNG P12.phx.gbl...[color=blue]
> nit picking but:
>
> SQL = Structured Query Language (from IBM originally, supported by most
> DBMSs)
>
> Microsoft SQLServer = Microsoft DBMS product.
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "mark | r" <mark@nmd.freeu k.com> wrote in message
> news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=green]
> > whats the difference in terms of workflow between access and MS SQL
> > Databases? is SQL as easy to use as access?
> >
> > mark
> >
> >[/color]
>
>[/color]

[Bob Lehmann]

Re: MS Access Vs SQL

I prefer tomahtoes :>).

Bob Lehmann

"WIlliam Morris" <seamlyneNO_SP_ AM@hotmail.com> wrote in message
news:blhsvc$cen se$1@ID-205671.news.uni-berlin.de...[color=blue]
> And tomatoes aren't actually vegetables, they're fruit.
>
> Yep, nit picking alright.
>
> "Mark Schupp" <mschupp@ielear ning.com> wrote in message
> news:#4GiSVRiDH A.964@TK2MSFTNG P12.phx.gbl...[color=green]
> > nit picking but:
> >
> > SQL = Structured Query Language (from IBM originally, supported by most
> > DBMSs)
> >
> > Microsoft SQLServer = Microsoft DBMS product.
> >
> > --
> > Mark Schupp
> > Head of Development
> > Integrity eLearning
> > www.ielearning.com
> >
> >
> > "mark | r" <mark@nmd.freeu k.com> wrote in message
> > news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=darkred]
> > > whats the difference in terms of workflow between access and MS SQL
> > > Databases? is SQL as easy to use as access?
> > >
> > > mark
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[mark | r]

Re: MS Access Vs SQL


"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:XOVeb.5006 $QH3.1418@newsf ep4-winn.server.ntl i.net...[color=blue]
>
> "mark | r" <mark@nmd.freeu k.com> wrote in message
> news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=green]
> > whats the difference in terms of workflow between access and MS SQL
> > Databases? is SQL as easy to use as access?
> >
> > mark
> >[/color]
>
> As easy? Probably not.
> More robust, scalable? definitely.
>
> Remember, the program MS Access is a front-end to interacting with an[/color]
Access[color=blue]
> database.
>
> Just like Sql Server Enterprise Manager is to a Sql Server database.
>
> So, when you say easy to use, are you talking about the front-end program[/color]
or[color=blue]
> the actual database?
>
> If you are happier using MS Access, you can link to a Sql Server database
> from it and still do most things you want.
>
> --
> John Blessing[/color]

thanks john

is the Enterprise Manager easy to use and is it a similar process, e.g. a
..sql file (database) contains tables, with rows and columns of information?
and the manager is a way of setting up and adding raw information?
mark

[Dan Brussee]

Re: MS Access Vs SQL

On Fri, 3 Oct 2003 17:43:50 +0100, "mark | r" <mark@nmd.freeu k.com>
wrote:
[color=blue]
>
>"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
>news:XOVeb.500 6$QH3.1418@news fep4-winn.server.ntl i.net...[color=green]
>>
>> "mark | r" <mark@nmd.freeu k.com> wrote in message
>> news:3f7bfd25$0 $252$cc9e4d1f@n ews.dial.pipex. com...[color=darkred]
>> > whats the difference in terms of workflow between access and MS SQL
>> > Databases? is SQL as easy to use as access?
>> >
>> > mark
>> >[/color]
>>
>> As easy? Probably not.
>> More robust, scalable? definitely.
>>
>> Remember, the program MS Access is a front-end to interacting with an[/color]
>Access[color=green]
>> database.
>>
>> Just like Sql Server Enterprise Manager is to a Sql Server database.
>>
>> So, when you say easy to use, are you talking about the front-end program[/color]
>or[color=green]
>> the actual database?
>>
>> If you are happier using MS Access, you can link to a Sql Server database
>> from it and still do most things you want.
>>
>> --
>> John Blessing[/color]
>
>thanks john
>
>is the Enterprise Manager easy to use and is it a similar process, e.g. a
>.sql file (database) contains tables, with rows and columns of information?
>and the manager is a way of setting up and adding raw information?
>mark
>[/color]

If you are familiar with Access, you will be able (with some looking
around) to do the database creation, etc in Enterprise Manager.

SQL Server does not have the same thing as a .MDB file. There are
files that contain the databases, tables, etc but they are typically
sort of hidden from you. Backups, etc should be done through
Enterprise Manager, etc. Do not think you can pick up SQL Server as
"the same as Access but better". Its a different beast. They both do
databases, but in a significantly different manner.