Quote:
>Hi,
>I have given a job that requires developing a VB application using Microsoft
>Access2000 and at will be operate in a local workstation for time being. But
>in the future, customer wants to upgrade to SQL server and also he wants to
>be able to use this application on the internet. Could you please explain to
>me Which issues I must be aware of when I develop this application. I have
>no VB experience other than creating simple forms. Please help if you can.
>Thanks
There are some variations in the SQL syntax between Jet and SQL
Server. Since you are planning to switch the backend, you should
design your app so that it is easy to change the SQL syntax when you
make the switch.
You may also want to design the app as an n-tier application so that
the data access layer is encapsulated. This will allow you to change
data access schemas without having to make changes to the code in your
frontend.
HTH,
Bryan
____________________________________________________________
New Vision Software "When the going gets weird,"
Bryan Stafford "the weird turn pro."
Microsoft MVP-Visual Basic Fear and Loathing in LasVegas