size limitations for Act Premium 18

[levelbreaker]

What are the database size limitations for Premium ver 18?

Are there any field number limitations as well? 

[Roy_Laudenslager]

I believe the size limitation using SQL Express is 10 g bytes. There's no specific limitation to the number of added fields though an excessive number of fields can cause problems with the layout. If fields are being added to accommodate a one-ro-many situation if would be better to use a custom table rather than adding a large number of fields.

[levelbreaker]

How do you add a custom table? Is that something I would have ACT do, or is it something that can be done by the user?

I believe we are adding too many fields.  I've been creating different layouts for the different type of customers. 

[ch1p]

To add tables you will need an act add-on unless you are a wizz with ACT sdk.

With the SQL based version of ACT the number of fields should not be an issue as I have a client that added around 500 fields but would challenge if this is ever a good idea as no one is going to spend all day filling them in.