I have a sql db file on my laptop. I am not running any sort of server based
app. Can I get the data out of the sql db via access?

Thanks!

If Access is also installed, you can directly link to the SQL-Server tables
using OLEDB or ODBC. It is easy to create an ODBC connection by building one
using the ODBC Data Source Administrator built into Windows:

Control Panel ... Administrative Tools ... Data Sources (ODBC)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"mleeber" <(E-Mail Removed)> wrote in message
news:7994ABD8-02C1-4F74-AE7C-(E-Mail Removed)...
>I have a sql db file on my laptop. I am not running any sort of server
>based
> app. Can I get the data out of the sql db via access?
>
> Thanks!

which tab under the ODBC administrator do I add the connection in?

THanks!

"Arvin Meyer [MVP]" wrote:

> If Access is also installed, you can directly link to the SQL-Server tables
> using OLEDB or ODBC. It is easy to create an ODBC connection by building one
> using the ODBC Data Source Administrator built into Windows:
>
> Control Panel ... Administrative Tools ... Data Sources (ODBC)
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "mleeber" <(E-Mail Removed)> wrote in message
> news:7994ABD8-02C1-4F74-AE7C-(E-Mail Removed)...
> >I have a sql db file on my laptop. I am not running any sort of server
> >based
> > app. Can I get the data out of the sql db via access?
> >
> > Thanks!
>
>
>

"mleeber" <(E-Mail Removed)> wrote in message
news:FB6D92F2-9EA5-4780-9E80-(E-Mail Removed)...
> which tab under the ODBC administrator do I add the connection in?
>
> THanks!

The responder likely missed the fact that you don't have sql server
installed on your local machine. You do need to install sql server on your
machine to be able to read, and open the sql data file....

You can also install the free desktop version of sql server (there is a copy
on each office cd).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal

Thanks Albert! I was afraid I had to have an Instance of SQL server running
somewhere. I will check out my office CD for the desktop version.

"Albert D.Kallal" wrote:

>
> "mleeber" <(E-Mail Removed)> wrote in message
> news:FB6D92F2-9EA5-4780-9E80-(E-Mail Removed)...
> > which tab under the ODBC administrator do I add the connection in?
> >
> > THanks!
>
> The responder likely missed the fact that you don't have sql server
> installed on your local machine. You do need to install sql server on your
> machine to be able to read, and open the sql data file....
>
> You can also install the free desktop version of sql server (there is a copy
> on each office cd).
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
> http://www.members.shaw.ca/AlbertKallal
>
>
>

"Albert D.Kallal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> "mleeber" <(E-Mail Removed)> wrote in message
> news:FB6D92F2-9EA5-4780-9E80-(E-Mail Removed)...
>> which tab under the ODBC administrator do I add the connection in?
>>
>> THanks!
>
> The responder likely missed the fact that you don't have sql server
> installed on your local machine. You do need to install sql server on your
> machine to be able to read, and open the sql data file....
>
> You can also install the free desktop version of sql server (there is a
> copy on each office cd).

You can read or write to a SQL-Server file running on a remote server (using
port 1433) with an ODBC connection with an MDB. If you have an ADP, you can
directly open and manipulate the remote file. You do not need the file on
the local machine at all.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

>. You do not need the file on the local machine at all.

Unfortunately, the poster states that they don't have sql server, nor access
to the remote server where the data came from.

All they have is a local sql data file on the notebook. Ms-access can't open
that....

Without question, your suggestion to connect to the sql server is the best
choice, but that assumes they have access to the server, and from what I can
see the OP does not.

I would have to say that the person sending the data should at least export
from the sql server to excel, or ms-access BEFORE sending the file.

Receiving a raw sql server data file is not very useful...and can't be
opened by much of anything except sql server.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal