Hi,
Does "Invoice Product" contain space in name or not? In one line you have
spece in one not (RsInvoiceProduct.Properties("Unique Table").Value =
"InvoiceProduct" or "Invoice Product")?
--
Val Mazur
Microsoft MVP
Quote:
> Dear Sir,
> I had tried to define property as follows.
> RsInvoiceProduct.Properties("Unique Catalog").Value = "db1.mdb"
> RsInvoiceProduct.Properties("Unique Schema").Value = "Admin"
> RsInvoiceProduct.Properties("Unique Table").Value = "InvoiceProduct"
> But when I tried to Update Base Table "Invoice Product" it Gives following
> error message.
> "Non-existent or under-specified UNIQUE TABLE."
> Please reply me.
> Sanjay Shah
> > Exact same way
> > MyRecordset.Properties("Unique Catalog").Value="DatabaseNameHere"
> > --
> > Val Mazur
> > Microsoft MVP
wrote
> > > Hi,
> > > Please tell me how to set property of Unique Schema & Unique Catlog.
> > > Sanjay Shah
> > > > Hi,
> > > > What you need to do is to set it in next way
> > > > MyRecordset.Properties("Unique Table").Value="TableNameHere"
> > > > But using of Unique Table does not mean that you have to set Unique
> > Schema
> > > > or Uniqut Catalog properties as well. If you are working with same
> > > database,
> > > > where your table is, then you do not need to chage Uniqut Catalog.
> > > > --
> > > > Val Mazur
> > > > Microsoft MVP
> > wrote
> > > > > Dear Sir,
> > > > > How to Define ADO Dynamic Property.
> > > > > Unique Table
> > > > > Unique Schema
> > > > > Uniqut Catelog
> > > > > If I Define Unique Table property then there is no use because it
> > > require
> > > > > Unique Schema or Unique Catalog.
> > > > > Please help me.
> > > > > Sanjay Shah
ADO Dynamic Property