I have been trying to follow what I thought was best practice splitting a database into a back end and front end. The front end has some very complex reports containing 15 - 20 sub-reports. Now with the database split I can Print these say 5 or 6 times, but then although the print preview works, when I click on the print icon I start to get this error message 'cannot open anymore databases'. Merging the database back into one solves the issue BUT this is not what I want - I would like to be able to add security to the database and place the front end on user machines with the backend on the server. I have found an article on the Microsoft web site that explains this behaviour is due to twice as many tables being opened when split ! Does anyone have bright suggestions on how to solve this one ? Also question for Microsoft : could this be classed as some sort of bug (it works to begin with and then eventually gives up!). I get this issue with Access 2000 and Access 2003.