Access and SQL Server
Wow, one whole post in the month of March. The month really sucked.
Anyway, I have been living a nightmare what I call Microsoft Access. What a scourge that product is. I was hired to perform an intermediate upgrade from Access 2000 to SQL Server 7. I have done this a few times, with pretty good success. After looking at the database, it was quite clear that linked tables would be best until a full upgrade to SQL Server could be performed.
Well, that just isn't how it worked out. First, the upsizing tool in Access 2000 sucks. I understand that most of the time objects and syntax can't directly be translated. But instead of giving me the opportunity to fix this during the upsize, it just bypasses the whole thing. What the ...
In any case, after realizing that the only real long term scalable solution was to fully move the database to SQL Server 7, the Client agreed and we are moving that way. So, I will find it very unlikely I will do another 'interim conversion'. It's all or nothing baby.
Thom