|
|
Posted by Scott McDaniel on 10/01/38 11:24
Thanks for your reply. We considered moving totally to SQL Server, but users
will not always have Internet access. There are several text columns (none
over 500 characters) and no image columns, pretty much plain jane numeric
and text data.
"Simon Hayes" <sql@hayes.ch> wrote in message
news:1124456267.588573.89760@f14g2000cwb.googlegroups.com...
> I'm not sure what you mean by "reliably" - if the workstations connect
> to the MSSQL server, then they're just another client, so they will be
> as reliable as your network, application code etc allow. And a hundred
> rows is a very small amount of data, unless perhaps you have to work
> with text or image columns.
>
> Personally, I would consider removing Access altogether, and use a
> single MSSQL database - no sync required, one point of backup and
> recovery, better security etc. But of course that may be a bigger
> change than you're willing or able to make in your environment.
>
> Simon
>
Navigation:
[Reply to this message]
|