Re: Linking tables access - sql server 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Speed of working on Access tables
    ... You'd probably get a better discussion in an Access-dedicated newsgroup, ... The database already exists, so I don't need to create the ... What methods can I use to do the work on the Access database that I have ... I have read that ODBC is faster than ADO, ...
    (microsoft.public.office.developer.automation)
  • Re: Linking to Access from SQL Server (linked server)
    ... Sylvain Lafontaine, ing. ... for the Access database and then use OLE DB for ODBC databases as my ... server provider. ...
    (microsoft.public.access.security)
  • Re: not updateable
    ... Hi, first, this newsgroup is about ADP and SQL-Server and has nothing to do ... with which ODBC driver are you linking your tables? ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Creating Web applications in VB.NET
    ... Almost everybody in this newsgroup is using VB6 or lower. ... Each instance will access a different database via ODBC. ... same ODBC data source. ...
    (microsoft.public.vb.general.discussion)
  • Re: Word 2003 and Access 2000 compatibility
    ... 2000 database using ODBC ... Cindy Meister ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.docmanagement)