Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Santal_Maluko
Starting Member
14 Posts |
 Posted - 2004-12-31 : 09:46:53
|
| greetz to all!I have a little prob here...I have a relational databasee on ACCESS and I am trying to solve a little problem here...I have a little program that picks the previous versions of the database and convert to the new format.... all is doing great except on little issue.I have a relationship between the visitors and the companys, I want to break up that relation in order to change the index VisitorCompany, in order to put it like TEXT not Number......Please if you know how to do it tell me ;)Thanks....Diogo Alves |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-12-31 : 12:13:25
|
| Well, looks like you filed this in the wrong category. We have a forum dedicated to questions in MS Access. But, apart from that detail, let's see if we can help you with this.Unfortunately, it's not clear what you mean by your program "picks the previous versions of the database and convert to the new format". Does that mean you are converting from Access 2000 to Access 2003 or something like that? Or when you say version do you just mean you have an older copy and a newer copy of your database?And it seems you are mixing terms between relationship and index. Perhaps you could give us some additional information such as a table definition and sample rows and your desired result.---------------------------------------------------------------------------------Infoneering: Information Technology solutions engineered to professional standards. |
 |
|
|
Santal_Maluko
Starting Member
14 Posts |
Posted - 2005-01-03 : 04:41:11
|
| ok I will explain better!The last version of the program uses a database with the visitors and the respective company, in diferent tables. I use a key on the table visitors that is called "VisitorsCompany" and the data tipe is Number.Now I am using a program in VC++ that modifies the database, adding some new fields, etc, etc...But there is one cheange on the database that I can't do... That field VisitorsCompany is not a key anymore and is supposed to be from data type Text... I can't change the data type neither remove the relationship between this 2 tables...I've tried DROP INDEX, DROP CONTRAINTS, and it was of no use... I can show you the code I used..."strSQL ="DROP CONSTRAINT VisitorCompany ON Visitors";"Diogo Alves |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-03 : 04:51:45
|
| should be drop index VisitorCompany ON Visitors==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
|
|
DROP INDEX maybe!!