Query MSSQL from MSAccess or other tools within MSOffice

[Guest]

Hello:

I was given permissions to access MSSQL server. I would like to query data
from MsAccess on that server. I was trying to link to it via ODBC connection
- I am not sure if this is ithe right approach and what information I need
form the SQL administrator? I would appreciate some directions?

Thank you.

 

[[MVP] S.Clark]

An Access Data Project (aka ADP) is a native connection, and a very awesome
tool for querying data in SQL Server.

File / New / [Task pane] Project using existing data...

 

[Guest]

Hello:

Thanks for pointing me to ADP. I made a connection to db (actually there are
4 files that are showing for selection. So I connect and I can see tables
and queries (inline functions and procedures). I believe, I can see one of
the tables that I need but do not have an idea how to find the 4 data fields
that I am looking for. Do I need to contact the administrator- I know what I
need but I don't know how to find it - can you help? Also, I am not able to
connect as specific user - I am choosing the option "Use Windows NT
Integrated security" - is there any difference here?
I just need to select data and do not need to modify it.

I developed application in MsAccess/VBA but it would be much easier if I
could query data directly on the MSQL server instead exporting/importing it
to my application. My problem is that I do not have much experience with SQL
server. Can you help?
--
danka

An Access Data Project (aka ADP) is a native connection, and a very awesome
tool for querying data in SQL Server.

File / New / [Task pane] Project using existing data...

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

Hello:

I was given permissions to access MSSQL server. I would like to query
data
from MsAccess on that server. I was trying to link to it via ODBC
connection
- I am not sure if this is ithe right approach and what information I need
form the SQL administrator? I would appreciate some directions?

Thank you.

 

[[MVP] S.Clark]

For your proper login and permissions, you need to contact the SQL Server
admin.

All of us can help, but you'll need to ask specifiic questions.

Maybe a book or training course can get you up to speed:
http://fmsinc.com/Training/pages/Access03_SQL.asp

But, if you're looking for the really fast solution, you can hire one of the
many consultants, that hang around here answering questions.
http://www.fmsinc.com/consulting

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

Hello:

Thanks for pointing me to ADP. I made a connection to db (actually there
are
4 files that are showing for selection. So I connect and I can see
tables
and queries (inline functions and procedures). I believe, I can see one
of
the tables that I need but do not have an idea how to find the 4 data
fields
that I am looking for. Do I need to contact the administrator- I know
what I
need but I don't know how to find it - can you help? Also, I am not able
to
connect as specific user - I am choosing the option "Use Windows NT
Integrated security" - is there any difference here?
I just need to select data and do not need to modify it.

I developed application in MsAccess/VBA but it would be much easier if I
could query data directly on the MSQL server instead exporting/importing
it
to my application. My problem is that I do not have much experience with
SQL
server. Can you help?
--
danka

An Access Data Project (aka ADP) is a native connection, and a very
awesome
tool for querying data in SQL Server.

File / New / [Task pane] Project using existing data...

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

Hello:

I was given permissions to access MSSQL server. I would like to query
data
from MsAccess on that server. I was trying to link to it via ODBC
connection
- I am not sure if this is ithe right approach and what information I
need
form the SQL administrator? I would appreciate some directions?

Thank you.

 

[Guest]

Thank you very much - I will see what I can do - I contacted the
administrator. The next quesion will be more specific.
--
danka

For your proper login and permissions, you need to contact the SQL Server
admin.

All of us can help, but you'll need to ask specifiic questions.

Maybe a book or training course can get you up to speed:
http://fmsinc.com/Training/pages/Access03_SQL.asp

But, if you're looking for the really fast solution, you can hire one of the
many consultants, that hang around here answering questions.
http://www.fmsinc.com/consulting

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

Hello:

Thanks for pointing me to ADP. I made a connection to db (actually there
are
4 files that are showing for selection. So I connect and I can see
tables
and queries (inline functions and procedures). I believe, I can see one
of
the tables that I need but do not have an idea how to find the 4 data
fields
that I am looking for. Do I need to contact the administrator- I know
what I
need but I don't know how to find it - can you help? Also, I am not able
to
connect as specific user - I am choosing the option "Use Windows NT
Integrated security" - is there any difference here?
I just need to select data and do not need to modify it.

I developed application in MsAccess/VBA but it would be much easier if I
could query data directly on the MSQL server instead exporting/importing
it
to my application. My problem is that I do not have much experience with
SQL
server. Can you help?
--
danka

An Access Data Project (aka ADP) is a native connection, and a very
awesome
tool for querying data in SQL Server.

File / New / [Task pane] Project using existing data...

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

Hello:

I was given permissions to access MSSQL server. I would like to query
data
from MsAccess on that server. I was trying to link to it via ODBC
connection
- I am not sure if this is ithe right approach and what information I
need
form the SQL administrator? I would appreciate some directions?

Thank you.