Originally Posted by
TheShabz
To be honest, as soon as you want to go online, go away from Access. 2010 is the first time Microsoft is really allowing Access to go online, and as we all know with first year Microsoft advances, they dont work out too well. php/MySql is your best bet, not to mention it's free.
To directly answer your question, yes you can do it. You're breaking new ground in this though as this is the first time Access to SQL Server is a real option and there aren't many people who have much experience in making it work to give you quality advice.