Hi All,

I am nearing the time that an internal dB has to migrate from ms access to sql server. The server is used by a whole load of VB dll's & progs we have written over a period of years and the sql used within the dll's & VB progs is 'access-sql'. I know of the obvious deference's with access-sql queries such as using #[datevalue]# and that this may or will cause some headaches but I was wondering if anyone else has done this kind of migration or if there where any ms-sql plugins that allow the passing in of access-sql into sql server or something like that. I hope you can offer your experiences, tribes and tribulation or expert advice on this one.

Thanks in advance
Paul