Viewing (not Importing) SQL Server tables

[mac300]

I want to make an Access Form and queries (kind of a portal), which relates to tables on an SQL server. For this I need to have Linked Tables in the DB.

I use Access 2007, and tried the option in 'External Data > More > ODBC DataBase', and then choose 'Link to the data source by creating a Linked table'.

The problem is, that it seems that after I finish setting everything up, and choose the tables, it actualy Imports everything to the new DB.

I don't want or need to Import, just to have those tables as Linked to the tables in the SQL server. Bear in mind that the SQL Server is updated all the time, so if I Import everything the DB will grow each time.

Can anyone tell me if this is possible, and if yes then how? I would really appreciate it.

 

[GrexP]

How do you know it's importing the data and not linking to the table? Do changes in data not appear when you run queries on your linked tables? For me, linked SQL Server tables act very much like local tables.

 

[mac300]

Well, u might b right.

I'll try it again and check it out. If it doesn't work, I'll come back here.

Tnx again.

 

[GrexP]

In Access 2003 a little blue arrow shows up to the left of the table name for linked tables.

 

[mac300]

It's working

Ok, it seems to be working as it should, so I guess I was wrong .

Just 1 more question.

To connect to the SQL server the tables are linked to, I need to enter the password each time. Is there anywhere I can enter it, so it doesn't ask for it, since there's no option for remembering password?

Tnx again.

 

[GrexP]

I'm not sure. I need to enter password for everything, every time. Even when I go to the bathroom!

 

[SQL_Hell]

If you have a .adp file then you can tick the save password box under file/connection. if you have a .mdb then I dunno