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.
|
Similar Threads
