error message after installing on network

[jim]

I have designed a medium size (10mb) Db in Access Xp. It
holds about 3000 records in a main table and maybe 5000
associated records in other tables. The Menus are on
Forms rather than a switchboard. When I run it on my
local Pc it runs sweetly and perfectly.
I have installed it on a server (F) drive wher it is
being accessed by three or four users, who edit, add and
adjust the records. The database has not been split to a
front end/back end setup, nor has it been replicated. I
rely on the fact that it is modest in size, and doesnt
normally have heavy traffic.......expecting it to
function in the circumstances.It is also running on a
shared basis.

I have set it to compact and repair automatically as the
user exits.....
A number of problems have arisen, the two most important
being (1)that the interface between the menu forms and
the database object has completely failed on two
occasions with the message "Module not found"....I did
not place any event code in modules to activate the menu
buttons....I just connected the buttons using the wizard
from the toolbox........what is causing this???

Problem (2)
When I attempt to compact and repair either manually or
automatically, or sometimes when just closing the
database I get an error message "Table
TempMSysAccessObjects already Exists OK/Help"......This
is not a table any user created......I cannot see it, and
the DB has grown in size by maybe 4mb......The compact
and repair pprocess will not now work......What is
causing this error and how do i ELIMINATE it please???

Perhaps the problem is to do with the network or the
network configuration The network is running on Ms
Windows 2000 server

Any advice appreciated

Jim
..

 

[Allen Browne]

Split the database, so that each user has their own copy of the front end.

Turn off Compact On Close. It will not be useful, since the data is not in
the front end now.

Access does not work anywhere near as well with multiple users all trying to
use the same file, and if other users are logged in and using the database,
it makes no sense to try to compact on close.