On Wed, 6 Nov 2002 10:47:30 +0200, "George Papaioannou"
I don't recall any tool. You are going to have to bite the bullet and go
through your SQL and look for non standard functions, etc.
>Because these are the direct orders from the Upper Levels.
>So is there any info, which char I have to change to the statements in order
>to work with Access 2000?
>> No, MS has an "upsizing" tool, but not a "downsizing" one.
>> Why not use MSDE instead - it should be SQL Server compatible.
>> > I have created an application with VB 6.0(SP5) and SQL 2000 using ADO
>> > Now I have to create a lighter version of the application, and instead
>> > SQL 2000, I will have to use Access 2000 as a database.
>> > I have exported the SQL database into Access, but when I'm starting the
>> > program I'm receiving errors, from the select statements of the ADO.
>> > I now there are some differences between SQL and Access statements.
>> > Is there a tool or a table to help me make the conversions?