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]

"mark | r" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

mark

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]

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" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

mark

[WIlliam Morris]

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

Yep, nit picking alright.

"Mark Schupp" <ms*****@ielearning.com> wrote in message
news:#4*************@TK2MSFTNGP12.phx.gbl...

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" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

mark

[Bob Lehmann]

I prefer tomahtoes :>).

Bob Lehmann

"WIlliam Morris" <se**************@hotmail.com> wrote in message
news:bl************@ID-205671.news.uni-berlin.de...

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

Yep, nit picking alright.

"Mark Schupp" <ms*****@ielearning.com> wrote in message
news:#4*************@TK2MSFTNGP12.phx.gbl...

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" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

mark

[mark | r]

"John Blessing" <jb@**REMOVE**THIS**LbeHelpdesk.com> wrote in message
news:XO*****************@newsfep4-winn.server.ntli.net...

"mark | r" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

mark

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

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]

On Fri, 3 Oct 2003 17:43:50 +0100, "mark | r" <ma**@nmd.freeuk.com>
wrote:

"John Blessing" <jb@**REMOVE**THIS**LbeHelpdesk.com> wrote in message
news:XO*****************@newsfep4-winn.server.ntli.net...

"mark | r" <ma**@nmd.freeuk.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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

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

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

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.