Link SQL server

J

Jason

Dear all,

I want to use the access to make some queries and report from SQL server
data. If I don't use ODBC & .adp. How can I do ?

Thank you.

Jason
 
A

Albert D. Kallal

Jason said:
Dear all,

I want to use the access to make some queries and report from SQL server
data. If I don't use ODBC & .adp. How can I do ?
Click to expand...

I not sure I understand your question?

I not aware of how else you can connect to sql server, except using linked
tables, be they in a ADP project, or a standard mdb with linked tables.

Even more perplexing, is why would linked tables be any type of problem
here?

as a basic answer to your question, I don't really see any alternatives to
linked tables to sql server. I suppose you could export some data from sql
server in a format that ms-access could use, but then you would not be
connecting to sql server...would you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does Microsoft recommend databases or projects to connect to SQL s 1
Access Front-End to SQL Server 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Best way to move data from Access backend to SQL Server 3
1 SQL Server/3 Db's to connect to 2
SQL upsize 2 databases 2
Managing MS SQL Server via MS Access 6
Access Front to SQL Server 2

Top