Re: Linking Tables Problem, Access vs SQL 2005

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

Is it always the same tables that you get? Always the same number of tables? Are they the first 40-50% in name order, object id order, et cetera? Any kind of pattern?

One thing to know is that security is different in SQL Server 2005. In SQL Server 2000 you would be able to see metadata on all the tables in a database to which you had access. In SQL Server 2005 you (by default) can only see metadata for tables to which you have some rights. If this is the problem, then you can restore access to the metadata by:

USE DatabaseName
GRANT VIEW DEFINITION TO [Domain\Login]

This removes the metadata restriction in that database.

RLF

"bugerr" <bugerr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2AF267B9-CA57-4E02-9D98-825A5360365C@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. Other theme is that with the same odbc
driver if i link from excell, obtain a perfect 100%. So i dont know if the
problem is access, the odbc connection, any configuration of sql server
2005...

The sql native driver version is: 2005.90.4035.00

Any idea?. THX


.

Relevant Pages

  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Need ODBCDirect-ion
    ... Just as a side note, ODBC, or so called "jet" direct is simply a way to ... You need experience with sql server. ... "Upsizing to Microsoft SQL Server" White Paper Available in Download ... Choosing Database Tools White Paper Available in Download Cente ...
    (microsoft.public.access.modulesdaovba)
  • Re: Supporting a variety of database types in an app?
    ... Ralph, thank you for your insightful response. ... To get experience with MS SQL Server and client/server development. ... My rationale for using a file-based database location/selection method: ... ODBC API, but modified it to enhance performance). ...
    (microsoft.public.vb.database)
  • Re: Trusted Connection
    ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
    (microsoft.public.sqlserver.security)