Re: Multiple Newbie Questions (2nd attempt)
From: Eric Sabine (mopar41_at____ho_y_tmail.ScPoAmM)
Date: 05/18/04
- Next message: Eric Sabine: "Re: Audit trail while in Transact SQL"
- Previous message: KT: "Re: Change datatype on all table (HELP, HELP, rush)"
- In reply to: Ivan Starr: "Multiple Newbie Questions (2nd attempt)"
- Next in thread: Steve Kass: "Re: Multiple Newbie Questions (2nd attempt)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 14:29:44 -0400
Ivan, please try an Access group for Access questions next time. My
comments are interspersed though,
"Ivan Starr" <ivan@ivanstarr.com> wrote in message
news:umUb5HQPEHA.2920@tk2msftngp13.phx.gbl...
> Hello,
>
> I am accessing all data on an SQL Server 7 through linked tables in an
> Access97 database. How can I get query results (in a recordset) from SQL7
> using a normal SQL query string in Access97?
>
don't use the linked tables then, use "SQL Passthrough" queries
> I'm new to all this SQL Server stuff (as if you couldn't tell), uh, how
the
> ^%$#* do you create a QUERY on the damn box anyway, and then access it the
> same way you would a regular table? Maybe something you could create a
> linked table to? I'm thinking maybe something to do with stored
> procedures, but I don't know.
>
create a view on the sql server database and then link to it as a table
> Maybe I need to know something more basic. What I need to do is eliminate
> financial data columns from an employee table for a public class of access
> and I thought that might be done with a query, which then could be set
it's
> own access priveleges. But maybe there is a more basic way to set
> permissions on particular columns. Is there?
>
just create a limited colum view
> Also, something even more basic:
> I'm trying to view the tables of a db on a SQL7 server, but cannot. I
used
> to be able to... The view says "Tables 289 Items" but then also says
"There
> are no items to show in this view" where the tables are normally listed.
>
I would assume you can see this in the linked table manager or wizard or
whatever they (access) call it. You could also use ADO or RDO and get it
through code.
> Thanks to all who even try to help, and especially to those who actually
do.
>
> Ivan
>
>
- Next message: Eric Sabine: "Re: Audit trail while in Transact SQL"
- Previous message: KT: "Re: Change datatype on all table (HELP, HELP, rush)"
- In reply to: Ivan Starr: "Multiple Newbie Questions (2nd attempt)"
- Next in thread: Steve Kass: "Re: Multiple Newbie Questions (2nd attempt)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
