Re: Access: linked tables invisible

On Fri, 06 May 2005 09:01:29 +0100, Richard <richard@xxxxxxxxxxxx>
wrote:
mssql2000 running on a Win 2003 Server machine.
>
>Now, when I try to use Access 2002 to Link an sql table, the Access
>wizard isn't showing any of the sql tables. In fact, it only shows a
>couple of the system tables: dbo.sysconstraints & dbo.syssegments and
>one of the views in the database.
>

Problem solved by installing latest mdac on workstation.

Richard

.

Relevant Pages

  • Re: Binding and adding rows with SQL identity column
    ... Each time you call AddNew then the DataTable generates a new ... Each time an update is done then the real primary key ... > generated by the built-in wizard in VS2003. ... > identity column on the sql table, perhaps this would all the fine and I ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Back Up Wizard
    ... I like the idea of the SBS 2003 Wizard keeping multiple ... Server Temp and Master Database and some SQL Server Full ... Regarding native SQL backup - Can SQL be scheduled to ... >will overwrite the oldest file on the media. ...
    (microsoft.public.windows.server.sbs)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... Personally I feel using the copy DB wizard is more effort than just a backup ... Passwords Between SQL Servers ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: How to import one DB to another using any tool
    ... I'm simply looking for an easy GUI way of doing this. ... If you absolutely want a wizard, there is the Copy Database Wizard ... Keep in mind that when working with a server application like SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Using Database Results Wizard for dropdown
    ... Present SQL for the form (showing just the dropdown portion for GroupMix; ... > Is there a parameter you can add to the sql of the Database Results Wizard ...
    (microsoft.public.frontpage.programming)