<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tim Roberts wrote:<br>
<blockquote cite="mid45EDAFEF.1070406@probo.com" type="cite">
<pre wrap="">Access is trouble any time you have more than about 2 people using a
single database. It just wasn't designed for that environment.
</pre>
</blockquote>
I know, I know... just imagine that before accepting this job I didn't
even know Access *could* be used *like* one, I always thought it was
like a toy sqlite with fancy UI for single users.<br>
<br>
<blockquote cite="mid45EDAFEF.1070406@probo.com" type="cite">
<pre wrap="">Surely it would be MUCH less trouble to move the backend to Postgres,
SQLite, or even SQL Server Express, all of which are free.
</pre>
</blockquote>
Indeed, which is what I'm going to do in the long term, rewrite the
application.<br>
<br>
<blockquote cite="mid45EDAFEF.1070406@probo.com" type="cite">
<pre wrap="">Is the original application in Access? Or is it another language that
just happens to use the Jet database? What API does it use to talk to
the database?
</pre>
</blockquote>
It is just a VB without source code which talks to the database through
a DNSless connection, which really means I can't do what I was
proposing, since that would mean changing the original VB application
to use a specific ODBC, and I can't. I'm just asking because I'm
curious about this sort of serializing gateway "architecture".<br>
<br>
In fact, does sqlite run on windows with multiple writers shared
through SMB? I know sqlite works with multiple writers, but my
experience so far is only under linux, so I would like to know if that
works on windows the same way or there are problems like the horror
stories I've heard about NFS locking.<br>
<br>
Any weird suggestions appreciated, not doing anything real here, just
toying with the idea of doing something perverse (if using Access
wasn't enough!).<br>
<br>
<div class="moz-signature">-- <br>
<table
style="border-color: red; border-bottom: 3pt solid red; padding-bottom: 0cm; padding-top: 0cm;"
border="0" cellpadding="4" cellspacing="4">
<tbody>
<tr>
<td valign="top"> <img alt="Rastertech España S.A."
src="cid:part1.00090209.00070005@rastertech.es" border="0"><br>
</td>
<td valign="top" width="100%"> <font
style="font-family: Arial,Helvetica; text-align: left;" color="#000e78"
size="1"> Grzegorz Adam Hankiewicz<br>
<em>Jefe de Producto TeraVial</em></font>
<p><font style="font-family: Arial,Helvetica; text-align: left;"
color="#000e78" size="1"> C/ Perfumería 21. Nave I. Polígono
industrial La Mina<br>
28770 Colmenar Viejo. Madrid (España) </font><br>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td><font
style="font-family: Arial,Helvetica; text-align: left;" color="#000e78"
size="1">Tel. +34 918 467 390 (Ext.18)</font></td>
<td> <b>·</b> </td>
<td><font
style="font-family: Arial,Helvetica; text-align: left;" color="#000e78"
size="1">Fax +34 918 457 889</font></td>
</tr>
<tr>
<td><font
style="font-family: Arial,Helvetica; text-align: left;" color="#000e78"
size="1"><a href="ghankiewicz@rastertech.es">ghankiewicz@rastertech.es</a></font></td>
<td> <b>·</b> </td>
<td><font
style="font-family: Arial,Helvetica; text-align: left;" color="#000e78"
size="1"><a href="http://www.rastertech.es/">www.rastertech.es</a></font></td>
</tr>
</tbody>
</table>
</p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>