Help with Error 3048: Cannot open any more databases

[batowl]

Hi All,

I recently completed creating a database that is somewhat large for me (29 tables). Once I had the data entry form set up the way that I wanted, I would get to a certain point in the data entry process on the very first new record (4340 historic records were imported and are appropriately stored) before getting the following error: Error 3048: Cannot open any more databases. I could not enter any more data and the drop down menu on the record where data entry was stopped was now blank (it should be filled with a list of response options that are stored in a separate table).

I do not have a clue as to how to fix this problem (or even exactly what the problem is). Has anyone run into this before and are they aware of a solution?

Thank you.

[June7]

Could be any number of causes, one of which is corruption.

Do you have any code in the db - macro or VBA?

If you want to provide db for analysis, follow instructions at bottom of my post.

[burrina]

I suspect too many open connections. You need to make sure they are closed. Example:

Dim rst as DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SomeTableOrQueryName", dbOpenDynaset)
rst.Close
Set rst = Nothing

HTH

[batowl]

In terms of attaching the db for analysis - the database is split so that the tables all sit in the back end and the forms are in the front. The front end also connects to a 2nd back end database to retrieve other data. So would you need all three files submitted for analysis?

I do not think I have written any code for this database yet. Everything I have done up to this point (creating tables, importing historic data, establishing relationships, building forms) has been accomplished without writing any code.

[June7]

If there is no code in any of the db's, providing db's probably not useful.

29 linked tables should not cause an issue. How many tables are linked with the 2nd db? I doubt you have hit a limit.

[batowl]

I am just linking to one table in the back end of the 2nd DB.

I have over 255 fields were I am capturing data, so the data entry form has various subforms on it (which are placed on separate tabs) in order to accomodate this high number.

The fact that the drop down box all the sudden empties out is peculiar to me. Would it help if I moved the table where the list of available options within the drop down menu (yes, no, dont know, unknown, etc.) to the front end? Could it be the connection to this table in the back end over and over that is causing the problem?

[June7]

The limit for number of controls on a form is 755. I have hit that limit and used subforms to get around. Forms are a little slow but all works.

Moving the lookup table to frontend probably won't make difference but you could try.

I don't have any problems with combobox connections. I have forms with many comboboxes pulling their lists from backend.

Have you run Compact & Repair?