Get away from Access. That is a piece of crap. Use SQL Server Express which will allow you to migrate your application to a full-blown SQL Server without programming changes. 2) You access the remote database with a connection string. This specifies which server to look for the database on. 3) You get away from hard coding (somewhat) by putting the connection string in your application config file. You may, however, make sure you are running the right version of Visual Studio to ensure you have the remote capabilities exposed to you. (Visual C# Express, for example, has a lot of functionality stripped from it.)