Linking tables access - sql server 2005

[bugerr]

Hi all,

I've a sql server 2005 database, with 60.000 tables. I need links these
tables to a access file throught odbc. If i link these with the odbc to a sql
server 2000 i obtain the 100% of tables. But with the link is with sql 2005 i
only obtain the 40-50% of the tables. I've tried play with the odbc
parammeters, but nothing happens.

Any idea?. THX

 

[Sylvain Lafontaine]

The best idea would probably be to reduce the number of tables. With a
number such as 60000 tables, there is about a 99.99999% chance and more that
the design of your database is not normalized. Reducing this number to
something like around 100 - 300 tables would be OK.

The second idea would be to ask in a newsgroup more appropriate such as
microsoft.public.access.odbcclientsvr. This newsgroup (m.p.a.adp.sqlserver)
is about ADP and SQL-Server and has nothing to do with MDB or ACCDB files
and ODBC linked tables.

The third idea would be to provide more details about your environment:
which version of Access, which version of database file (MDB or ACCDB),
which version of SQL-Server ODBC provider that you are trying to use (and
which that you did not try to use); with what method that you are linking
these; etc.

Of these three ideas, if I were you, I would lose any time on the second and
third and I would concentrate exclusively on the first one.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Sylvain Lafontaine]

But then, don't forget to provide some more details. For example, are you
using the older SQL-Serve ODBC Provider or if you are using the latest
Native ODBC Provider for SQL-Server, either the version 9.0 (that comes with
SQL-Server 2005) or 10.0 (that comes with SQL-Server 2008, both versions of
the native providers will work against other version of SQL-Server); see the
Microsoft SQL Server 2008 Feature Pack to separately download the version 10
of the Native Provider for SQL-Server:

http://www.microsoft.com/downloads/...EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Paul Shapiro]

You might check a SAP user group, or SAP technical support. I would not
expect Access to successfully work with 60,000 linked tables. I also would
guess you are not going to do anything in Access with all 60,000 tables at
once. Maybe you can select a subset of the SAP tables that represent an
"area" of the overall SAP database. If you need multiple subsets, you might
be able to use multiple Access databases, one linked to each subset.

 

[bugerr]

thx Paul, I only need 10 or 20 tables, but i cant select them because when i
am acceeding throught ODBC, the SQL Query only show me the tables in
alphabetical order, and just the tables I need i cant reach then
them

i tried with these drivers:

sql native client 2005.90.4035.00
sql server 2000.85.1132.00