By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Shifing backend from one server to the other

P: 25
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
Feb 15 '08 #1
Share this Question
Share on Google+
6 Replies


P: 59
in access go

tools > addins > linked table manager

refresh the link directory locations (browse to the new location)
Feb 15 '08 #2

Expert Mod 2.5K+
P: 2,545
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
Feb 15 '08 #3

P: 25
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
Feb 15 '08 #4

Expert Mod 2.5K+
P: 2,545
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
Feb 15 '08 #5

P: 25
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
Feb 15 '08 #6

P: 25
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
Feb 18 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.