Hi there,
I would like some advice, I would like to create a frontend for a Sql Server Database (or even Ms Access if this would be faster - accessing records I mean)
Basically I need to rewrite the current system which is an ADP used to access a Sql Server Database.
The reason for the rewrite is that the adp just runs too slowly when opened across the network, my idea is to write Asp pages to access the data, however I am wondering if asp is going to make any difference to the performance?
any other advice / options will be greatly appreciated,
ps there are approximately only 200 records per table and I believe only about 200 will be added per year.... (although they will be maintained on a regular basis)... would an access database be more suited for this purpose?
Thank you for you time!
I would like some advice, I would like to create a frontend for a Sql Server Database (or even Ms Access if this would be faster - accessing records I mean)
Basically I need to rewrite the current system which is an ADP used to access a Sql Server Database.
The reason for the rewrite is that the adp just runs too slowly when opened across the network, my idea is to write Asp pages to access the data, however I am wondering if asp is going to make any difference to the performance?
any other advice / options will be greatly appreciated,
ps there are approximately only 200 records per table and I believe only about 200 will be added per year.... (although they will be maintained on a regular basis)... would an access database be more suited for this purpose?
Thank you for you time!