I have a table in my mssql database that I would like to be able to edit within vp.
The table is definitely there (checked with mssql manager) but I can't get vp to recognise it.
Any ideas anyone?
Sorry forgot to mention I need to access the table in the vp admin screen for thinks like bulk update etc.
Forgot to mention I created the new table by running convertsql.asp and the following script:
create table [dbo].[products2] (
[prod2id] [int] identity (1, 1) not null,
[catalogid] [int] null,
[ccode] [varchar] (255) null,
[cname] [varchar] (255) null
) on [primary]
Sex toys from a UK sex shop including vibrators and dildos.