sql 7 newbee 
Author Message
 sql 7 newbee

I've elected to study SQL 7 for the +I in MCSE. I started clean. Fresh
install of NT. Fresh install of SQL 7. I've been exploring it.
Here's where this writer needs 'insight' into the nature of this
product. I studied for twenty weeks MS Access. Let me create a real
world scanerio. We have ten machine with MS Access (Or is it ten
machines with SQLl?) We have one machine with SQL "Server". From the
readings the SQL Server is the back-end. The MS Access is the Front-End.
Is this correct? I'm in need of a 'picture' in how SQL server fits.
Let's say in the ten office boxes the workers create databases of i.e.
of 'names and address'. Is it done on MS Access and the database is
stored on the Server where the DBA manages the database? Or is SQL 7
actually another version of MS Acess that
is more feature intensive? and SQL is the front end and the back
end. I  pray this note makes scense...I need to know this product and
how it works in the real world perspective in order to fulfill the MS
critera of 'knowing the product'. Thanks for any help. Chu

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Fri, 04 Jan 2002 03:00:00 GMT
 sql 7 newbee

SQL Server and Access are 2 completly different products. Access is designed
for desktop users and small easy to manage database. SQL Server 7.0 is a
large client / server database and can handle huge enteprise databases and
has comprehensice management tools. If you have a database in Access well
then it is stored in an access mdb file and not in a database. You can
however link to a SQL Server database from access using ODBC so you are able
to view and manipulate SQL Databases from access but with the tools included
in SQL Server 7.0 you should never really need to do this

Paul


Quote:
> I've elected to study SQL 7 for the +I in MCSE. I started clean. Fresh
> install of NT. Fresh install of SQL 7. I've been exploring it.
> Here's where this writer needs 'insight' into the nature of this
> product. I studied for twenty weeks MS Access. Let me create a real
> world scanerio. We have ten machine with MS Access (Or is it ten
> machines with SQLl?) We have one machine with SQL "Server". From the
> readings the SQL Server is the back-end. The MS Access is the Front-End.
> Is this correct? I'm in need of a 'picture' in how SQL server fits.
> Let's say in the ten office boxes the workers create databases of i.e.
> of 'names and address'. Is it done on MS Access and the database is
> stored on the Server where the DBA manages the database? Or is SQL 7
> actually another version of MS Acess that
> is more feature intensive? and SQL is the front end and the back
> end. I  pray this note makes scense...I need to know this product and
> how it works in the real world perspective in order to fulfill the MS
> critera of 'knowing the product'. Thanks for any help. Chu

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.



Sat, 05 Jan 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. dynamic sql - newbee question

2. Newbee SQL Server Question

3. Newbee ? Access97 into SQL 6.5

4. HELP explain SQL licensing!! Newbee Question...Sorry

5. (newbee)Sql query

6. Newbee: Problem when installing SMS 1.2 on SQL 7

7. Newbee and SQL

8. Newbee and SQL

9. Newbee--Does anyone have sample code ? VB/SQL

10. Dynamic SQL newbee question

11. newbee SQL question about record locking

12. newbee seeks upgrade help


 
Powered by phpBB® Forum Software