Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Do you actually <strong>need</strong> to find out if there is a newer version? </p> <p>We have a similar setup as well, and we just copy the frontend and all related files <strong>every time</strong> someone starts the application. </p> <p>Our users don't start Access or the frontend itself. They actually start a batch file which looks something like this:</p> <pre><code>@echo off xcopy x:\soft\frontend.mde c:\app\ /Y c:\app\frontend.mde </code></pre> <p>When we started writing our app, we thought about auto-updating as well and decided that just copying everything everytime is enough. </p> <p>We have enough bandwidth, so the copying doesn't create any performance problems (with about 200 users). </p> <p>Plus, it makes some things easier for me as a developer when I can be sure that each time the application is started, the frontend is overwritten anyway.<br> I don't have to care about auto-compacting the frontend when it's closed (and users complaining that closing the app takes too long...), and I don't have to deal with corrupted frontends after crashes.</p> <hr> <p><strong>@Lumis - concerning the custom icon:</strong><br> Ok, maybe I should have made this more clear. There is only <strong>one</strong> batch file, and it's in the same network folder as the frontend.<br> The users just have links on their desktops which all point to the same batch file in the network folder.<br> This means that:</p> <ol> <li>future changes to the batch file are easy, because it's only one single file in one central place</li> <li>we <strong>can</strong> change the icon, because what the user sees is a normal Windows link</li> </ol> <p><em>(By the way, we did <strong>not</strong> change the icon. Our app is for internal use only, and I'm working in a manufacturing company, which means that all but very few users are absolutely non-technical and couldn't care less about the icon, as long as it's the same on all machines and they know how it looks like so they can find it quickly on their desktop...)</em></p>
    singulars
    1. This table or related slice is empty.
    1. POHow to automatically update MS-Access 2007 application
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChristian Specht
    1. USChristian Specht
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to automatically update MS-Access 2007 application
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis solution works, but I cannot assing a custom icon to a batch file, which matters for a more user-friendly and professional look. I agree that when the user start the database once a day it is not too much data traffic.
      singulars
      1. PO
      1. USLumis
    2. COWhy had you considered auto-compacting (compact on close) the FE in the first place? If your app uses local tables for temporary data or user-specific data, put them in a separate local database and link to those tables from the FE. It seems highly unusual you would have any other reasons to compact an MDE FE. In any case, avoid auto-compact.
      singulars
      1. PO
      1. USHansUp
    3. CO@HansUp: Yes, only because of local tables. Good point though, we never thought of putting temp tables in a separate local database.
      singulars
      1. PO
      1. USChristian Specht
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload