by George Papaioanno » Wed, 06 Nov 2002 21:58:51
Now I have to create a lighter version of the application, and instead of
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?
by Tore » Thu, 07 Nov 2002 13:24:06
Why not use MSDE instead - it should be SQL Server compatible.
HTH,
Tore.
Quote:> I have created an application with VB 6.0(SP5) and SQL 2000 using ADO 2.6.
> Now I have to create a lighter version of the application, and instead of
> 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?
by George Papaioanno » Thu, 07 Nov 2002 17:47:30
So is there any info, which char I have to change to the statements in order
to work with Access 2000?
> Why not use MSDE instead - it should be SQL Server compatible.
> HTH,
> Tore.
> > I have created an application with VB 6.0(SP5) and SQL 2000 using ADO
2.6.
> > Now I have to create a lighter version of the application, and instead
of
> > 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?
by Willia » Fri, 08 Nov 2002 01:25:40
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.
William
>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.
>> HTH,
>> Tore.
>> > I have created an application with VB 6.0(SP5) and SQL 2000 using ADO
>2.6.
>> > Now I have to create a lighter version of the application, and instead
>of
>> > 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?
1. How to convert a Access 95 program to Access 2000 program
Hi, everybody
I have a Access 95 program written in VBA. I can't run it any more
since my computer has only Access 2000. How to make it run in Access
2000. This old program has some code like "Dynaset" and
"Forms!Users!Access". Should I rewrite the whole program in order to
run it in Access 2000? It looks to me that Access 2000 is using not
only different library, but also the language is a little bit
different. What's the best solution with this situation.
Thanks!
Xiaohang Zhu
2. seeking Database versioning tool
3. Convert Access 2000 to Pervasive.SQL 2000
4. US-CA-SOFTWARE DEVELOPER * 8XP-00-120
5. Converting Access 2000 DB to SQL Server 2000
7. Converting VB functions in Access 2000 to SQL Server 2000
9. Converting from SQL 7 on NT box to SQL 2000 on Windows 2000 new box
10. Upsize Access 97 to SQL 2000 without SQL 7 or Access 2000
11. Converting sql queries for Access to SQL Server 2000
12. Converting Access SQL to SQL 2000
13. Access to access 2000 mdb by access 97 program via VB6 and ADO