Access: linked tables invisible

I've recently moved a database from mssql2000 on an NT Server machine
to 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.
I'm using odbc to connect Access to the SQL Server. Everyting else
seems to work ok.
Could anyone suggest whats wrong here, or how to go about finding out
whats wrong?
regards
Richard
On Fri, 06 May 2005 09:01:29 +0100, Richard <richard@.softmode.net>
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

Access: linked tables invisible

I've recently moved a database from mssql2000 on an NT Server machine
to 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.
I'm using odbc to connect Access to the SQL Server. Everyting else
seems to work ok.
Could anyone suggest whats wrong here, or how to go about finding out
whats wrong?
regards
RichardOn Fri, 06 May 2005 09:01:29 +0100, Richard <richard@.softmode.net>
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

Access to table blocked signature is not valid

I created sqlexpress database and .net app, everything was fine on my local machine.

When I moved the app to my server, I detached the database with SMSS express, moved the MDF file over along with the app files and I attached to the database with SSMS to make sure everything went over ok but when I try to open a table I get the error,

SQL Execution Error
Executed statement: Select x, x, x, x,x from tblFile
Error source: .Net SqlClient Data Provider
Error Message: Access to table dbl.tblFile is blocked because the signature is not valid.

I can open the stored procedures fine by choosing modify from the context menu.

Any ideas here?
This post was moved to the sql server express data category however to be clear the problem is not happening within sql server express.

I have windows 2003 server running sql server 2005 I cannot open tables to the database I've attached to sql server 2005 which I originally created on my local machine using visual studio 2005 and the bundled sql express. My problem is happening sql server 2005 not sqlexpress.

Access Sql 2005 from sql 2000

Hi,

I access the sql 2000 db's . Now, the dbs have been moved to 2005. Is it possible to connect to sql 2005 db from sql enterprise manager 2000. Or let me know if I have to upgrade to 2005 to access the same.

I get the error message To connect to the server you must use sql server management studio or sql server management objects(SMO) when trying to access the server from sql enterprise manager 2000.

Usually it is not possible to access higher version dbs from a lower version.

Please help me out as soon as possible as this is very urgent.

Thanks & Regards,

K. Sripriya

Hi Sripriya K,

You will have to upgrade to sql 2005 management studio to manage sql 2005 database's
|||Priya you cannot access your SQL 2005 databases from SQL 2000 enterprise manager but vice-versa is possible......Yes you need to have SQL 2005 to access the same.......also you cannot restore sql 2005 dbs backup file in sql 2000.....and you also cannot perform detach and attach sql 2005 dbs in sql 2000|||If you are using SQL Express then you need the install SQL Management Express seperately, from there you can access your sql.
Download SQL Mangament Express

If you have other edition then you will have management studio installed already.
Goto run, type sqlwb, press enter.. You will get management studio to connect to sql 2005 server.

You cant use EM to connect to a Sql 2005 machine, but you can use query analyser to connect to sql 2005 server.