Split DB over network

[Marek]

Hi,

I have a DB sitting on a server. It's split - back end
sits on server, front end on user's pc. I have 5 users.
The network it is running on is a little unreliable - does
anyone know how I can test the network connection -
perhaps quite simply open a linked table in a recordset
and trap the error - 3024 I think it is. Is this a good
way?

Perhaps I can record data in a local table, then
periodically write it to the server tables - at least
users can continue to work.

I want to try and avoid replication - not sure how
reliable that is.

Many thanks for any advice.

Marek

 

[Bruce M. Thompson]

I have a DB sitting on a server. It's split - back end

sits on server, front end on user's pc. I have 5 users.
The network it is running on is a little unreliable - does
anyone know how I can test the network connection -
perhaps quite simply open a linked table in a recordset
and trap the error - 3024 I think it is. Is this a good
way?

I would fix the network problem to avoid corrupting the back end file. Period.