Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msmith88
Starting Member
5 Posts |
 Posted - 2008-11-20 : 08:44:34
|
| What is sys.xml_schema_wildcards? I've done some research, but none of it written for anyone who's new to SQL. Whenever I'm importing this attribute to my DB, it locks Access up completely. Could someone tell me if I need this attribute and what it does? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-11-21 : 10:51:04
|
| Need some details:1) What version of Access and SQL Server are you using?2) What are you trying to import?3) Are these linked tables?This is a SQL Server system table, it won't be updatable through an Access linked table (or any other method). Unless you're just looking at the data for informational purposes it's probably not that useful. |
 |
|
|
msmith88
Starting Member
5 Posts |
Posted - 2008-11-24 : 08:07:32
|
| Acces 07 with SQL Server 05.Trying import averything.I think there's only a couple of linked tables.I unselected all the sys.xml attributes and it seems to work fine. No real problems, but I guess I need to learn SQL quick b/c I have to rewrite all of my queries. |
|
|
|
|
|
|
Errors while importing through ODBC connection