Re: VB6 Expert, DB (Access) Dumb*** (PAYBACK TIME FOLKS!!!)

From your postings I thought you already were an expert. I think I even remember you posting in this newsgroup like 5 or so years
ago? Anyway, I'm sorry for not answering your question but you got me curious when you mentionned Access 2003.

I use VB5 which comes with DAO3.5. At one point I noticed that I could also reference my projects to DAO 3.6 --- this was perhaps
after I installed other software such as Office. In any case, my VB5 apps with DAO3.5 created mdb files that were recognized by
Access as Access95 (or Access97) files - I can't remember which? But anyway, at one point I decided to reference my project to
DAO 3.6 and I noticed that my VB5 apps would create a mdb file that Access would now recognize as either 97 or 2001 - not sure which
one but I know it was a more recent version. Although I tried this, I found that my controls would no longer respond properly to
changes made in the database. It would take between 2 and 10 seconds to reflect a change. I remember programming a refresh button
and I'd keep clicking it until the control finally did update. This being a major drawback, I figured that with VB5 I was stuck
with DAO 3.5 and thus my databases could not be used in Access 2003. I had also figured that anyone using VB6 would be limited to
mdb files that could only be used by Access 2001. Following that logic, I also assumed that you needed VB.Net to create databases
that could be recognized by Access 2003.

Is this true? Or is there a way for my VB5 apps to create the latest mdb files?

Guy


<neilanessa@xxxxxxx> a écrit dans le message de news: 1139450981.267312.149260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hey folks, Neila here ;-)))
After screwing around with MS Access for the last week or so (fixing
a predecessor's app),
I have come to the profound insight that Access TOTALLY SUCKS!!! I
have decided that its
crippled completely LAME approach to User Interface (actually within
most of VBA) will cause me to become hairless before too long. I have
searched for examples on how to
use an Access database from VB6 without finding alot of good examples.
All I need to
do is connect to my an mdb file, snag the crap from a Table, do abit of
mojo and possibly
update a field or two in several records. I do not care to use a data
control or screw around
with any of the automagical bull*** which Access does. Anyone out
there have a link to VB6 (sp6) doing the dirty deed with an Access data
base (Access 2003 from Office 2003 if it matters)... I will dig around
in my many book references when I get home later... For anyone
new on this ng who may not recognize Neila, do a google and you will
see I have answered
probably thousands of questions in this newsgroup in the past (so don't
drop me any flame or nasty BS cause it will come back to haunt you).
So, now's your chance to balance some of the Karma by dropping me some
good info!!!
Thanks in advance,
Neila
I'll bet a bunch of you are laughing your asses off cause I can't seem
to figure this one out (too late in the day - I just installed VB6 on
this machine an hour ago... I'd stick with
access, but the UI is so pathetic that I just want to throw my PC out
of the window!).
I mean for crying out loud, I have to use the freaking API to access a
$%%^ing common
dialog control (Whoever designed this crap should be shot after being
drawn and quartered).
Next month I'll be a database expert!!!!



.