Access DB Converted to SQL
Posted: Sat Apr 25, 2009 2:56 am
I am wondering if anyone has converted the Access DB that comes with this program to an SQL DB?
It's my opinion that the Access db is too slow and becomes bloated really fast. There are reports for year to date but there is no way you can keep a years worth of data in there without seriously impacting the performance of the software.
I have deleted orders to keep only the current month in the Access db, compacted and repaired to make the db as small as possible, but still find it to be running slow when entering orders, printing, etc. The smallest I have been able to make the db is 85mb with the current month of orders and of course all of our items, inventory, etc
I know the Access db can be converted, but can the program connect to a SQL server or just a file based DB?
Any help on this would be appreciated.
It's my opinion that the Access db is too slow and becomes bloated really fast. There are reports for year to date but there is no way you can keep a years worth of data in there without seriously impacting the performance of the software.
I have deleted orders to keep only the current month in the Access db, compacted and repaired to make the db as small as possible, but still find it to be running slow when entering orders, printing, etc. The smallest I have been able to make the db is 85mb with the current month of orders and of course all of our items, inventory, etc
I know the Access db can be converted, but can the program connect to a SQL server or just a file based DB?
Any help on this would be appreciated.