|
|
|
date: Fri, 20 Jun 2008 10:24:03 -0700,
group: microsoft.public.access.odbcclientsvr
back
Re: Problem for changing table link
Hi Alex,
Thank you for your reply. Actually, I did that. At the begining this Access
Database worked very well. Then this problem happened some times, but getting
worse and worse. Now the error message come out every time I check "Always
prompt
for new location". Any idea? Thanks
Di
"Alex Dybenko" wrote:
> Hi,
> if you have tables on SQL Server database - then make sure that you also
> installed database with tables, and made it running, also you need to create
> a DSN entry in Control Panel - administrative tools-ODBC
>
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
> "Di" wrote in message
> news:11EE2908-0488-4670-B402-E176F4EF7093@microsoft.com...
> >I am using vista, SQL server2005 and Access2007. I copied an Access
> >database
> > from my co-worker's computer which works very well there. But on my
> > computer,
> > when I try to change the table link (select all then check "Always prompt
> > for
> > new location then click OK), it keep showing me "ODBC call failed". Does
> > anyone know the reason and have some solutions. Any help would be
> > appreciate!!!
>
>
date: Mon, 23 Jun 2008 08:21:00 -0700
author: Di
Re: Problem for changing table link
Hi,
well, difficult to say, I would first check that SQL server is running, then
test in ODBC connections (there is a Test button). If test is ok - then
access should be able to connect
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Di" wrote in message
news:5289CAE3-B688-468D-8C04-C7649F3B9482@microsoft.com...
> Hi Alex,
>
> Thank you for your reply. Actually, I did that. At the begining this
> Access
> Database worked very well. Then this problem happened some times, but
> getting
> worse and worse. Now the error message come out every time I check "Always
> prompt
> for new location". Any idea? Thanks
>
> Di
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> if you have tables on SQL Server database - then make sure that you also
>> installed database with tables, and made it running, also you need to
>> create
>> a DSN entry in Control Panel - administrative tools-ODBC
>>
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>> "Di" wrote in message
>> news:11EE2908-0488-4670-B402-E176F4EF7093@microsoft.com...
>> >I am using vista, SQL server2005 and Access2007. I copied an Access
>> >database
>> > from my co-worker's computer which works very well there. But on my
>> > computer,
>> > when I try to change the table link (select all then check "Always
>> > prompt
>> > for
>> > new location then click OK), it keep showing me "ODBC call failed".
>> > Does
>> > anyone know the reason and have some solutions. Any help would be
>> > appreciate!!!
>>
>>
date: Mon, 23 Jun 2008 21:36:03 +0400
author: Alex Dybenko
Re: Problem for changing table link
Hi Alex,
I checked. Looks the SQL Server works fine and the ODBC cennected
successfully. Strange!!! If you have new solution, please let me know. Thank
you for your help
"Alex Dybenko" wrote:
> Hi,
> well, difficult to say, I would first check that SQL server is running, then
> test in ODBC connections (there is a Test button). If test is ok - then
> access should be able to connect
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
> "Di" wrote in message
> news:5289CAE3-B688-468D-8C04-C7649F3B9482@microsoft.com...
> > Hi Alex,
> >
> > Thank you for your reply. Actually, I did that. At the begining this
> > Access
> > Database worked very well. Then this problem happened some times, but
> > getting
> > worse and worse. Now the error message come out every time I check "Always
> > prompt
> > for new location". Any idea? Thanks
> >
> > Di
> >
> > "Alex Dybenko" wrote:
> >
> >> Hi,
> >> if you have tables on SQL Server database - then make sure that you also
> >> installed database with tables, and made it running, also you need to
> >> create
> >> a DSN entry in Control Panel - administrative tools-ODBC
> >>
> >>
> >> --
> >> Best regards,
> >> ___________
> >> Alex Dybenko (MVP)
> >> http://accessblog.net
> >> http://www.PointLtd.com
> >>
> >> "Di" wrote in message
> >> news:11EE2908-0488-4670-B402-E176F4EF7093@microsoft.com...
> >> >I am using vista, SQL server2005 and Access2007. I copied an Access
> >> >database
> >> > from my co-worker's computer which works very well there. But on my
> >> > computer,
> >> > when I try to change the table link (select all then check "Always
> >> > prompt
> >> > for
> >> > new location then click OK), it keep showing me "ODBC call failed".
> >> > Does
> >> > anyone know the reason and have some solutions. Any help would be
> >> > appreciate!!!
> >>
> >>
>
>
date: Mon, 23 Jun 2008 12:02:01 -0700
author: Di
Re: Problem for changing table link
Hi,
look also here:
http://accessblog.net/2008/05/why-sql-server-drops-connection.html
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Di" wrote in message
news:0E69BA89-7D21-4D71-814D-6AD65ADC70AD@microsoft.com...
> Hi Alex,
> I checked. Looks the SQL Server works fine and the ODBC cennected
> successfully. Strange!!! If you have new solution, please let me know.
> Thank
> you for your help
>
> "Alex Dybenko" wrote:
>
>> Hi,
>> well, difficult to say, I would first check that SQL server is running,
>> then
>> test in ODBC connections (there is a Test button). If test is ok - then
>> access should be able to connect
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>> "Di" wrote in message
>> news:5289CAE3-B688-468D-8C04-C7649F3B9482@microsoft.com...
>> > Hi Alex,
>> >
>> > Thank you for your reply. Actually, I did that. At the begining this
>> > Access
>> > Database worked very well. Then this problem happened some times, but
>> > getting
>> > worse and worse. Now the error message come out every time I check
>> > "Always
>> > prompt
>> > for new location". Any idea? Thanks
>> >
>> > Di
>> >
>> > "Alex Dybenko" wrote:
>> >
>> >> Hi,
>> >> if you have tables on SQL Server database - then make sure that you
>> >> also
>> >> installed database with tables, and made it running, also you need to
>> >> create
>> >> a DSN entry in Control Panel - administrative tools-ODBC
>> >>
>> >>
>> >> --
>> >> Best regards,
>> >> ___________
>> >> Alex Dybenko (MVP)
>> >> http://accessblog.net
>> >> http://www.PointLtd.com
>> >>
>> >> "Di" wrote in message
>> >> news:11EE2908-0488-4670-B402-E176F4EF7093@microsoft.com...
>> >> >I am using vista, SQL server2005 and Access2007. I copied an Access
>> >> >database
>> >> > from my co-worker's computer which works very well there. But on my
>> >> > computer,
>> >> > when I try to change the table link (select all then check "Always
>> >> > prompt
>> >> > for
>> >> > new location then click OK), it keep showing me "ODBC call failed".
>> >> > Does
>> >> > anyone know the reason and have some solutions. Any help would be
>> >> > appreciate!!!
>> >>
>> >>
>>
>>
date: Tue, 24 Jun 2008 21:29:53 +0400
author: Alex Dybenko
|
|
