Access Tables in SQL database

Hello:
I want to thank all that reply.

I have always worked with SQL databases in the past. But just now need to be able to work with an SQL database that holds ACCESS Table as well. Can I extract the Access table out of the SQL database? Also how would the Access tables be linked to the SQL tables.

I have SQL 2000 Server Standard Edition. Can I get the Database Designer as an Add-On? I need to be able to see(View) all of the Relationships between the SQL Tables.

Thank You.

When you say 'SQL' - do you really mean SQLServer (others refer to it as MSSQL). I'll assume you are.

SQLServer & Access are 2 totally seperate programs/databases. SQLServer is much more powerful and advanced than Access, and because of that, you need to be a lot more knowledgeable with SQL.

SQLServer has a GUI relationship designer.

I will go along with that (I need to learn alot more about SQL). However that is why I made the POST. Can you recommend a couple of good books? Yes, I mean MSSQL.

Any book which explains the fundamentals of SQL (relationships, foriegn keys, primary keys, indexing, normalisation, etc) will do. All RDMS's are essentially the same, when u get down to it.

I was taught SQL during my programming/analyst course - but a lot of websites have good primers on SQL, as it can be a tricky subject to learn. But once u get it, u get it forever.

Hi there,
There are plenty of resource on the net. I below mentioned you one good URL that will help you to know all the fundamentals of SQL and RDBMS Package.

http://www.idera.com/Documentation.htm

Also, i guessed that MSSQlServer 2000 ships with MSSQL 2000 books online package.

sqlboy

Not sure what you want to do, guessing you want to use an Access-db in MSSQL-server.

If that is the case you can create a linked server to an ODBC-source which points to the Access-db. Then you can use a select * from openquery, read all about it in BOL, Books Online.

*Sigh* Unfortunately, the poster does not know what he is talking about at all.

First off, SQL is not the name of a database. Oracle DBMS, PostgreDBMS, and yes Microsoft SQLServer are all the actual servers of the data. SQL is just the language you use to interface with above mentioned servers.

The question you might have wanted to state was:
"How do I view tables being held on an Oracle server, through MS Access?"

Answer:
"Easy. Setup a ODBC connection. This lets any program on this machine talk to the Oracle(or whatever) server to get data from it.
In XP you goto control panel > Admin Tools > Data Sources (ODBC) > System DSN tab and Add... a new system data sources.
Of course you must know all the information such as login, pass, and the servers address or name. You can get these from the DBA (Data Base Administrator). A DBA can ussually help you with this whole process too.
Then you can go into MS Access and add tables from this remote system at will."

As to being able to 'see' all the connections, this is a totally different thing and basically requires a third party program. Find out what kind of server the data is being held off of, and research that server (oracle, postgre, SQLServer) or ask your DBA again.