Re: [ILUG] mere samba&access horror
On Mon, Sep 04, 2000 at 01:59:44PM +0100, Kenn Humborg wrote:
> > Thanks the responses to everyone who helped me to solve the mapping
> > problem. But this Access stuff sucks ! I'm going mad. When I want to
> > access the databases stored on the server frm more then one client it
> > rejects to map the drive and the access program gives me the "Runtime
> > error" message.
>
> Huh? Access doesn't "map drives". Windows Explorer or the 'net use'
> command map drives.
It does if you use linked tables [front-end, back-end] (via the common
dialog OpenFile thingy). This can easily be gotten around by pathing
each of the link tables with the network share path
(\\servera\shareb\dir1\dumbfile.mdb). IMHO, the whole drive letter
thing with Windows is completely brain damaged in a network environment.
Access is not useful as a networked database system, it's page level
locking creates all kinds of conflict situations and it's not very
robust when multiple users (> 1) are editing data simultaneously.
Better to port the backend to a real database server. Anyway, this is
way off-topic now...
--
/bin/sh ~/.signature:
Command not found
Reply to: