Values missing in a networked environment...

[Jim Burke in Novi]

I have an application that is running on a network. One machine has the data
database in an .mdb file (as well as having a copy of the application .mdb
file). Two other machines have coies of the appl running using the runtime
version of access. I have a form that is bound to a table that has various
parameteres that I use in the appl. There are times where this form shows
some of these values to be blank when I know the data is in the bound table.
Any idea why this would happen? I've had some other strange errors reported
to be by users that I haven't been able to duplicate myself, and am wondering
if there is some issue with running this type of environment that could cause
problems. Other functions in the appl seem to keep working fine when these
problems come up. We have the user stop and restart the appl and the problems
seem to clear up. Any help is greatly appreciated!

 

[Barry Gilbert]

I'm not sure if this is relevant, but I've seen weird things like this when
there are network issues. Is this a possibility in your environment?

Barry

 

[Jim Burke in Novi]

It's definitely a possibility that there are network issues (I wondered about
that myself), though I don't know where to begin to figure out if that's the
case. We have two different locations running the appl that are in basically
the same configuration, and only one of them seems to have these types of
problems. I know next to nothing about networks - someone else set them up.
Do you know what the nework issues were in those situations you mentioned?

 

[Barry Gilbert]

I only know one thing about networks: how to call our network team to get
something fixed. The last time we had a problem, it had something to do with
the frammis-switch not de-spunkulating correctly.

The fact that it's isolated to one location is a clue. Beyond that, I
wouldn't know what to suggest.

Barry

 

[Tim Ferguson]

=?Utf-8?B?SmltIEJ1cmtlIGluIE5vdmk=?=

I have a form that is bound to a table that has various
parameteres that I use in the appl. There are times where this form
shows some of these values to be blank when I know the data is in the
bound table. Any idea why this would happen?

My guess is that it's to do with the way that the dynaset (table) is
being opened... strange things can happen when a table is locked. Try:

Unbinding the form. If it's only a set of application parameters, what
putting them into database properties insted?

Reducing the number of records locked: instead of basing the form on the
table, base it on a recordset that has a WHERE ID="SomeValue" criterion
on it.

If they are user data, then put them into a table in the local front end
databases. If they are temporary data, then create a new mdb every time
the app opens and put them there, remembering to delete it on closing.

Just a thought...


Tim F