Using 2003 within 2007

  • Thread starter Thread starter Leslie Hester
  • Start date Start date
L

Leslie Hester

I haven't converted my 2003 database to 2007 as we have half an half users in
the office.

Problem: 2007 Users keep getting error msgs about having too many tables
open. We are using the switchboard with alot of Macros involved and forms
opening for filtering options. I've searched the online help and can't find
any solution that jumps out at me. Has anyone else seen this? What do I
need to do to fix it?
 
That error message can occur if you're using *lots* of combo boxes and/or
listboxes and/or subforms on forms, and the forms are all open at the same
time. Each of these controls can "open" a table under the covers in order to
provide the required data for the control.

Best option is to limit how many forms can be open at the same time. I do
this in my applications by closing the current form when the user navigates
(by a command button) to another form. It can get a bit complicated if you
need to let the user navigate backwards, but it can be done if you pass the
previous form's name to the new form via the OpenArgs argument, and use that
argument as the file name for a DoCmd.OpenForm action that runs when the new
form closes.
 
Thanks for the reply Ken. I ended up just creating a new database and
importing everything from the existing one into the new one and that seemed
to solve the problem. My thinking now is that someone left the database open
on their machine and a 2007 auto update must have taken place while it was
open and somehow corrupted the ability to use the 2003 version in the 2007
version. I have Access 2003 and I wasn't getting any of the error messages
and everything worked fine for me. Only the users who had Access 2007 on
their machines had the problem. You are right that I'm using "lots" of combo
boxes, subforms, etc... Lots of macros and the switchboard also to help
users with little experience navigate and perform task. Thanks again for the
reply.
 
Back
Top