reports not opening in Multiuser MsAccess2003

I have 3 tables, and I split them to a central PC , so the users are using
only the front end via MDE.

These tables are being updated from the end-user using a form that logs them
in and then update their daily tasks (what they achieved every day)

For me as administrator I have a problem in opening the Reports, if the users
are working at the same time, i cannot open the reports it gives me the
following message:

"The database engine could not lock table 'LoginTable" because it si already
in use by another person or process."

The reports would never work unless all the users shuts down their forms,
which is impractical

Hope if i can find a solution for that

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200912/1

time_racer via AccessMonster.com wrote:

I have 3 tables, and I split them to a central PC , so the users are using
only the front end via MDE.

These tables are being updated from the end-user using a form that logs them
in and then update their daily tasks (what they achieved every day)

For me as administrator I have a problem in opening the Reports, if the users
are working at the same time, i cannot open the reports it gives me the
following message:

"The database engine could not lock table 'LoginTable" because it si already
in use by another person or process."


That is not normal, something about the reports must have
done something to require exclusive access to the table.
Why does the table need to be locked?

--
Marsh
MVP [MS Access]

I am not sure yet about that, but the reports are working just after they
close all their forms!!!

if you need any information about it please tell me so I would provided to
you , ( vba, properties, communication scenario,...)



Marshall Barton wrote:
I have 3 tables, and I split them to a central PC , so the users are using
only the front end via MDE.
[quoted text clipped - 8 lines]
"The database engine could not lock table 'LoginTable" because it si already
in use by another person or process."

That is not normal, something about the reports must have
done something to require exclusive access to the table.
Why does the table need to be locked?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200912/1

Maybe you can figure out why the table needs to be locked if
you can find some code in one or more forms that does
something unusual with the table, possibly through a
recordset.


time_racer via AccessMonster.com wrote:
I am not sure yet about that, but the reports are working just after they
close all their forms!!!

if you need any information about it please tell me so I would provided to
you , ( vba, properties, communication scenario,...)


Marshall Barton wrote:
I have 3 tables, and I split them to a central PC , so the users are using
only the front end via MDE.
[quoted text clipped - 8 lines]
"The database engine could not lock table 'LoginTable" because it si already
in use by another person or process."

That is not normal, something about the reports must have
done something to require exclusive access to the table.
Why does the table need to be locked?
--
Marsh
MVP [MS Access]