I am a beginner - just to give a warning up front :)
I have a split database on one computer. I need to move the whole database, front and back ends to another computer. When I do, it will not allow me to relink the tables easily. Do I have to change the root path so the front can find the back...and how?? Trying to figure this out for, oh, about 3 days now! Thanks in advance...
5  1798  nico5038 3,080
Recognized Expert Specialist
The easy way is to use the Relink manager under the Tools/Database utilities/Linked table manager menu.
It can be done by code, but this manager does all needed.
Nic;o)
Okay, this is weird. I tried to use the Relink Tables manager since the get-go 3 days ago. It didn't work. It looked like it was relinking it, but it still didn't actually access the back end. It would turn out that when I would open the front end, it said "C://....databasebac kend.mdb is not a valid path."
Then, today, for the heck of it I tried it again. It relinked them just fine. What the heck? Do I have a bug??
Thanks so much for replying, and for giving me the impetus to try it just one more time!!
kc
nico5038 3,080
Recognized Expert Specialist
Sometimes Access does have hickups like this.
It could be a faulty networkcard or other divice. Make sure you have all Service Packs installed and when things like this happen an Office re-install could make sure it's caused by an outside reason.
When installing a .mdb on another PC you should always check the references as they can cause havoc too. Open some VBA code (e.g. a module) and see that there's no checked library under the Tools/References starting with "MISSING".
Success !
Nic;o)
Thank you so much! Got it.
Willing to help with one more question???
Have a field "Picture" in a table. I need to change ONE word within the field across all records, but keep all the other info the same. Update query?
Example:
1/owner/123
1/owner/2354
1/owner/5634
Need to change the word "owner" to "me" in the field across all records.
Thanks in advance for the hours you'll save me :)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: JMCN |
last post by:
Is this possible to have the 97 users with 97 front end, 2000 users
with 2000 front end, 2002 users with 2002 front end, and 2003 users
with 2003 front end all linked up to an access 97 backend?
We are currently planning on upgrading workstations with either 2000,
2002, 2003. the criteria for the specific version will depend on the
IT department. I would like to know if we have several different
office versions will it work to have...
|
by: Tempy |
last post by:
I am not a programmer, but love to dabble with VBA, mainly in Excel, but
I have made an Access data base which is getting a bit outa hand for
me!!
I am using it to display information only; as a project report. I have
three sections that I must report on, namely:
General information
Purchasing issues &
Quality issues.
|
by: DFS |
last post by:
An application I wrote has been deployed on Citrix, and the Citrix admin
tells me all users run the same .mde file. There aren't a lot of concurrent
users, but even 2 could be cause for concern.
I think the use of globals is worrisome in this case. Anybody have any
experience with Access on Citrix?
(Al Kallal already griped me out about globals, but if he has anything new
to add I'm all ears).
|
by: Wavey Davey |
last post by:
Hi All,
My company develops Baggage Sortation systems for Airports. We have our
sortation application running, which is basically a hot standby system with
two machines - One Main, one Standby. The application runs on Windows 2003
server, and consists of several processes, with an Oracle database. The
server application code is mainly written in Visual C++ with MFC and the
system communicates with the external plant and the Oracle...
|
by: lwwhite |
last post by:
Access 2003. I am maintaining 5 almost identical databases (long story). Each of them is split into a back end and front end. While individual maintenance of the back ends is inevitable, I would really like to maintain just one front end that users could use to link to the back end of their choice. The problem is that they would not be comfortable using Access's table-linking function and I would not want them to. I have an Enter Defaults window...
| | |
by: Khriskin |
last post by:
As a warning, I'm self-taught so I have a bad habit of brute-forcing things out of ignorance. I've done some searching online and haven't found a solution, so I figured it couldn't hurt to ask you kind folks if there was a better alternative.
PROBLEM
I have multiple front ends that are updated on an almost daily basis as needs change (or I find problems). I need an easy way to push out new local copies of the front ends to multiple...
|
by: afromanam |
last post by:
Whew..
OK, running access 2003 in win xpsp2 and access 2007 in win vista.
This is the question...
We have a db, split in front end (FE.mdb) and backend (BE.mdb)
FE has tons of linked tables from BE.
|
by: zmickle |
last post by:
Excuse my noobness. I am managing an access database that is shared
by 4 users. Management does not want to use any technologies outside
of access for this application (no SQL Server, etc). I have split the
database into front end and back end databases and put the front end
on each of the users' computers. All users can open the front end
simultaneously, but once somebody updates data in the form, the back
end locks up.
What I...
|
by: mjvm |
last post by:
Hi,
My database (Access 2003) is split with the back end on the server and each person with a front end that is linked. Over time the computers/laptops are being replaced and almost everyone is on 2007.
I have read some of the earlier posts which advised holding off converting to 2007, but they were old and my first question is - should I be converting the database over?
If the answer to that is yes, can I convert the back end, and...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
