Adding MS Access Project

I am VERY NEW to this.
I'm installed the MSDE and it's running on my desktop.
I'm trying to make a new Ms Access Project.
It asks for a user name and password and I supply sa as the user and leave
the password blank.
I get an error back saying that:
Connection Failed
SQLState: '01000'
SQL Server Error: 10054
and more...is that enough of the error for you to know what I'm doing
wrong?
Thanks.
Also, I'm familiar with MS Access frontend/backend setup. When I get it
working, does the project work as the frontend and the SQL database the
backend?
Is there a link to intro info on all of this?
Thanks.
Sorry for the double post. Didn't mean to.
I found that Norton Personal Firewall is blocking this from running. Which
program do I need to allow access. MS Access has access.
Thanks.
"SAC" <someone@.microsoft.com> wrote in message
news:OY3Xbjr8EHA.2900@.TK2MSFTNGP09.phx.gbl...
> I am VERY NEW to this.
> I'm installed the MSDE and it's running on my desktop.
> I'm trying to make a new Ms Access Project.
> It asks for a user name and password and I supply sa as the user and leave
> the password blank.
> I get an error back saying that:
> Connection Failed
> SQLState: '01000'
> SQL Server Error: 10054
> and more...is that enough of the error for you to know what I'm doing
> wrong?
> Thanks.
> Also, I'm familiar with MS Access frontend/backend setup. When I get it
> working, does the project work as the frontend and the SQL database the
> backend?
> Is there a link to intro info on all of this?
> Thanks.
>
>
|||hi,
"SAC" <someone@.microsoft.com> ha scritto nel messaggio
news:OY3Xbjr8EHA.2900@.TK2MSFTNGP09.phx.gbl
> I am VERY NEW to this.
> I'm installed the MSDE and it's running on my desktop.
> I'm trying to make a new Ms Access Project.
> It asks for a user name and password and I supply sa as the user and
> leave the password blank.
> I get an error back saying that:
> Connection Failed
> SQLState: '01000'
> SQL Server Error: 10054
> and more...is that enough of the error for you to know what I'm doing
> wrong?
> Thanks.
> Also, I'm familiar with MS Access frontend/backend setup. When I get
> it working, does the project work as the frontend and the SQL
> database the backend?
> Is there a link to intro info on all of this?
> Thanks.
please have a look at http://tinyurl.com/4vho5
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply