Search results

  1. J

    Solved VBA Database.Execute("CreateTable...") - Table created in CurrentDB, not the specified DB

    I have a front-end database that links tables from a couple of back-end databases (all MSACCESS/DAO). As part of a schema upgrade I executed the following: Dim dbLog As Database Set dbLog = ws.OpenDatabase(CurrentProject.path & "\" & "Log.accdb") ... dbLog.execute "create table...
  2. J

    Continuous form Allow Edits=False locks fields in form header

    I use unbound fields in a form header in a continuous form to allow users to enter filter criteria. This work well. However, this form doesn't allow changes to data (it's for users to select a row, which then opens in a dialog form), I want to set Allow Edits=False. When I do this, the...
    • jhg
    • Thread
    • Replies: 2
    • Forum: Forms
  3. J

    Multi-frontend performance?

    I have a split database with a single back-end accessed from two identical copies of a front-end. The back-end and front-ends are all located on a 1Gbps LAN. In this configuration, performance is abysmal because all query execution happens on the front-end systems, and involves shipping all...
  4. J

    Multi-user with network-shared FrontEnd?

    I have to update a split Access DB from single-user to multiple users. All persistent data is in the BE, FE contains the app plus a few tables that would be TEMPORARY if Access supported the concept. The client has access only to the runtime, not the development environment. I see three...
Back
Top Bottom