Search results

  1. P

    AutoNumber Error -- MaxLocksPerFile ??

    I'm getting a unique error when I attempt to add an AutoNumber field to a table that I created. The table itself has ~110,000 records but it will not let me create an ID tag for the records so that I can create a primary key. The error reads "File sharing lock count exceeded. Increase...
  2. P

    Creating a SUM field

    I feel like this is a stupid question but here goes: I just created a large database of which a few fields are going to represent "total" fields as they are the sum of a few other fields. I attempted to build an expression in the "update to" box in an update query but it does not seem to be...
  3. P

    Maximum # of Fields for a Table?

    I understand that the maximum file size for an Access db is 2GB but can you essentially have as many fields as you like as long as you do not exceed the 2GB threshold? I am doing some planning for creating a database with ~90 fields and want to know before I start it whether it will be able to...
  4. P

    Printing Form w/ Multiple Subforms

    I'm running into an error when I print a form that I created. The form itself has 6 subforms fed from the master form (2 field feed), of which 4 of the subforms use the same table. I am trying to print out each record and I end up with duplicates of certain fields (directly underneath one...
Back
Top Bottom