Linked tables problem

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hello,

I have a database which has the front end loaded on to
three PC's and the back end on one of them, accessible to
the other two via a network. The db with the tables on
the PC works fine. However, the ones linked via the
network are a nightmare. Controls do not display on some
forms, error messages appear when certain macros are run,
and when closing some forms an error message appears that
says "Cannot delete tables" when nothing is to be
deleted. Many forms display only the records already
entered, and do not display blank fields to enter new
records. Can anybody explain to me what is going on, and
provide some direction so I can fix it? Thanks in
advance to anyone who replies.
 
Sounds like you do not have the necessary share permissions needed on the
backend part of the database. The backend database needs
Read/Write/Modify/Change (Full Control). This may be against the Everyone
selection or if you can place NT type permissions then give only those
authorized the Full Control and give Everyone Change/Read.

Another possibility is the front-end on the other machines are missing
references that are needed in order to run correctly. Open the database on
the user's machine and hold down the Shift key until the database opens.
This bypasses any startup functions when the database opens. Once open click
on any form and then click the 'Code' icon on your toolbar
(aqua/yellow/red). This will open you up into the Code Editor window of
Access. Select Tools | References. Look for 'MISSING' against any reference.
You will need to find and reload this reference into the window. Many of the
missing references can be found by scrolling down the list. In some cases
you may have to register the missing reference using regsvr32.exe
 
Thanks very much for the direction. I had suspected it
was some kind of permissions problem, but wasn't sure
exactly what.
 
Back
Top