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" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SP AM> wrote in
message news:K7ydnQ0r0cVRULfZRVn-gA@adelphia.com...[color=blue]
> Hi, Matthew.
>[color=green]
> > Unbound forms are faster in all cases. I have calss modules that handle
> > all
> > the data verification and updating.[/color]
>
> And do as good a job as the database engine at handling record locks,[/color]
write[color=blue]
> conflicts, and guaranteeing referential integrity? That's a lot of coding
> to gain marginally faster speed compared to retrieving a single bound[/color]
record[color=blue]
> from the table. But having a bound form open with only record isn't[/color]
always[color=blue]
> feasible in every application, so an unbound form that handles one record[/color]
at[color=blue]
> 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" <MWells@FirstByte.net> wrote in message
> news:D8yWf.11410$k75.10455@newsread3.news.atl.eart hlink.net...[color=green]
> > Unbound forms are faster in all cases. I have calss modules that handle
> > all
> > the data verification and updating.
> >
> > "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SP AM> wrote
> > in
> > message news:ArydnePS8brLN7fZRVn-rQ@adelphia.com...[color=darkred]
> >> 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[/color][/color][/color]
tutorials.[color=blue][color=green][color=darkred]
> >>
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> >> info.
> >>
> >>
> >> "Matthew Wells" <MWells@FirstByte.net> wrote in message
> >> news:5mxWf.11484$sL2.3303@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" <here@there.com> wrote in message
> >> > news:442a9986$1_1@glkas0286.greenlnk.net...
> >> >> "Matthew Wells" <MWells@FirstByte.net> wrote in message
> >> >> news:zywWf.11389$k75.10881@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[/color][/color][/color]
don't[color=blue][color=green][color=darkred]
> >> > 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[/color][/color][/color]
give[color=blue][color=green][color=darkred]
> >> > more
> >> >> info?
> >> >>
> >> >> > I'm assuming it's because the form isn't bound anymore. I didn't[/color]
> > even[color=darkred]
> >> >> > 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[/color]
> > bound[color=darkred]
> >> >> > mode.
> >> >>
> >> >> As you'd expect it to, yes.
> >> >>
> >> >> > The fields stores paths to pdf files. How can I make the[/color][/color][/color]
hyperlink[color=blue][color=green][color=darkred]
> >> >> > work
> >> >> > in
> >> >> > an unboud form? (Going back to bound is NOT an option).
> >> >> >
> >> >>
> >> >> As I say, unless I'm missing something (which is distinctly[/color][/color][/color]
possible)[color=blue][color=green][color=darkred]
> >> >> it's
> >> >> not gonna happen. Why do you need to have the form unbound?
> >> >>
> >> >> Keith.
> >> >>
www.keithwilby.com
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>[/color]
> >
> >[/color]
>
>[/color]
