Connectivity Issue

I recently posted a few columns on how to connect. I figured a way, through a mapped network drive. Although this has to be temporary for the extreme nature of connecting this way. It will have to do for now. But, I couldn't get around the issue of connecting my Access 2003 to SQL Server 05.

My new question is this: What do I need to do in order for the tables I created on the server side to show in the link tables window?

It gives me all of the other database library mumbo jumbo, but I don't see the two tables I created...

Another question is this: What about when I create other tables on the server side, will I have to repeat the connection process so I can see those tables as well?

Hi,

ok, if you are sure that you are connected to the right database, you will have to grant the appropiate priviledges to the user who is connecting. The metadata is as of SQL Server 2005 secured, which means that you will only see the tables you have currently access to.

For the other question it depends which project type you are using in access. If you are <using an ADP project (which directly talks to the SQL Server) you can just do a refresh in the listing windows of Access and will see the additional tables and objects. If you are using a "normal" access project, you will have to go through the process of adding the new tables through the "Add new linked table" > "Select the datasource" etc.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

About the first issue, even with SQL Server 2005 secured. Those tables I do have access to are not tables that I have created. What does that mean?

The second issue maybe I should use the ADP method for Access. It sounds like the kind of thing I wanted to do in the first place.

Thanks, for the assistance. I am an Oracle person myself so to be introduced to these databases as the norm is somewhat new to me.

|||If you did not craete them and have acces to the tables you are either granted explicit grants on the tables for your login or you are in a group which has the permissions to access the objects (like a role in ORACLE, e.g. the sysdba role/user).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I agree, but I don't understand. Why I would not have access to the two tables I created, they are apart of the same instance as the master table, etc.?

I found out also I may have to back away from the ADP version, it seems to be very webby. I don't mind but here is a very secure culture and I don't know if the interested parties would like that kind of exposure. It is on Access now, and I don't care to much for that. I used to create front end VB interfaces for an Oracle backend. Now I am into Access, trying to make this fly with SQL SERVER. I am hoping to move back into VB/.NET (bread & butter, lol) that maybe the next move.

|||Good luck :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de