I have a situation with my DB. I added a couple of columns to a certain table, which apparently affected many forms, would like to know if there is any code out there that would help me apply changes to my DB such as add columns and tables with out causing other major errors in the DB like currently. Some guy looked at it, and suggested it was a problem with ?? some conventional naming code that is preventing me from making changes, but could not locate the files that hold these codes, hence i wonder if new code could be written to overwrite this limitation.
3  1967  nico5038 3,080
Recognized Expert Specialist
Perhaps best to check: www.fmsinc.com for the Access tools available.
Building such a tool yourself will take a considerable time....
Nic;o)
Thanks for the input there guys.
Checked out the site there, just don't have the money to blow on that kind of fix it solution... hehehehe
I don't get it either.
I simply add a column to a specific table, and kaboom, the form doesn't work, i can't get the form to add materials to any classes???
Like i tried to explain, could ther be some specific coding in there that prevents me from adding columns to tables???
As soon as i delete that column, BINGO, she works???
Hence my reasons for guessing there must be something relating to either the position of the columns in the table such as exp1, exp2, exp3 and so on...
But if i add an ex5, suddenly the coding gets confused???
Either because the column field name is not listed in the code. I really don't know what is preventing me from adding aditional columns to add better funcionality to the DB....
Once again, your help would be greatly appreciated.
RAJ
 Rabbit 12,516
Recognized Expert Moderator MVP
Thanks for the input there guys.
Checked out the site there, just don't have the money to blow on that kind of fix it solution... hehehehe
I don't get it either.
I simply add a column to a specific table, and kaboom, the form doesn't work, i can't get the form to add materials to any classes???
Like i tried to explain, could ther be some specific coding in there that prevents me from adding columns to tables???
As soon as i delete that column, BINGO, she works???
Hence my reasons for guessing there must be something relating to either the position of the columns in the table such as exp1, exp2, exp3 and so on...
But if i add an ex5, suddenly the coding gets confused???
Either because the column field name is not listed in the code. I really don't know what is preventing me from adding aditional columns to add better funcionality to the DB....
Once again, your help would be greatly appreciated.
RAJ
What did you name the column? What are the properties of the column? Did you put the column at the very end (Check design view for this)?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: jason |
last post by:
Hello.
Newbie on SQL and suffering through this.
I have two tables created as such:
drop table table1;
go
drop table table2;
go
|
by: Rustam Bogubaev |
last post by:
Hi,
I have a table with the following columns:
ID INTEGEDR,
Name VARCHAR(32),
Surname VARCHAR(32),
GroupID INTEGER,
SubGroupOneID INTEGER,
SubGroupTwoID...
|
by: Karen Middleton |
last post by:
In MS Access I can do in one SQL statement a update if exists else a
insert.
Assuming my source staging table is called - SOURCE and my target
table is called - DEST and both of them have the...
|
by: ZeroVisio |
last post by:
Hi,
I want to know if there is an easy way to do update a column of a row in
DataTable.
|
by: Larry Grady |
last post by:
Anyone up for a challenge?
I've been struggling with this for a few days and was hoping someone could
help me. Pouring through all the messageboards I just can't find the
solution.
We have a...
|
by: binder |
last post by:
I have a stored procedure that inserts values into five columns of a
table. I need another stored procedure that will allow the user to pass
one or more of those parameters and update only the...
|
by: explode |
last post by:
I made nova oledbdataadapter select update insert and delete command and
connection veza. dataset is Studenti1data, I made it by the new data source
wizard,and made datagridview and bindingsource...
|
by: L.Peter |
last post by:
Hi Group,
I have a gridview bound to a sqldatasource, this datasource pulls data out
from select and update procedures with 10 update parameters
the gridview has 15 columns, in edit mode, I want...
|
by: Bogdan |
last post by:
Hi,
I have a stored procedure that uses JOINs to return columns from multiple
tables. I also have another stored proc that that takes a series of params
and updates multiple tables. I used the...
|
by: Michel Esber |
last post by:
Hi all,
DB2 V8 LUW FP 15
There is a table T (ID varchar (24), ABC timestamp). ID is PK.
Our application needs to frequently update T with a new value for ABC.
update T set ABC=? where ID...
|
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: 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...
|
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...
|
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,...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
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...
|
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 ...
| |
