Databases
StackOverflow2013
Usersdbo
USWim ten Brink
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USWim ten Brink
    primarykey
    data
    text
    <p>Software Engineer who almost never <a href="http://twitter.com/#!/wimtenbrink" rel="nofollow">tweets</a>.... </p> <p>Using a Dell Alienware laptop Quad-core system with 24 GB RAM and running Windows 8.1 Ultimate 64-bits plus an Alienware desktop PC with 6 cores, 32 GB RAM running Windows 8.1 Professional 64-bits with two 1920x1200 monitors to develop my own desktop applications, my own C# web applications, my own Python Apps for Google and for maintaining several of my own websites and domains. This is all just pure a hobby. </p> <p>BTW, I'm also a bit of an amateur at creating interesting CGI artwork, which basically means that I'm still keeping my art very simple. Less objects in the image generally means the rendering will be simpler and faster so as a result, some of my art is NSFW. Most is more like my gravatar. And some is pretty decent. :-) </p>
    plurals
    1. POCatching the dreaded Blue Screen Of Death
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I have an button call a server function and then update an update panel?
      1. USWim ten Brink
      1. VTFavorite
    2. VO
      singulars
      1. POhow to write with LinQ to SQL?
      1. USWim ten Brink
      1. VTFavorite
    3. VO
      singulars
      1. POIs there a standard open icon library for web developers?
      1. USWim ten Brink
      1. VTFavorite
    1. COIf you want to connect to Access through Java, then I think the easiest solution would be by creating your own service around the Access database that you want to make available. Web service, Windows service or just a COM class. there are just too many techniques to share a database. But they do require you to write additional code. (But that's more a limitation in Java, not Access.) To access the DB through HTTP, build a web service and expose some methods to manipulate the data.
      singulars
      1. PO
      1. USWim ten Brink
    2. COAnother solution would be by putting the DB on a shared disk. A project I worked on is used by some users on a shared harddisk, with multiple users connecting to the same database, every user on their own system. We even have users who installed out product on a Terminal Server and then use remote desktops to start the application and to connect to the Access database. We want to help these users by migrating the whole project to use SQL Server but that takes a lot of time.
      singulars
      1. PO
      1. USWim ten Brink
    3. COI've seen the post. The problem is clear: how to access an Access database remotely. The post talks about Java and Java doesn't provide much functionality to do this. But connecting to a remote Access DB is possible through several other techniques. Access won't work over named pipes, but you could create a service that would run on the same system as the DB and access this service through named pipes. But TCP/IP would be a better solution. Another technique might be through COM/ADO by creating an ADO connection on the remote system, but this isn't easy.
      singulars
      1. PO
      1. USWim ten Brink
 

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