Wednesday, March 21, 2012

migrate msjet to mssql server

hi, i already have a project in vb6 / msjet 3.5 using dao methods .index .seek , ... I want to convert it to sql , is there a fast way (! converting .index .seek to select...where clauses is time consumming issue) plse reply since the package is already running and i am really desperate to the conversion.

many thanks and appreciation
amatouriI'm afraid you'll have to go through the pain of taking all this DAO s$%t out. And while you're at it, do yourself and those who'll come later a favor, - take out .Add/.Edit/.Update as well, - very nasty stuff, and while being a very lazy way to code, yields a very paiful and weekendless life for your DBA...

No comments:

Post a Comment