SQL2000 / Access 2010 connectivity

[mutley1]

Hey guys,

I have an access 2010 DB on my desktop and want to connect SQL 2000 to it so I can use SQL to manipulate the data. I have googled but everthing that comes back is regarding access upsizing etc. or creating linked tables (which I don't really want to do I just want to access the raw data). I can write more complex scripts in SQL so just wanthed help with connection strings etc. as I din;t know which one to use.......Jet4.0?

Thanks,

Matt.

 

[simian336]

If you just want to play with the data linked tables are the way to go. You will see the tables just like they are native Access Tables.

If you want to just run sql statements against them then you will need to set up some vba programming. Google connection strings.

Simi

 

[mutley1]

thx simi

 

[JoeAtWork]

so just wanthed help with connection strings etc. as I din;t know which one to use.......Jet4.0?

http://www.connectionstrings.com