[Hidden-tech] MS Access Questions

[Aaron Smith]

For what it's worth, there's not really a lower scale limit at which MySQL
makes less sense - the installation and setup of the software and database
(not counting the migration of data itself, or complicated permissions
setups) can be done in under an hour, from a cold start, on a bad day. I
would think nothing of setting up an instance for a project that has any
relational data at all, be it 10 records or millions. I'm not familiar with
SQL Server, though.

On Mon, Nov 23, 2015 at 1:10 PM, Adrienne LaPierre <
lapierre.adrienne at gmail.com> wrote:

>
>
>
>
> Thanks to Allen, Doug, and Jeff for pointing me toward SQL/MySQL.  I
> understand the big picture better now.  It seems that this would be the
> logical path for a host of reasons with security at the top of the list.
> However, the database I'm referencing is very small (< 600 records, not
> sure how many tables are involved, majority of the records are archived)
> and from what I can tell SQL makes a lot less sense at this scale.
>
> Allen--not being able to find Office 2010 from a reputable third party
> seller is precisely my problem.  We're getting three new computers, but
> only one of the old computers is being taken out of service.  The others
> are just being transferred to new employees who also need Office 2010.  I
> see lots of totally untrustworthy sites offering 2010 but nowhere I would
> actually purchase from.
>
> So can anyone recommend a reputable seller of Office 2010 Professional?
>
>
>
> On Fri, Nov 20, 2015 at 1:44 PM, Allen Belkin <albelkin at comcast.net>
> wrote:
>
>>
>>
>>
>>
>> Hi Adrienne,
>>
>>
>>
>> My general recommendation is to not be in a rush to upgrade anything unless there is good reason. This is especially true of recently-released versions. I’m also going to try to stick with Windows 7 as long as I can – I don’t think any of my business clients have upgraded to Windows 8 or 10.
>>
>>
>>
>> I’d also be careful about moving to the cloud. The main drawbacks are that you are totally dependent on a good internet connection, and that you are putting you data in the hands of a large, far-away corporation. Advantages are off-site access to your data (if you need it, though there are other ways of accomplishing that) and possible lower cost of hardware, infrastructure and maintenance (though you’d want to look carefully at the big picture regarding costs). I’ve been finding Office 365 in particular to be real flaky – often it won’t accept my login and then an hour later, it does.
>>
>>
>>
>> I believe Microsoft Office 2010 is no longer sold separately by Microsoft but is available through third-parties or on some of the Microsoft subscriptions. If you are taking the old computers out of service, or don’t need Office 2010 on them, you should be able to transfer the licenses.
>>
>>
>>
>> I agree with Doug and Jeff – Microsoft Acccess databases are not considered secure and an upgrade to SQL Server (or an open source client-server database such as MySQL or PostGreSQL) is what you need to be HIPAA-compliant. You’ll be able to use the same front-end, but it will require some tweaks.
>>
>>
>>
>> Best regards,
>>
>> Allen
>>
>>
>>
>> Allen Belkin
>>
>> *Custom Software Solutions*
>>
>> PO Box 60144, Florence, MA 01062
>>
>> E-mail:  albelkin at comcast.net
>>
>> Phone:  (413) 552-9080
>>
>>
>>
>> _______________________________________________
>> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
>> Hidden-discuss at lists.hidden-tech.net
>>
>> You are receiving this because you are on the Hidden-Tech Discussion list.
>> If you would like to change your list preferences, Go to the Members
>> page on the Hidden Tech Web site.
>> http://www.hidden-tech.net/members
>>
>
>
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20151123/a578e510/attachment.html