Split database questions

[Guest]

I have split a database into a front end and backend. Several times from
report preview, when I try to print the report from preview. I have gotten a
"Cannot open anymore databases" error. This does not happen all the time

Is there a way to avoid and or trap this error so the user can try to print
again?
It did not happen before I split the database.

I have also backup both files on another drive. If I try to copy one of
these back to the original location, will the front end be able to find the
back end?

 

[Guest]

joeA2006:
is you back end file in "share mode" this is the default mode? Is your
back-end on a server or folder with shared properties?

 

[Guest]

The backend is in share mode and is in a network folder with shared properties

 

[Tony Toews]

I have split a database into a front end and backend. Several times from
report preview, when I try to print the report from preview. I have gotten a
"Cannot open anymore databases" error. This does not happen all the time

Do you have many subreports? Do you have many instances of the same
subreport? If so you may want to merge the data on the subreport onto
the main report and control the visibility of the data yourself. You
will also likely get increased performance. One report went from 20
seconds to 20 minutes after splitting. And back down to 20 seconds
once I moved the data from the subreport to the main report.

Also are you up to date on Access SPs and patches?

tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I have also backup both files on another drive. If I try to copy one of
these back to the original location, will the front end be able to find the
back end?

This problem is almost certainly in the front end (FE),

This shouldn't matter because the table links are in the FE The FE
can be anywhere on your hard drive and it will still look to the same
location and BE MDB name for the tables.

Now if you move the BE MDB or rename it then you need to relink the
tables in the FE MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm