Visual Basic vs. Access - is one better?

[christywarner]

Hi,

I have developed an app in Access 2002, 2000, & 97.
Some of my users are having errors that I am not
seeing on my computer and I think it's version
compatibility issues. My questions to you are:

1) Do you think using Visual Basic instead of Access
is a better solution to a stand-alone Windows
software application?

If Access is fine to use, then:

2) How can I get around the various version issues -
one of them being importing files created in
different Excel versions.


thanks for your expertise!

Christy.

 

[gusset]

can't help with 2. not sure what you mean

nor indeed about the error messages, perhaps you'd let us know what these messages are.

as for 1.
are you on a network? is this the only app using the access database? where is the back end (are they split?) what type of app is it?

are you completely new to vb? access makes developing a database app faster. would it be faster to continue with the app in its existing form if you knew how to solve the error?

 

[snehakevin]

Yes to your first one...

VB is certainly a better choice, you will be using only the data from access, the front end will be VB.

Your second one...

When you import data from excel (of the same format) each time you mark a specified column say 'version no', and increment that number for each import.... there by you can control from which version it has come from...

Hope this is fine..

 

[WJProctor]

From my own personal opinion VB makes its easier as long as you set up the db correctly then it gives you much great scope to work with.

 

[christywarner]

thank you everyone, your tips are helpful.
I think to get around Excel version issues,
I might force users to import their data
via .csv file. Everything has to be automated,
so I'm not sure how I would detect the Excel
version up-front BEFORE the user imports it.
The docmd.transferspreadsheet command requires
an Excel type (acspreadsheetExcel3,4,5,6,7,8,9).

thanks for your help!

christy.