Re: Linking tables access - sql server 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

"Paul Shapiro" wrote:

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.

"Sylvain Lafontaine" <sylvainlafontaine2009@xxxxxxxx> wrote in message
news:ObVKjrdvJHA.248@xxxxxxxxxxxxxxxxxxxxxxx
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/details.aspx?FamilyId=C6C3E9EF-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)


"bugerr" <bugerr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48335891-E5E0-4D14-BAA0-E3CC3F5A40E4@xxxxxxxxxxxxxxxx
Unfortunely, the database scheme depends of a SAP system, that generate
this
hell. Thanks for the information, ill try in the other newsgroup

"Sylvain Lafontaine" wrote:

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)


"bugerr" <bugerr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:66E8224A-4F14-4EB8-AAFC-ADEDD1D09B1A@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Linking tables access - sql server 2005
    ... You might check a SAP user group, ... 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 ... 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: ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2005 vs. SQL Server 2000
    ... den SQL-Server 2005 untersucht. ... mit .NET-Applikation und ODBC ... Da fehlen noch Angaben wie welche .NET Version ... Welcher ODBC Treiber - alter SQL Server ...
    (microsoft.public.de.sqlserver)
  • Re: Linking tables access - sql server 2005
    ... using the older SQL-Serve ODBC Provider or if you are using the latest ... the native providers will work against other version of SQL-Server); ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)