Unable to open Database

A

ali_dba

Dear All,

After changing the location of Access 2000 datatabase from a windows nt 4.0
server to Win 2003 server, i am facing a problem fetching data from the
database, i am unable to only fetch data but able to open the switchboard -
means no user rights problem, but i am unable to fetch data, shows an error
that the databse is exclusively locked or you dont have rights for it, here
the reference is made to my old server for the location of data.

Assist pls
 
A

Alex White MCDBA MCSE

First thing to check is the file and share permissions on the Windows 2003
server, as the permission structure of Windows 2003 is the reverse of all
OS's before it.

All OS's before Windows 2003, share = full control, files = full control
these are the defaults.
Windows 2003 share = read only, files = read only, if copied to the server.

Is your database Split Front-End / Back-End because

"here the reference is made to my old server for the location of data."
sounds like your database is split front-end and back-end and the front-end
paths for the linked tables has references to your old server.
 
A

Arvin Meyer

1. Make sure that the users have full modify rights to the folder on the
server. If they can't create and delete the LDB file, they will not be able
to use the data except one at a time.

2. Assuming that your database is split and only the data itself resides on
the server, (the preferred design to avoid corruption) you will need to
relink the tables. To do that go to Tools ... Database Utilities ... Link
Table Manager.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
A

ali_dba

Hi Alex,

How do i now change the refenreces to the new locations, is there a way around

Ali
 
A

Alex White MCDBA MCSE

If this is your problem, then in the database windows viewing the tables,

all the linked tables are the ones with arrows to the left hand side, just
try to double click one of the tables just to make sure that is the problem,
you should get an error.

if you do get the error then you can delete all the LINKED tables (good idea
for a backup before doing this), once done click on file/get external
data/link and relink all your tables.

Give it a go, and remember to backup first before you do anything.....
 
Top