Access 2007 - Anyone having trouble with really large conversions?

Just curious if anyone is having issues with Acc 2007 once the number of
objects and complexity increases? I have a fairly large app, with many
linked tables, 100's of forms, queries, reports, and lots of vba code. I'm
nearly finished with re-doing my app in access 2007, and just imported an
add-in program, which has added even more forms, queries and linked tables.

Every so often now, after opening many different screens, I'll occassionally
get errors when opening a recordset for a linked table. The error will tell
me that it can't find the key value, or something to that effect. If I look
in the immediate window, I can print to the screen the table's key id, but
if I try to print any other fields in the table, I get an "Item not found in
collection" error. I finally found that if I refresh all table links, the
problem goes away. However, it does still crop up from time to time even
after refreshing the links.

I'm wondering if this has to do with having so many linked tables, and the
overall number of objects and complexity. Obviously, if this continues, I'll
be leary of going live with this app. The other thing I've wondered about is
whether it has to do with using a .accdb file as apposed to the access 2007
..mdb file. When I converted, I did choose the .accdb file, and started using
the rtf option in some memo fields.

Anyone experiencing the same in Access 2007?

Many Thanks,

Andy


.

Relevant Pages

  • Newbie questions
    ... trying to build an app with some complexity to demo to Senior ... Management to give them a taste of the power of Ruby. ... basing a model on the temp tables. ...
    (comp.lang.ruby)
  • Re: What Smalltalk product/implementation would you use, and why?
    ... no matter what language or implementation you use. ... complexity of the GUI, the complexity of the code which manages the GUI, and ... I don't know how much overhead other Smalltalk ... app will start up fast enough for startup time not to be noticeable. ...
    (comp.lang.smalltalk)
  • Re: How to find if Application has Focus
    ... there is a .Net documented bug that makes the app crash if graphical refreshes are frequently called when the app itself is in background ina terminal server session. ... Now, a customer is in this unlucky situation: the operators use then client in each own terminal server session, the client makes a graphical layout refresh according to some SqlServer data, but if the operator opens another application, and puts my client application in background or minimized, the app itself crashes. ... They provide two free support requests per product, and my experience has been that a) they extend this to development questions, and b) if the support request is a consequence of some bug in their products, they credit back the request to your product ID. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Generating Unique Numbers on a Form with Multi-users
    ... but I always do a refresh immediately and don't ... Private Sub cmdNext_Click ... I haven't worked on this app in a while but IIRC "Me.AllowAdditions = False" ... instant is a remote possibility, so remote that the risk is negligible. ...
    (microsoft.public.access.forms)
  • Re: Maximised windows leave space at top of screen
    ... I think the panel for this app is a toolbar along ... > I'm having a problem where maximised screens from *all* applications ... > refresh function - right clicking the desktop and selecting refresh ... > does not refresh this space leaving strip remnants of the window. ...
    (microsoft.public.windowsxp.general)