hiya,

in the meantime i found a differnt way to do what I hope I need without using DTS.

ta for the advice though, i'm sure it'll come in handy

yogi...

hiya,

have a look at the sqlServer conn strings here.Maybe there is one for you:

http://www.connectionstrings.com/

cheers for the honest words Francis.

The reason for my post was that I haven't done any db sync stuff before, So I thought that I'd ask and see if there...

cheers Dan.

yogi

this might help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=190719#bm191205

yogi

righto,

I have version 9.00.1116.00.I'll look for a later CTP.

yogi

thanks for taking the time folks..great suggestions.I only need for a single project, so I'll try and persuade mr budget for the "find and replace".

cheers all,

yogi

cheers Chris,

I've got the remote connection working now.

tak,

yogi

hiya,

Exactly... I'm unsure of how to connect using SSMS .

I'm trying to connect:

1) TO sql2k

2) FROM sql2005 CTP 9.00.1116.00

I have noticed that there is such a thing as sqlnativeClientConfiguration -->...

hiya,

The USB probably only had "readonly"acccess to the data file.I suspect that:

1) the datafile is still on the USB (and therefore "readonly")

2) OR, you have copied the datafile from...

cheers martin,

I'll give it a go.

yogi

righto, thanks for taking the time.

I hope I didn't come across as being lazy.I was looking for an approach to do this so that that I could "re-use" this approach in...

hiya,

So I just have to copy the entire app over?

If someone can reply, even to confirm that this is the case, then that'd be much appreciated.

cheers,

yogi

cheers,

I always have to fight the urge to do this thru the gui

yogi

cheers Phil.

Access = hassle...It took me an age to find the proplus.msi so that I could install the tableAnalyser wizard 🙁

Anyway, i am now clunking away in Access in the...