M
Myron Oakley
I have a very vertical product developed 100% in M/S Access. I developed it
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environment. A
move to SQL would require substantial work.
I recently installed a Dell 2900 dual quad core xeon Terminal Server and
quickly discovered the application now screams on this platform. My big
question now is if we should even consider moving to SQL. I know Access
2007 has a new db format. If that is faster or able to service more users,
maybe we should just push Terminal Servers and stay right where we are.
If anyone out there has experience along these lines, I would *gladly* pay
for some consulting time.
TIA
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environment. A
move to SQL would require substantial work.
I recently installed a Dell 2900 dual quad core xeon Terminal Server and
quickly discovered the application now screams on this platform. My big
question now is if we should even consider moving to SQL. I know Access
2007 has a new db format. If that is faster or able to service more users,
maybe we should just push Terminal Servers and stay right where we are.
If anyone out there has experience along these lines, I would *gladly* pay
for some consulting time.
TIA