Monday, 19 March 2012

connect SQL server to access

hi everybody!
can anyone help me, please. thanks in advance.
i have installed sql server express 2005, and have a .mdb database in access
2003. with the upsizing wizard i have succeeded in connecting to a sql
database.
i am now trying manually to connect to sql server, bu t i cant seem to find
my database anywhere, in the "linked tables" dialog box.
id appreciate any help.
im a complete newnie to sql server
ill note again that my .mdb database currently has linked tables, which were
added automatically. my problem is figuring out how to do it myself.
--
Lumped & Stumped
Thankfully, YisManYou may have better response by posting in one of the 20+
microsoft.public.access groups.
Arnie Rowland
"To be successful, your heart must accompany your knowledge."
"YisMan" <yisman@.att.net> wrote in message
news:508E1C1E-6172-4029-B20D-FE17389DE34D@.microsoft.com...
> hi everybody!
> can anyone help me, please. thanks in advance.
> i have installed sql server express 2005, and have a .mdb database in
> access
> 2003. with the upsizing wizard i have succeeded in connecting to a sql
> database.
> i am now trying manually to connect to sql server, bu t i cant seem to
> find
> my database anywhere, in the "linked tables" dialog box.
> id appreciate any help.
> im a complete newnie to sql server
> ill note again that my .mdb database currently has linked tables, which
> were
> added automatically. my problem is figuring out how to do it myself.
> --
> Lumped & Stumped
> Thankfully, YisMan

No comments:

Post a Comment