Re: Relationship Question

Thank you once again for your response.

Just after i've posted this.
I've realized I didn't specify this:
I've used your SQL statements by passing them into an connection.Execute
statement in ado.
I've tried to delete the table in the Tables window of Access, just select
and press delete.... that generated the error.
I'm not such an ace in these things but I've tought: what if I do it the
same way as I've created the table: passing "Drop Table Trevors" into the
connection.Execute. That worked alright....
Nevertheless, thanks for your info.

Now, what confuses me a bit is that obviously if you're manipulating a .mdb
through ADO it doesn't result in the same situation as if you would do the
same thing by means of the Access table/query design interface.
Or am I missing a point here ?


JG

"Jamie Collins" <jamiecollins@xxxxxxxxxx> wrote in message
news:1174637334.715247.72020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 22, 3:06 pm, "Jürgen Germonpré" <ricos...@xxxxxxxxxxx> wrote:
created the Trevors table and now I want to
delete it but when doing so i get this error:

DDL cannot be completed on this table because it is referenced by
constraint
<name> on table <name>. (Error 3803)

What must I do prior to deleting the table ? I've already deleted the
indexes but this doesn't makes a difference...

Table-level CHECK constraints must be dropped first e.g.

ALTER TABLE MasterSlaveTrevors DROP
CONSTRAINT master_cannot_be_slave
;

FWIW the SQL-92 standard has such syntax

DROP TABLE MasterSlaveTrevors CASCADE
;

which would remove the dependencies but although Access/Jet supports**
the syntax it doesn't perform the functionality (**that is, it doesn't
error; you can replace the keyword 'CASCADE' with any other word and
it won't error either <g>!)

Jamie.

--



.

Relevant Pages

  • Re: running out of memory
    ... First of all it is not ADO, ... using of the SQL statements on a server side inside of SP to do this rather ... > I've found that looping through an ado recordset will cause memory ... > if it's a large recordset. ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO NextRecordSet
    ... Im executing multiple SQL statements within a batch and ... using the ADO NextRecordset method to loop through the returned ... however when I call NextRecordset after I have ...
    (microsoft.public.sqlserver.programming)
  • Re: prepared command (or instruction) S000002 not found error
    ... So a message for everyone who has problems with ADO and iSeries / AS400: ... Ralf Grenzing - OPUS//G ... we are trying to migrate our Delphi 5 BDE Win32 application to ADO and Delphi 2006 with Update 2 installed. ... It is really wired because some SQL Statements runs and trying the VERY SAME SQL over ODBC works great, ...
    (borland.public.delphi.database.ado)
  • Re: Access Project with SQL Server-passing parameters to action stored procedures using ADO
    ... Regarding passing datetime parameters, I have changed ... Zlatko ... >> passed to action stored procedure only by using ADO through VB. ...
    (microsoft.public.sqlserver.programming)
  • Re: Batch Updates
    ... I assume that this would need to be two seperate sql statements as I am not ... I am currently loading a delimited file into a query and then parsing the ... key field already exists to update my ADO table but this process is very ... insert into table2 ...
    (borland.public.delphi.database.ado)
Quantcast