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