Changing to SQL server

[petko]

As a result of couple of years developement our company's complete management is running on access database. Tables are stored in a server and 5 different user ends are attached to these tables. Works very fine but we feel the limits - mostly in speed.
I read in some thread that a sql server could serve the ends in a lot faster way of not transferring the complete table data through the network but only the results. Can you help how I could start such modification? Can all developement (visual basic programings, forms etc) be kept as before after such a modification?
I appreciate any help in this matter.



Peter

[petko]

I'm new on the forum...
Is my question too complex, too general or too dificult?

Peter

[Rixxe]

In general, SQL Server works well as a backend. The full version doesn't have small space requirements such as Access, not to mention as you stated above, has a significant speed advantage when running queries on large tables.

In regards to converting to using SQL Server, Google is your friend. I personnally havent used SQL server as a backend with Access, so i cannot really help you with that. But there *should* be a large amount of information out there with a little effort.

Remember to backup EVERYTHING before attempting this, as usually with this stuff, something does go wrong.

Perhaps someone else on this forum can give you step by step method to do this, but don't count on it.

Good Luck.