Web Development

Ask something
Discussion Locked

VB Prog. Ussing access convert to SQL

0 helpful
3 replies

by ereyes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I have a question how difficult or easy would it be to migrate an application written in Visual Basic using an Access Database to use MS SQL instead? The present application is using Access 95 but it's getting too big and I really want to transfer it to a MS SQL database instead but I don't know what type of problems the Visual Basic Program that it's using it will give me, is this something feasible or should I not attempt it, I'm very green with VB.

3 replies

by nikki96

It depends on how the program was written.
If the programmer used datasources, a .udl (data link file), and ODBC, it's pretty easy.
If they did all the connections and such in the code itself, it's a bear. In fact, it was such a bear that now I always use datasources, udl file, and odbc.

HTH

This discussion is closed to new replies.