Hi All,

I want to ask the forum's advice on upgrading to SQL server from Access 2007. I'm in the stage of skill building now. I've taken several coures (including Access and Visual Basic) and I know just enough to be dangerous. Though luckily I recognize the only thing I really know is how much I don't know. That's why I'm asking for advice from more experienced professionals. I work at a college and I've built several Access databases for our programs. They work wonderfully on my computer, but most of our data entry people work from laptops with wireless connections. All the databases are located on our department server, which means they are accessing them through the school network. A couple of our data entry people have complained that the databases are slow, sometimes very slow. I've done compact and repair, turned off the name autocorrect feature, changed the subdatasheet properties on the tables to none, and worked with the performance analyzer, which suggested I add indexes. I did this and it works very fast on my computer, but my computer isn't the problem. The problem is the databases are being utilized by several users concurrently across the network. I know this practically begs for performance issues, but there's nothing I can really do about it. I began to research SQL server and wondered if it might be a solution to my problem. What I could possibly do is convert the back end with the data to SQL server and leave the front end as Access. Right now it's just one mdb file. I don't want to be hasty though because I know nothing about how to do this and whether it would even help. The databases I design will never have more than 20,000 records and will never have more than 10 concurrent users. In fact, both will probably have significantly less. I'm just giving you an extremely high limit scenario. Given those limits is splitting the database and moving the back end to SQL server something worth considering, or am I better off keeping it all in Access and using other fixes. Also, twice a year I have to send one of the databases across an FTP file to another site. Would splitting it mess up that process? I'd appreciate any insight you can give me. Thank you!