Microsoft Access Secrets?

[rmccall@dss.state.sc.us]

I built a number of Microsoft Access programs in Access 2000. We are
trying to use them now in Access 2003.

I have split the programs and configured them as SHARED in edit mode.
I have tried no locks and edit modes.

I set the frontend on the workstation and the backend on the server
drive that is shared.

What is the problem with them still freezing when multiple users try to
do data entry.

Very frustrated with this application as this never happened to me with
Lotus Approach.

If there is anyone out there that can help me with this I would really
appreciate your expertize.

[Keith W]

Re: Microsoft Access Secrets?

<rmccall@dss.st ate.sc.us> wrote in message
news:1132067069 .421748.256670@ z14g2000cwz.goo glegroups.com.. .[color=blue]
>
> I set the frontend on the workstation and the backend on the server
> drive that is shared.
>
> What is the problem with them still freezing when multiple users try to
> do data entry.
>[/color]
Does each user have their own copy of the FE?

Keith.

https://www.keithwilby.com

[rmccall@dss.state.sc.us]

Re: Microsoft Access Secrets?

Yes. I have set up a separate folder on their C drive and copied the
frontend on each work station.

[Fred Boer]

Re: Microsoft Access Secrets?

Do users have *full* (read, write, delete) permissions for the folder in
which the back end is stored?

HTH
Fred Boer

<rmccall@dss.st ate.sc.us> wrote in message
news:1132067069 .421748.256670@ z14g2000cwz.goo glegroups.com.. .[color=blue]
>I built a number of Microsoft Access programs in Access 2000. We are
> trying to use them now in Access 2003.
>
> I have split the programs and configured them as SHARED in edit mode.
> I have tried no locks and edit modes.
>
> I set the frontend on the workstation and the backend on the server
> drive that is shared.
>
> What is the problem with them still freezing when multiple users try to
> do data entry.
>
> Very frustrated with this application as this never happened to me with
> Lotus Approach.
>
> If there is anyone out there that can help me with this I would really
> appreciate your expertize.
>[/color]

[rmccall@dss.state.sc.us]

Re: Microsoft Access Secrets?

Yes.

[Larry Linson]

Re: Microsoft Access Secrets?

Are you keeping a connection to the server open all the time?

Have you indexed the tables, and built your queries to take advantage of
those indexes, retrieving just the records you need?

Interesting -- data entry (of new records) is not where I'd expect to find a
problem. It would be updates of existing records that I would ordinarily
suspect.

Did you look at the performance tips and hints at Tony Toews' site
http://www.granite.ab.ca/accsmstr.htm? That's the best collection of
information and links on the subject that I know about.

Larry Linson
Microsoft Access MVP

<rmccall@dss.st ate.sc.us> wrote in message
news:1132067069 .421748.256670@ z14g2000cwz.goo glegroups.com.. .[color=blue]
>I built a number of Microsoft Access programs in Access 2000. We are
> trying to use them now in Access 2003.
>
> I have split the programs and configured them as SHARED in edit mode.
> I have tried no locks and edit modes.
>
> I set the frontend on the workstation and the backend on the server
> drive that is shared.
>
> What is the problem with them still freezing when multiple users try to
> do data entry.
>
> Very frustrated with this application as this never happened to me with
> Lotus Approach.
>
> If there is anyone out there that can help me with this I would really
> appreciate your expertize.
>[/color]

[Trevor Best]

Re: Microsoft Access Secrets?

rmccall@dss.sta te.sc.us wrote:[color=blue]
> I built a number of Microsoft Access programs in Access 2000. We are
> trying to use them now in Access 2003.
>
> I have split the programs and configured them as SHARED in edit mode.
> I have tried no locks and edit modes.
>
> I set the frontend on the workstation and the backend on the server
> drive that is shared.
>
> What is the problem with them still freezing when multiple users try to
> do data entry.
>
> Very frustrated with this application as this never happened to me with
> Lotus Approach.
>
> If there is anyone out there that can help me with this I would really
> appreciate your expertize.
>[/color]

Was the 2000 version split? If so did this performance hit occur there
as well?

[summerwind]

Re: Microsoft Access Secrets?

I had a problem similar to this once where I was picking up on someone
else's work.

I found that the problem in my case was the connection to the data and
that all of the forms etc in the app were bound to underlying tables.

Solution was to use unbound forms and rewrite considerable amounts of
code so that minimum data was transferred over the network at any one
time.

After I had finished I concluded it would have been quicker to re-write
the whole app!!!

[David W. Fenton]

Re: Microsoft Access Secrets?

"summerwind " <summerwind.sof t@btinternet.co m> wrote in
news:1132153702 .831933.24040@g 44g2000cwa.goog legroups.com:
[color=blue]
> I had a problem similar to this once where I was picking up on
> someone else's work.
>
> I found that the problem in my case was the connection to the data
> and that all of the forms etc in the app were bound to underlying
> tables.
>
> Solution was to use unbound forms and rewrite considerable amounts
> of code so that minimum data was transferred over the network at
> any one time.
>
> After I had finished I concluded it would have been quicker to
> re-write the whole app!!![/color]

How idiotic.

Binding the forms to filtered recordsets of one or few records would
probably have gotten you 99.99% of the performance that going
entirely unbound got you, without losing all the events that bound
forms/controls have by default (and which need to be replicated in
some way in an unbound form).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc