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]

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.

 

[WIlliam Morris]

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

Yep, nit picking alright.

 

[Bob Lehmann]

I prefer tomahtoes :>).

Bob Lehmann

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

Yep, nit picking alright.

 

[mark | r]

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.

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]

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.