MS Access -vs- Visual Basic Whats better?

[Cleis]

Hi Group:

For the fisrt time in 6 years I've run into a developemnt issue that I cannot address using Acesss 97 although I could using Access 2000; Data Access Pages. Unfortunately my company has no plans in the near future to upgrade everyone from 97 to 2000. This has got me thinking about upgrading my skills to include VB6 however I'm somewhat hesitant for a couple of reasons:

1. I've never taken courses nor am I an I.T person. It's taken 6 long years of knocks and blood sweat and tears to learn Access to a point of being pretty effiecient. I've mastered every object within Access execpt coding. My coding skills are well above that of an average user but no near that of an someone schooled in programming lanuages. For me it's sometimes a struggle. So my question is how hard is it to pick up VB6? The VB6 enviroment seems similar?

2. Most of my work is transactional based types of databases. I'm either using Client Express to pull data from the AS/400 or I'm developing stand alone types of applications; nothing more. This being said, is it really neccessary for me to go to VB?

3. In short what are your thoughts of VB6 vs Access 97?

 

[gwinn7]

I am faced with a similar issue, except moving to VB6 is more of a requirement than an option. What I have found so far is that its not that difficult. The nuances may cause a bit of sweat, but not too bad. Things like the "docmd" object and the Access "Tab Control" you will have to get use to doing without. A nice thing about going to VB6 is you can create your own collection classes and use the For Each statement with them.

Well, I don't know how helpful I have been, but I hope its contributed to your decision process.

 

[Saintor]

I guess it is not an universal solution... but possibly FrontPage might be the answer. I have learnt coding within Access and it really does a good job (more for ACC97 than ACC2000).

I just took the FP route lately and I am very pleased with it. There are limitations like user level security. Same thing as Access Data Pages.