Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>RE: sharing the database over the network</strong></p> <p>Yes, essentially all you really need to do is put the .accdb (or .mdb) file in a shared folder and tell your C# program where to find it. </p> <p>Notes:</p> <ol> <li><p>Each machine needs to have its own copy of the Access Database Engine installed. If Access is not already installed on the machine then you can download the Access Database Engine installer <a href="http://www.microsoft.com/en-US/download/details.aspx?id=13255" rel="nofollow">here</a>.</p></li> <li><p>For multiple concurrent users to access the database <strong>all</strong> users must have sufficient privileges to <strong>create and modify</strong> the associated .laccdb (or .ldb) lock file in the <strong>folder</strong> where the database file resides. That is, all users need more than just read access to the <em>folder</em>. (That is a common mistake people make when they first deploy an Access back-end for multiple concurrent users.)</p></li> </ol> <p><strong>RE: WiFi</strong></p> <p>The ACE/Jet database engine relies on a solid network connection to the database file, so any intermittent network glitches resulting from a weak WiFi signal are going to cause problems. In the early days of WiFi that was a common cause of errors in many database applications (including, but not limited to, Access databases). WiFi technology has improved over the years, so this is less of a problem than it used to be, but do be aware that flaky WiFi <em>can</em> cause errors (and even corrupt the database file if you are unlucky).</p>
    singulars
    1. This table or related slice is empty.
    1. POMake MS-Access database file accessible to C# program from LAN network
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USGord Thompson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMake MS-Access database file accessible to C# program from LAN network
      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. VTAcceptedByOriginator
    1. COThe second computer can read/write/delete/create files and folders in the shared folder where I will keep my database file. So, I assume that when you wrote: "all users must have sufficient privileges to create and modify the associated .laccdb (or .ldb) lock file". It means that should work if all above operation can be done. Or do I have to configure the database for privileges/users/network etc.?
      singulars
      1. PO
      1. USComputer User
    2. CO@Ankit Yes, if all users have read/create/write privileges on the folder then it should work fine.
      singulars
      1. PO
      1. USGord Thompson
    3. CO@ComputerUser There is no special configuration required for the database itself (assuming that we're not talking about an `.mdb` file with [user-level security](http://office.microsoft.com/en-ca/access-help/about-user-level-security-mdb-HP003070410.aspx) enabled). If the users have sufficient filesystem/share permissions on the database file and folder then it should "just work".
      singulars
      1. PO
      1. USGord Thompson
 

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