What's with ADO?



Hi,
First thanks for your time to read and maybe respond to this question.
I have a new client with an ADO database on a server being used by
three users. Not split, everyone uses the same one. So I made a copy
of the database, changed the name on the original (as a backup) and set
them up with front ends linked to the back end....Oh my gosh now it
takes 5 minutes to open a form. So I got rid of what I did and put
back there original with the original name. Now the only difference is
that I gave them a shortcut on their desktop that goes to the db on the
server instead of them opening Access directly. I made one fix in a
report "a label was missing" and when I left it was much faster then
the split database.
Now the client calls and says the computers I "worked" on are running
very slow and their db is taking longer to open then before.
I don't know ADO I have always worked in DAO...what could I have
possibly done to their database????? I don't believe I did anything, I
think its perception after they saw the split db work. But I wanted to
ask the experts here if there is any way I may have mucked it up????
I wasn't going to do any heavy work on this db without knowing more
about ADO but I thought what I did was safe.
Thanks,
Debbie

.



Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)