Getting a db Schema and changing it

Eric

I have an application that uses an Access db. I would like to be able to programmatically change the column names in one of the tables. I know how to get the Schema of the database but how can I change it?

Nov 15 '05 #1

Subscribe Post Reply

1746

Miha Markic [MVP C#]

Hi Eric,

You might use ADOX to manipulated the database structure.
See this thread:
http://tinyurl.com/2hy97

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Eric" <an*******@discussions.microsoft.com> wrote in message
news:AE**********************************@microsof t.com...

I have an application that uses an Access db. I would like to be able to

programmatically change the column names in one of the tables. I know how
to get the Schema of the database but how can I change it?

Nov 15 '05 #2

Mike Collier

>I have an application that uses an Access db. I would like to be able to
programmatically change the column >names in one of the tables

you can alos use SQL DDL statements ALTER, CREATE.
http://81.130.213.94/myforum/forum_p...sp?TID=64&PN=1
--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
www.adoanywhere.com
http://www.adoanywhere.com/forum

Nov 15 '05 #3

Similar topics

My schema validation is not working?

by: wooks | last post by:

<?xml version='1.0'?> <userlogin xmlns="urn:faster:userlogin" xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'> <login>mick</login> <password>brown</password> </userlogin> Above is my...

.NET Framework

qualified and unqualified local elements (was: My schema validation is not working?)

by: C. M. Sperberg-McQueen | last post by:

wooks (wookiz@hotmail.com) wrote: > <?xml version='1.0'?> > <userlogin xmlns="urn:faster:userlogin" > xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'> > <login>mick</login> > ...

.NET Framework

Schema: Change properties of inherited elements without listing them again

by: Alex Sab | last post by:

Hi, I am having trouble describing in a schema that elements can be mandatory in one part and not mandatory in another part of the xml document. Here is a sample xml file <Model:Templates>...

.NET Framework

getting intellisense for custom XML

by: Don | last post by:

Hi: I have created an xsd from my xml document. I pop this xsd in the following directory: C:\program files\Microsoft Visual Studio .NET 2003\Common7\Packages\schemas\xml. That give me...

.NET Framework

Changing schema owner?

by: Francisco Reyes | last post by:

Is there a way to change a schema owner other than dump/restore? How about changing the nspowner in pg_namespace? Will that do the trick without any negative consecuences? ...

PostgreSQL Database

Microsoft wsdl Utility fails when multiple <schema> tags reference same targetNamespace

by: Jeff | last post by:

We are using .Net and the wsdl Utility to generate proxies to consume web services built using the BEA toolset. The data architects on the BEA side create XML schemas with various entities in...

.NET Framework

question about using the correct schema namespace

by: Jay | last post by:

I have a Access/VBA client that exports xml to the local drive, then posts it over http to an aspx page. The aspx page consumes it, then builds itself based on the xml data. This works find only...

.NET Framework

hl7 xml schema register problem with xerces library of DB2 Express-C v9

by: aralvarez_nospam_at_gmail.com change _nospam_at_ | last post by:

I have been trying to register some HL7 schemas into DB2-Express -C v9. After invoking the following command: complete xmlschema "datatypes-base"; it throws me the following error: ...

DB2 Database

Getting db2 output into a shell variable

by: Brian Tkatch | last post by:

This is a shell question (bash), but i'm more familiar with this group, so i hope noone minds. I have a bash shell script which needs to query the database and return information into a...

DB2 Database

Not getting attribute into dataset using XSD

by: Chris White | last post by:

Here's my XML <?xml version="1.0" encoding="UTF-8"?> <results> <status code="ok"/> <report-bulk-users> <row principal-id="23859115" type="user"> <login>muser@domain.com</login> <name>My...

.NET Framework

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

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...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing