Search results

  1. O

    Deal with tables that are "too large" to edit

    I inherited a db and one of the tables is giving me problems when trying to change some of the design. Namely, I make the change and when I try to save it says "Property value too large.". I did a compact/repair. Beyond that, I can't remove any of the columns and am not sure what to do. Thanks.
  2. O

    Form not auto-filling with data.

    I have a database (inherited) and its now working well except for one form. You can open it and enter data and save/close it. But when you open it again, there is nothing there (whereas all the other forms show the current data). The code is included below. I've done some debugging and found...
  3. O

    "Transferring" tables structure.

    Hello all. I have a database that has up-to-date data but is missing all the structure (I won't go into why this happened...). I have a backup version that has the exact same tables but with all the structure (i.e. primary keys, validation, default values etc.) intact. Is there a way to get...
  4. O

    Splitting database causes VBA error in form

    I inherited a database that was not split (maybe this is why). I'm trying to split it and I ran into a problem. I split a version of the database that is working perfectly and then get an error on one of the forms. Obviously, splitting the database is the cause. So, the form essentially has a...
  5. O

    Really problematic db. I don't know where to start

    Hi, I'm new here. I'm not sure if this is the right forum for this, so let me know if it isn't. I started a summer job in May, taking over as the database person here. The database is not in good shape. There are extra 'garbage' tables, I've heard the code is not very good (I'm not that...
Back
Top Bottom