Reasons for VB versus Access

[Kenln]

I do not mean to ask a foolish question.

However are there any clear reasons to use VB over Access?

I am using MSSQL Server as our backend and tend to have A LOT of views, tables and sometimes even stored procedures.

However I also tend to have local tables and queries for speed.

I appreciate you help,

 

[namliam]

VB is much more secure with code than Access is...
Access is dependant upon it beeing there (runtime or full), while VB can run a full standalone exe
VB will take a little longer to develop I think vs access which is a little easier (might be cause I use access much more)

By no means do I imagine this to be all ... but above is a starter...