HI,

I have been running mm.net security with the sql server tables, which were installed in the Northwind database by mmSecurity.sql. I now want to run security with vfp tables. I am having trouble using the description of the tables in the developer's guide to do this. Things are not readily transportable to vfp type of database.
For example:
1)int identity in sql is what in vfp? I tried int
2)varchar(50) in sql is what in vfp? I tried C50 and memo but in memo cannot be a PK.
3)smallint in sql is what in vfp? I tried int.

I set up referential integrity as per the developer's guide.
When I attempt to use the vfp tables I get the error operator/operand mismatch as soon as I go into Security Administration and attempt to select the Mere mortals .net user.

Please help me with the conversion of the security tables from sql to vfp

Regards,
Neil