Where to save custom settings 1

[JoeAtWork]

Hello good people of the AccPac forum!

I will likely soon be writing a macro for importing invoices. To make life easier for my users, I would like to be able save certain settings, such as the default directory where the import file can be found.

Instead of storing this in some external source, such as an INI file, I was wondering if it is feasable to store it in the AccPac database. Could I create an Optional Field (under Common Services) for each of these settings? Is this a correct usage of Optional Fields?

It also occurred to me that I might create a new database on Pervasive. But my experience is with SQL Server, so I'm not sure if I should try that (although looking at the Control Center I think I could figure it out). I'm also not sure about how to make a connection (although I assume I can use ADO).

Any feedback or other suggestions?

My system:
Accpac Advantage Series Enterprise Verson 5.3A SP 3
Pervasive database

 

[jayconverse]

Use an optional table, that's a great way to go. If you add a new table to the Pervasive database outside of Accpac, you'll lose it during a Dbdump/Dbload.

Jay Converse
IT Director
Systemlink, Inc.

 

[JoeAtWork]

Thankyou Jay, it's good information to know.