Shifing backend from one server to the other

[bowtie]

I would like to shift the backend of my access database from one server to the other,so i tried importing the backend tables from the current server to the new server ,but its now failing to link with the frondends ,is there a way i can do this or i start creating the backend tables afresh or wat??
pliz help

[blad3runn69]

in access go

tools > addins > linked table manager

refresh the link directory locations (browse to the new location)

[Stewart Ross]

I would like to shift the backend of my access database from one server to the other,so i tried importing the backend tables from the current server to the new server ,but its now failing to link with the frondends ,is there a way i can do this or i start creating the backend tables afresh or wat??
pliz help

Hi Bowtie. There should be no need to do anything to your backend database, but you will need to refresh the linked tables on the front-end databases, because all of these are now pointing at the wrong location. From the database window on the front-end DB choose Tools, Database Utilities and Linked Table Manager, select the tables that are to be relinked, then select the new location.

Cheers

Stewart

[bowtie]

Hi Bowtie. There should be no need to do anything to your backend database, but you will need to refresh the linked tables on the front-end databases, because all of these are now pointing at the wrong location. From the database window on the front-end DB choose Tools, Database Utilities and Linked Table Manager, select the tables that are to be relinked, then select the new location.

Cheers

Stewart

yah i did that ,but when opening the database there is a message coming at the bottom that the recordset is not updatable ,and actualy one of the forms is not updatable but whaen i return the link to the original server this problem seizes to occur .wat cud be the problem

[Stewart Ross]

yah i did that ,but when opening the database there is a message coming at the bottom that the recordset is not updatable ,and actualy one of the forms is not updatable but whaen i return the link to the original server this problem seizes to occur .wat cud be the problem

Since its OK on the previous server, I think it is more likely that your access rights to the DB on the new server do not allow read/write access, and you are opening read-only (hence no form update allowed). Could be wrong, but I doubt if this is an Access issue at all.

-Stewart

[bowtie]

Since its OK on the previous server, I think it is more likely that your access rights to the DB on the new server do not allow read/write access, and you are opening read-only (hence no form update allowed). Could be wrong, but I doubt if this is an Access issue at all.

-Stewart

okay let me try playing around with it

[bowtie]

okay let me try playing around with it

i saw somewhere in the forum ,where the issue of .mdb recordset not being udateable but i really can not link the solution to my problem of shifting changing servers,coz there were talking about importing any table and updating any recordset ,but i am not getting it,so can anyone explain this to me ,that is if it applies to my problem