Building a scalable vb application...

[jonohara]

I'm about to begin writing an app which will initially be distributed with an access mdb file. I want to avoid having to write the application all over again when in a year or so I'll need the app to be true client/server (SQL_Server).

It is possible to write 'decent' apps which can simply switch between Access and SQL-Server without major changes?

thanks

 

[binky]

What about saving your connection string to an .ini file? That way you wouldn't have to make any changes in the App when you switch over to SQL.

Just an idea,
Binky :
><>

 

[zemp]

I would make sure to use data access tools that are compatible with both, I would recommend ADO. Also make all connection strings, and Access specific information, variables. Feed your variable from a resource file so that when you go to convert you will only have to update the information in one place. Thanks and Good Luck!

zemp