Access 2000 and SQL Server 2005

Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I
keep trying, but it doesn't want to accept my id, even though it is right.

Re: Access 2000 and SQL Server 2005

JA (jarmour at kc.rr.com) writes:
> Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I
> keep trying, but it doesn't want to accept my id, even though it is right.

You cannot accuse me for knowing too much Access, but I don't see why
it would not work. (Mind you, I don't even know an ADP is.)

It could help if you post the error message you get and the connection
string you are using.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Access 2000 and SQL Server 2005

Hi Erland,

I don't have the original post in my Windows Mail so I am replying to the
group by replying to your post. ADP stands for Access Data (or Database -
It's been a while)
Project. With Access 2000 you had the option to continue use .mdb files
that used primarily JET engine and you could use linked tables to connect
to SQL 2000. Using .adp you were directly connected to the SQL databases
and you could not use JET engine.


JA, it seems you can not use Access 2000 with SQL 2005

http://groups.google.com/groups/search?q=access+2000+adp+sql +2005

http://groups.google.com/group/microsoft.public.access.adp.s qlserver/browse_thread/thread/38e06a5b20ffdef0/f94b34707134f 81f?lnk=st&q=access+2000+adp+sql+2005#f94b34707134f81f


"Erland Sommarskog" wrote in message
news:Xns9A2CEC660189FYazorman@127.0.0.1...
> JA (jarmour at kc.rr.com) writes:
>> Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I
>> keep trying, but it doesn't want to accept my id, even though it is
>> right.
>
> You cannot accuse me for knowing too much Access, but I don't see why
> it would not work. (Mind you, I don't even know an ADP is.)
>
> It could help if you post the error message you get and the connection
> string you are using.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Access 2000 and SQL Server 2005

Thanks Erland and Serge,

I found a program from Microsoft that allows me to do some of what I need to
do (add and populate a new table), without using Access.

It's called the SQL Server Migration Assistant (SSMA) and is free from
Microsoft. You have to have the .Net framework 2.0 or better on your
computer, also J# framework, both are free from Microsoft.

Go to this blog for info and a step-by-step Word doc on how to do it.
http://cfpayne.wordpress.com/2006/07/23/how-to-import-micros oft-access-into-sql-server-2005/

He says you need to dl Sql Server 2005 to your machine, but I used it (SSMA)
without doing that.







"serge" wrote in message
news:HBalj.61840$%h3.99922@weber.videotron.net...
> Hi Erland,
>
> I don't have the original post in my Windows Mail so I am replying to the
> group by replying to your post. ADP stands for Access Data (or Database -
> It's been a while)
> Project. With Access 2000 you had the option to continue use .mdb files
> that used primarily JET engine and you could use linked tables to connect
> to SQL 2000. Using .adp you were directly connected to the SQL databases
> and you could not use JET engine.
>
>
> JA, it seems you can not use Access 2000 with SQL 2005
>
> http://groups.google.com/groups/search?q=access+2000+adp+sql +2005
>
> http://groups.google.com/group/microsoft.public.access.adp.s qlserver/browse_thread/thread/38e06a5b20ffdef0/f94b34707134f 81f?lnk=st&q=access+2000+adp+sql+2005#f94b34707134f81f
>
>
> "Erland Sommarskog" wrote in message
> news:Xns9A2CEC660189FYazorman@127.0.0.1...
>> JA (jarmour at kc.rr.com) writes:
>>> Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I
>>> keep trying, but it doesn't want to accept my id, even though it is
>>> right.
>>
>> You cannot accuse me for knowing too much Access, but I don't see why
>> it would not work. (Mind you, I don't even know an ADP is.)
>>
>> It could help if you post the error message you get and the connection
>> string you are using.
>>
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
>

Re: Access 2000 and SQL Server 2005

> It's called the SQL Server Migration Assistant (SSMA) and is free from
> Microsoft. You have to have the .Net framework 2.0 or better on your
> computer, also J# framework, both are free from Microsoft.
>
> Go to this blog for info and a step-by-step Word doc on how to do it.
> http://cfpayne.wordpress.com/2006/07/23/how-to-import-micros oft-access-into-sql-server-2005/
>
> He says you need to dl Sql Server 2005 to your machine, but I used it
> (SSMA) without doing that.

They have an SSMA for MS Access too?

I've used SSMA to migrate Oracle databases and I was happy with the product
since it was easy to use to migrate the data. I only had to migrate the
data.
Converting PL/SQL to T-SQL didn't seem to be 100% efficient but in my
case I didn't need to convert code also.

So as long as it worked for you to get the job done, then it's good.