sql server odbc: SQL Server Express (and in common 2005) has secured metadata, meaning
that you will only see metadata you are priviledged to. Seems that the
account you are using to connect to the datbase does not have the
appropiate permissions to access the database.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi,

i want to import data from a stand-alone .mdf file.
I use sqlserver express 2005 (windows xp prof).

In sqlserver, i attachted the .mdf file.
Then I created an odbc link, but when i try to import data from Access, i
only see the master database, not the tables of the .mdf file.

How can i import data from a .mdf file into Access?
Thanks for help
Ben