I am having loads of problems getting this to work i have tried DXDEPLOY Method Error 73! I have tried to use the designer and dxact... designer fails

I 0e20 06-09 14:58:47 Validating database rules for 'xPD2PQIWH'.
I 0e20 06-09 14:58:47 Saving database rules for 'xPD2PQIWH'
I 0e20 06-09 14:58:49 Regenerating release for database 'xPD2PQIWH'.
I 0e20 06-09 14:58:49 Reconciling control tables for xPD2PQIWH (Owner: '')
I 0e20 06-09 14:58:49 Attempting to create table PDCCATTLE CONDEMNED
I 0e20 06-09 14:58:49 CREATE TABLE "PDCCATTLE CONDEMNED " (GIDSysKey ubigint, GIDSiteID int, LID ubigint NOT NULL, CreationTime timestamp,
                     Deleted char(1), LastChange timestamp, RecordLength usmallint, primary key(GIDSysKey, GIDSiteID))
I 0e20 06-09 14:58:49 Table xPD2PQIWH.PDCCATTLE CONDEMNED  will be dropped and re-created
W 0e20 06-09 14:58:49 A new primary key field (Price Code) has been added to CATTLE CONDEMNED ADJ.  Control table information for this
                     table must be regenerated, no existing information will be preserved.
I 0e20 06-09 14:58:49 Attempting to create table PDCCATTLE CONDEMNED
I 0e20 06-09 14:58:49 CREATE TABLE "PDCCATTLE CONDEMNED " (GIDSysKey ubigint, GIDSiteID int, LID ubigint NOT NULL, CreationTime timestamp,
                     Deleted char(1), LastChange timestamp, RecordLength usmallint, primary key(GIDSysKey, GIDSiteID))
E 0e20 06-09 14:58:49 ODBC Error -1: (S0001) '[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Table or view
                     already exists.' <0>
E 0e20 06-09 14:58:49 ODBC statement failed: -1 from function ExecDirect
E 0e20 06-09 14:58:49 ODBC statement: CREATE TABLE "PDCCATTLE CONDEMNED " (GIDSysKey ubigint, GIDSiteID int, LID ubigint NOT NULL,
                     CreationTime timestamp, Deleted char(1), LastChange timestamp, RecordLength usmallint, primary key(GIDSysKey,
                     GIDSiteID))
E 0e20 06-09 14:58:49 Unable to create PDCCATTLE CONDEMNED  table
E 0e20 06-09 14:58:49 Error '{An ODBC error occurred}': Could not create control tables for data source 'xPD2PQIWH'.
 

  Help please

I'm afraid there's a good reason why you can't make this work.

For one the method that DX uses to manipulate data in the target is on a per table basis which means you cannot have any constraints on your target.

Second, if you have enabled RI your database will be bound, meaning your tables can only be targeted in reference to the original named database. DX however will try to target these tables through its own data source (xPD2PQIWH) which is not possible.