Access linked databases and Windows server 2008

J

jsrogol

I have 2 Access 2003 databases that are linked together. Each db has a table
linked to the other. (example: database 1 is linked to database 2 by one
table and then database 2 is linked to database 1 by a different table). They
worked fine running on a free standing computer with both db in the same
directory.

However when they were added to a server running Server 2008 they no longer
do. When you opened one of the databases and relinked the table, the database
doesn't want to shut down properly and hung the server. You then lose the
share and crash the server. I did this twice today! I didn't make to many
friends today to say the least when this happened!

I have put the databases back on the free standing computer but that doesn't
solve the problem. (After all why have a server if you can't put the data
there.) Is the problem that there are 2 links? I can't test when there is no
one in the office-I don't have access after hours.

Any suggestions? I couldn't figure out a better place to post this question.
Thanks for any advice
 
A

Arvin Meyer [MVP]

Only the data backend should be on the server. The front-end needs to be on
each workstation which accesses the data. Also make sure that you have
permissions for everyone accessing the database back-end, including delete
permissions so that the LDB file can be deleted.

Change the way everything links. All links should be from the front-end to
the back-end. Reciprocal links should not work.
 
J

jsrogol

Thanks I sort of figured that out. Will need to make a few changes to the
database. However the server crashed today and is no longer working (software
issue-memory dumps and lockup!). I think that is a record-worked for 3 days.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top