Search results

  1. J

    Limit number of fields returned by ODBC table

    Hi all, I've searched this with no success. I have a ODBC (Firebird) table linked using a DSN connection which has >300 fields. In Access, the linked table only show 256 fields (max for Access). Otherwise the link works fine. I have no control over the source Firebird table. What I'd like...
  2. J

    Can one field in Master Table refer to >1 Child Tables?

    Hi everyone, I have a table design question. I have a Master table tblData: DataKey (PK) CalibrationKey (foreign key) Various data fields . . I want the CalibrationKey to be able to refer to >1 possible calibratioin tables, since there are several possible calibration protocols. Each...
    • jwol
    • Thread
    • Replies: 1
    • Forum: Tables
  3. J

    Maintaining front-ends w. different versions

    Hello all, We are slowly making the conversion from A97 to A2000 and I've been reseaching how best to handle the transition. Currently we have a front-end/back-end setup, both A97, both on the network. The FE is an .mdb. From the archives it seems the accepted strategy is to leave the BE in...
  4. J

    Printing resets Subform defaults

    Hello all, I'm trying to print a form w. subform, but on the DoCmd.Printout all the subform controls display their default values. The screen values remain as they should. This occurs for the simplest case possible, a subform w. only a text box on a form w. only a Print button (give it a...
Back
Top Bottom