Not at all. I keep a single ADO connection object open to use through the
entire system. I have scripts that create the class modules and the form
code - all of it including navigation buttons - so the form is ready to use
in two minutes. All I do is give the table name and some other basic info
and 95% of the code is done in 30 seconds. There is always a little
tweaking. The business logic is all handled in one validte function.
That's the only real code I have to write.I have a front end in Miami and a
back end in New Jersey. It was taking 5 minutes to retrieve a record, now
it takes 5 seconds. (Yes I know there's a network problem somewhere, but
this is a Johnson & Johnson comapny so I can't mess with it.)
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:K7********************@adelphia.com...
Hi, Matthew.
Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.
And do as good a job as the database engine at handling record locks,
write conflicts, and guaranteeing referential integrity? That's a lot of coding
to gain marginally faster speed compared to retrieving a single bound
record from the table. But having a bound form open with only record isn't
always feasible in every application, so an unbound form that handles one record
at a time is a viable alternative. It's just a lot of work to get it right
when the business logic side is doing the work of the database engine.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:D8*******************@newsread3.news.atl.eart hlink.net... Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote
in
message news:Ar********************@adelphia.com... Hi, Matthew.
>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.
Have you considered binding the form to a query that retrieves only one
record at a time, not the entire table?
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and
tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...
>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.
>
> "Keith Wilby" <he**@there.com> wrote in message
> news:44**********@glkas0286.greenlnk.net...
>> "Matthew Wells" <MW****@FirstByte.net> wrote in message
>> news:zy*******************@newsread3.news.atl.eart hlink.net...
>> > Hello.
>> >
>> > I've converted a bound Access 2000 form which displays data
>> > retrieved
> from
>> > an Access 2000 database to an unbound form. Now my hyperlinks
don't > work.
>>
>> Am I missing something here? How do you expect an unbound form to
>> display
>> data? Is is bound at run-time by using VBA/SQL queries? Can you
give > more
>> info?
>>
>> > I'm assuming it's because the form isn't bound anymore. I didn't
even >> > have
>> > that field's data type as hpyerlink - just test.
>>
>> Test?
>>
>> > I did have the form
>> > control's "hyperlink" property set to true and it worked fine in
bound >> > mode.
>>
>> As you'd expect it to, yes.
>>
>> > The fields stores paths to pdf files. How can I make the
hyperlink >> > work
>> > in
>> > an unboud form? (Going back to bound is NOT an option).
>> >
>>
>> As I say, unless I'm missing something (which is distinctly
possible) >> it's
>> not gonna happen. Why do you need to have the form unbound?
>>
>> Keith.
>> www.keithwilby.com
>>
>>
>
>