Cannot open anymore databases error

gunny3000

Registered User.
Local time
Today, 01:22
Joined
Nov 3, 2010
Messages
31
Hi,

I appreciate that there are other threads on this, but, they do not specifically cover my issue.

I have also read about "Temp Tables", but, I didn't understand how to create a Temp Table, and therefore, I'm not sure how to use these.

My Issue:
  • I have a report that references a number of tables to populate the individual sections of the Report (this has to be as they are descretely different sections).
  • I have spilt the DB so that I can continue to develop the Front End and not have to re-import ALL the tables following a new revision.
  • the DB works well until a view a Report when I get the "Cannot open anymore databases".
As I have said; I have read some posts, but, don't know how to fix - any help is gratefully appreciated.
 
This is not an uncommon error, do you use VB or scripts using ADO or DAO?

Simon
 
I have a very basic piece of VB code to view the Report of the current record:

Private Sub Command270_Click()
On Error GoTo Err_Command270_Click
Dim stDocName As String
stDocName = "rpt_Change_Management"
DoCmd.OpenReport stDocName, acViewPreview, , "change_ref_id = Forms![frm_change_management]!change_ref_id"
Exit_Command270_Click:
Exit Sub
Err_Command270_Click:
MsgBox Err.Description
Resume Exit_Command270_Click

End Sub
 
This error is general an accumulation rather than the event itself. It can be a combination of the extensive use of combiboxes (embedded SQL calls), VB code, multiple databases etc. It just so happens that this report is the breaking point.

Simon
 
Access not great then!

I've hardley created anything too large or complicated. Without data my DB is only 1.2Mb.

Is there really nothing I can do?

what about the "Temp Tables"?
 
Sent up a copy and lets have a look at the problem. Some data would also be useful so that we are re-create the error. What version of Access are you using?

Simon
 
It does seem a bit odd. I'm getting the same error so I'm going to replace the lookups from the table structure and then separate subForms and subReports, the later without combi-boxes.

Lookups in tables is not a good idea, I don't why Microsoft included this feature as the implementation is problematical.

You have created a great interface.

I will get back to you as soon as I made some progress.

Simon
 
Right, There are a few things qry_change_Management relies on unpopulated tables. So I would remove these the two tables are tbl_Vari_Followup and tbl_Support_Info_Checklist and these belong to the subForms or subReports.

The tbl_Signatures should be associated with tbl_Contacts. Without knowing the personnel involved it is hard to determine whether or not these signatures are contacts or internal staff, but nonetheless, but all personnel could be in contacts.

Because there are lookups on the tables any combi-boxes on a the report should be change to Text boxes, combi-boxes are superfluous on reports.

Because there are so many stages with the Change Management Process you could put this information into a separate table (tbl_NewEquip_Progress). This is what is called normalisation but whilst it is good practice this can be looked at later.

Updated the Revision History just to let you know what I've been up to! There are few other tables that I have extracted from the table lookups.

Location I have used to aviod confusion is C:\Databases\Change. You will need to re-link the Tables.

Simon

Simon

Simon
 

Attachments

Users who are viewing this thread

Back
Top Bottom