Posted by Greg D. Moore \(Strider\) on 10/01/06 11:24

"Scott McDaniel" <scott@infotrakkerDELETEME.com> wrote in message
news:D_-dneH90r1TQJjeRVn-3w@comcast.com...
> 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.

Look into them using the MSDE.


>
> "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
> >
>
>

[Back to original message]