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
6  1558 
in access go
tools > addins > linked table manager
refresh the link directory locations (browse to the new location)
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
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
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
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
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Socheat Sou |
last post by:
After a brief, but informative, discussion on Freenode's #zope
chatroom, I was advised to consult the gurus on c.l.p.
I'm working for a small company who is in desperate need to rewrite it's...
|
by: Krishna Prasad |
last post by:
Hello,
I am in the process of designing the following kind of system --
A MySQL database holds hundreds of thousands of entries. All of these
entries are periodically processed by a set of...
|
by: Brett |
last post by:
I've been developing in CFMX with an SQL Server 2000 backend. For cost
reasons, I want to switch to a different database. I'm also moving away
from CFMX to ASP.NET. There are quite a few...
|
by: Ulrich Wisser |
last post by:
Hi,
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
|
by: Beowulf |
last post by:
I'm working on upsizing an application from MS Access MDB -> MDB backend
to MS Access ADP -> SQL Server backend. The application has the ability
to create a new, empty database.
Right now all...
|
by: ShyGuy |
last post by:
Is there a simple way to allow someone to access a backend on my
computer with another person over the internet?
|
by: Mark 123 |
last post by:
I just read at
http://groups.google.com/group/microsoft.public.access.forms/browse_frm/thread/766ba7b493eacb63/8a7d5504ee848c21?lnk=st&q=migrate+access+97+to+access+2007&rnum=1#8a7d5504ee848c21...
|
by: Jim Devenish |
last post by:
I wish to copy a table on a SQL Server backend to a table on an Access
(.mdb) front end in the simplest way.
I have the following to get the recordset but am seeking something
easier.
Dim...
|
by: bg_ie |
last post by:
Hi,
My company's backend is located at a location with a long address,
something like -
//our_servers/server_number_one/our_department/our_devision/
our_results/our_databases/backend.be
I...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
