VB Prog. Ussing access convert to SQL

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.