How to change colums and colums names in my Access database.

[zndow]

I am new to Cold Fusion and dinamyc database.

I need to make some changes in my database on my hosting server. The database is an Access already OBDC Linked.

I downloaded the database back to my machine, but when i try to open it Access show me a message alert.

Microsoft cannot open this file.

This file is locate outside your intranet or on an untrusted site.Microsoft Access will not open the file due to potential security problems.

To open this file copy it to your machine or an accessible network loacation.

The question is. How i can make changes inside the database, if i cannot open it with access anymore.

 

[TruthInSatire]

use sql.

something like

<cfquery  datasource = "#ds#">
			CREATE TABLE tableName
				(field1 date NULL,
				field2 date NULL, 
				field3 text(255) NULL,
				field4 text(10) NULL,
				field5 text(255) NULL,
				field6 memo NULL,
				field7 text(10) NULL,
				field8 text(10) NULL
				)
		</cfquery>

there are other commands you might want to look into. I'd get a book on sql, it'll help you learn.

Beware of programmers who carry screwdrivers.

 

[zndow]

I need to change names of colums already exiting inside the tablebase.

I need to change Date to LastDate and Time to LastTime so no more cnflict with the OBDC, and i need to add a new colum text and delet an other one.

 

[GUJUm0deL]

ALTER TABLE in sql.

http://www.techonthenet.com/sql/tables/alter_table.htm

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[zndow]

If i understood, i can create a cold fusion page with this sql fonction, and it should do the trick ??

 

[zndow]

I cant do everything what is write for the SQL, but at least i could add and delete colums. thank you for the help guys.