Hi,
I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.
I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.
I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.
Any suggestions please?
Rgds
Stuart
1 1895
Hi,
I need to change a field name in a table stored on a backend database that is used by various queries, forms, etc on the front end client via a linked table.
I can't work out how to change the name in the b/e without having to change all the individual references to it in the f/e.
I haveauto name correct turned on in both f/e and b/e but I guess these are not related to each other.
Any suggestions please?
Rgds
Stuart
Hi Stuart. You could use the Object Dependencies facilities to track down all objects which have a dependency on the linked table, then change all references to the old field name manually.
Since this is likely to be time-consuming and error-prone, do you really have to change the field name? You could always add a copy of the field to a query based on that linked table and alias that field in whatever way you want, then base whatever you need to feed with the new name on the aliased field. This would protect the integrity of all existing queries, forms etc in your current application.
If you really do want to change the field reference manually throughout right-click on the table and select Object Dependencies from the shortform menu. This will run for a short time and show you all queries, forms and reports that have a dependency on your linked table. You would then have to open these one by one, check their fields, and change the references yourself.
-Stewart
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Dominic Marks |
last post by:
Hi,
(I apologise if this is the wrong list, I haven't posted
to a postgresql.org mailing list before, general seemed
like a good catch-all)
I am trying to implement a centralised authentication system
using PostgreSQL as the central repository for user and password
information. I want to keep a table which contains core user
details like the username and password and then use this data
|
by: LaurenW |
last post by:
Hi folks,
I just discovered that I have a table with a bunch of text fields that
ALL have the "Allow Zero Length" property set to "No", which is
apparently the default when you create a new text field. Please
correct me if I'm wrong about this. Somehow (I'm clueless about how),
some of my user's records have ended up with zero length strings in
some of these fields -- despite the restriction. The restriction is
not important to the...
|
by: Lee Rouse |
last post by:
Hello all,
This is going to be a rather lengthy "question".
I have an Access 2k database, separated front end/back end. Front end
copies are on about 30 workstations and used frequently during the
work day. The backend has a table called CLIENTS with approximately
6000 client records. Changes to data in the table are made via a
frontend db Form which has CLIENTS as its record source.
|
by: Stewart Allen |
last post by:
Hi
Just asking for ideas on table design.
The design I have is as follows:
*tblBuildData*
BuildID (PK) AutoNumber
ManufactureDate
SerialNumber
|
by: Melissa |
last post by:
I have a frontend file named CustomerApp and backend file named CustomerData.
CustomerApp is at C:\Customer Database and CustomerData is at S:\Customer
Database. Could someone help me with the code to do the following:
1. Create a new table named TblCustomerContact in CustomerData
2. Add a field named CustomerContactID (autonumber) in TblCustomerContact
3. Add a field named CustomerID (Number-Long) in TblCustomerContact
4. Add a field...
| |
by: Robert McEuen |
last post by:
Using Access 97 on WinXP
I have data in a DB2 table that I'm trying to get into an identical
table in my backend db. Based on volume of data and frequency of
download, I'm trying to avoid having a temp table created in my
frontend.
I downloaded the temp database code from Tony Toews's site, and
altered it to fit my needs (I thought), and it functions properly all
the way to the point where the data is inserted into a new table (see
|
by: John Baker |
last post by:
Hi:
At the outset let me admit that I screwed up!
I have built a rather elaborate set of forms and sub forms starting with a client table,
and going down to PO and Line item. This works very well EXCEPT that when I started the
design I failed to consider that client records would be added to the client table in
random order. The table is indexed on client ID which is an auto number field, and as a
result the table is in random order,...
|
by: rszebras |
last post by:
I inherited a database (as a novice at Access) and need to modify it to
make it more efficient, i.e., the assignment form needs to autopopulate
with the client's name, address, phone number, etc., when you select
the cust id. Found this cited as a good method:
http://www.mvps.org/access/forms/frm0058.htm
I have two tables (clients, assignments) and one form (assignment
input) in the database. I have a
control box called CUST ID in the...
|
by: kcopson |
last post by:
I need a routine to add a new field to an existing table in a database
that is in another town.
Situation: I maintain a database with 10 copies in different offices.
Everytime we want to make a change or addition to a table's structure,
someone has to physically go out to each office and make the change.
Each database copy has it's own unique data, with tables links to
other tables within the database, so we can't just simply send a new...
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |