Develop on stand alone and transfer to SQL Server

[FrankPV]

I just upsized my Access Front end to SQL Server 2000. I do most of my development at home on a standalone PC and just transfer the front end back to my work PC when I'm done. Is there an easy way to continue development on a stand alone PC and transfer the front end to work without having to relink the tables each time. If I install MSDE on my home PC can I create the same links to the back end data?

Thanks.

 

[fluteplr]

Short answer yes. MSDE and SQL Server are code and data compatible, with a few exceptions. For example I don't beleive MSDE will handle indexed views.