Link Tables

Hi,
Trying to link tables from Access 2000 to SQL 2000. Am successfully linking
tables as long as there are no spaces in the table name.
tableA from access to TableA to SQL link successfully.
table B from access to TableB or table B get odbc -- call failed
help
stoneystoney wrote:
> Hi,
> Trying to link tables from Access 2000 to SQL 2000. Am successfully linking
> tables as long as there are no spaces in the table name.
> tableA from access to TableA to SQL link successfully.
> table B from access to TableB or table B get odbc -- call failed
> help
> stoney
Hi Stoney
You don't say how you link the tables, but try to put [] around the name
- e.g. [Table B].
--
Regards
Steen Schlüter Persson
Database Administrator / System Administratorsql

Link Tables

Hi,
Trying to link tables from Access 2000 to SQL 2000. Am successfully linking
tables as long as there are no spaces in the table name.
tableA from access to TableA to SQL link successfully.
table B from access to TableB or table B get odbc -- call failed
help
stoneystoney wrote:
> Hi,
> Trying to link tables from Access 2000 to SQL 2000. Am successfully linki
ng
> tables as long as there are no spaces in the table name.
> tableA from access to TableA to SQL link successfully.
> table B from access to TableB or table B get odbc -- call failed
> help
> stoney
Hi Stoney
You don't say how you link the tables, but try to put [] around the name
- e.g. [Table B].
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

Link Server

Can u have a link server from SQL 7 to SQL 2000. I keep getting login error but I can connect successfully using query analyzer
thx
In the security tab in the linked server select the option: Be made using
this security context and put in the sa account and password. If that works
you can configure a standard SQL login to use.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||that is how I have it but I get 'login failed for sa' and I know the passwd is right

Link Server

Can u have a link server from SQL 7 to SQL 2000. I keep getting login error
but I can connect successfully using query analyzer
thxIn the security tab in the linked server select the option: Be made using
this security context and put in the sa account and password. If that works
you can configure a standard SQL login to use.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||that is how I have it but I get 'login failed for sa' and I know the passwd
is rightsql

Lingering subscription after disabling Publishing and distribution

Hi,
I have used the 'Disable Publishing and Distribution wizard' to remove all
publications and subscriptions and it went successfully. But why is there a
subscription item listed in the 'Subscriptions' folder under the
'Replication' folder in the SQL enterprise manager in both the publisher
server and the subscriber server? How can I remove it?
Wingman
As you've disabled replication, you can run sp_removedbreplication on each
database that has these remnant replication system tables.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Limiting Access with Forms Authentication

All,
I have successfully implemented a forms authentication model for
reporting services in our dev environment. I took the code directly
from the MSDN whitepaper "Using Forms Authentication in Reporting
Services", although I did modify the authentication portion to use an
in house Oracle solution. How do I go about ensuring that only certain
groups (departments) have access to certain folders in the report
manager? Is this possible with a forms authentication solution?
ThanksSearch the below URL for 'forms authentication groups'. I found quite a few
results:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs
Adrian M.
MCP
"Will" <wlansing@.rlcarriers.com> wrote in message
news:1109799138.404265.258540@.z14g2000cwz.googlegroups.com...
> All,
> I have successfully implemented a forms authentication model for
> reporting services in our dev environment. I took the code directly
> from the MSDN whitepaper "Using Forms Authentication in Reporting
> Services", although I did modify the authentication portion to use an
> in house Oracle solution. How do I go about ensuring that only certain
> groups (departments) have access to certain folders in the report
> manager? Is this possible with a forms authentication solution?
> Thanks
>