Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!
Another way to do it is to put a reference to the database in the front end. Open a module go to Tools>References and then press the Browse button. In the dialog box change the file type from a Library to an Access Database and then find you back end.
You will have problems if you move the backend. You will have to reset the reference. Might be an issue if you are distributing it. But I am pretty sure you can programmatically set references.