Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
It has a built in report generator, but you are probably right that it will
be faster to work in excel if you are not familiar with it. If you run your
query, the result table will be a lot like excel. Click the top left corner
to select all then right click to copy or copy with headers. Then it is an
easy paste into excel.

Cameron

On Wed, May 25, 2016 at 2:29 PM, Chuck McCown <ch...@wbmfg.com> wrote:

> I actually have SQL running on the real live DB and my query is working.
> Thanks for the suggestions.
> I did a cut and paste into excel from the query.  Not sure if it will
> create a report.  Have not seen that option yet.
> But excel gives me the tools I need.
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Wednesday, May 25, 2016 1:24 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> is it a .bak file or just and mdf?
>
> On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <ch...@wbmfg.com> wrote:
>
>> I think I would probably have to set up a new database and import the
>> backup into it.
>>
>> *From:* Cameron Crum <cc...@wispmon.com>
>> *Sent:* Wednesday, May 25, 2016 11:04 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>> I'm not sure how you write queries to a database without accessing it?
>>
>> On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>
>>> It is just an exported database backup file.  An mdb file.
>>> I don’t trust myself with actually accessing the database.
>>>
>>> *From:* Cameron Crum <cc...@wispmon.com>
>>> *Sent:* Wednesday, May 25, 2016 10:52 AM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>> Right click on Databases and select Attach.
>>>
>>> On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>>
>>>> Not seeing the import option...
>>>>
>>>> *From:* Cameron Crum <cc...@wispmon.com>
>>>> *Sent:* Wednesday, May 25, 2016 8:45 AM
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>> Yeah...easy to do with Sql Express, but make sure you get SQL Server
>>>> Management Studio as well. Once installed, open management studio and
>>>> import your DB. Select the DB and then click the "New Query" "button" at
>>>> the top. Make sure the little pull down shows your database as the default
>>>> "master" is sometimes in there if you haven't run a query yet. Now type
>>>> your query and hit the "Execute" button.
>>>>
>>>>
>>>>
>>>> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>>>
>>>>> Just want to write some custom query/reports.
>>>>>
>>>>> *From:* Cameron Crum <cc...@wispmon.com>
>>>>> *Sent:* Tuesday, May 24, 2016 7:26 PM
>>>>> *To:* af@afmug.com
>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>
>>>>> Maybe SQLServer Express? It's free. I guess it depends on what you are
>>>>> doing with database.
>>>>>
>>>>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
>>>>> li...@smarterbroadband.com> wrote:
>>>>>
>>>>>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>>>>>
>>>>>>
>>>>>>
>>>>>> This is interesting for people who need occasional access.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Get started with Office Online now*
>>>>>>
>>>>>> No install required. Choose your favorite app. It's free.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>>>>>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>>>>>
>>>>>> *To:* af@afmug.com
>>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>>
>>>>>>
>>>>>>
>>>>>> Does that mean c

Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
I actually have SQL running on the real live DB and my query is working.  
Thanks for the suggestions.  
I did a cut and paste into excel from the query.  Not sure if it will create a 
report.  Have not seen that option yet.
But excel gives me the tools I need.  

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 1:24 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

is it a .bak file or just and mdf?

On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <ch...@wbmfg.com> wrote:

  I think I would probably have to set up a new database and import the backup 
into it.  

  From: Cameron Crum 
  Sent: Wednesday, May 25, 2016 11:04 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  I'm not sure how you write queries to a database without accessing it? 

  On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:

It is just an exported database backup file.  An mdb file.
I don’t trust myself with actually accessing the database.  

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 10:52 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Right click on Databases and select Attach. 

On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  Not seeing the import option...

  From: Cameron Crum 
  Sent: Wednesday, May 25, 2016 8:45 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Yeah...easy to do with Sql Express, but make sure you get SQL Server 
Management Studio as well. Once installed, open management studio and import 
your DB. Select the DB and then click the "New Query" "button" at the top. Make 
sure the little pull down shows your database as the default "master" is 
sometimes in there if you haven't run a query yet. Now type your query and hit 
the "Execute" button.  



  On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

Just want to write some custom query/reports.

From: Cameron Crum 
Sent: Tuesday, May 24, 2016 7:26 PM
    To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Maybe SQLServer Express? It's free. I guess it depends on what you are 
doing with database. 

On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband 
<li...@smarterbroadband.com> wrote:

  Home, maybe.  Looks like it.  I’m just reading the web page.



  This is interesting for people who need occasional access.



  
https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



  Get started with Office Online now

  No install required. Choose your favorite app. It's free.





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:35 PM


  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives


  Does that mean concurrent logins?  That is pretty important in my 
application.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:31 PM

      To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  The home version covers 5 seats and is only $99 a year…..



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:24 PM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  No, $12/month total for 5 seats.  

  They say 5 computers.  One would hope concurrent logins.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:20 PM

      To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  That is $12 per seat?  

  Yes, 5 PC but I think only one login?



  · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per 
user





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 8:48 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  I looked at those.  Not thrilled.  I may just go with 365.  $12/month 
for 5 seats.  Not terrible.  



  From: Josh Luthman 

  Sent: Tuesday, May 24, 2016 9:42 AM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  
http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





  Josh Luthman
  Office: 937-552-2340
  Direct: 937-552-2343
  1100 Wayne St
  Suite 1337
  Troy, OH 45373



  On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> 
wrote:

  We’ve an Office365 for this. Keeping Office up to

  date is more expensive than renting it.



Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
*an mdf

On Wed, May 25, 2016 at 2:24 PM, Cameron Crum <cc...@wispmon.com> wrote:

> is it a .bak file or just and mdf?
>
> On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <ch...@wbmfg.com> wrote:
>
>> I think I would probably have to set up a new database and import the
>> backup into it.
>>
>> *From:* Cameron Crum <cc...@wispmon.com>
>> *Sent:* Wednesday, May 25, 2016 11:04 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>> I'm not sure how you write queries to a database without accessing it?
>>
>> On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>
>>> It is just an exported database backup file.  An mdb file.
>>> I don’t trust myself with actually accessing the database.
>>>
>>> *From:* Cameron Crum <cc...@wispmon.com>
>>> *Sent:* Wednesday, May 25, 2016 10:52 AM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>> Right click on Databases and select Attach.
>>>
>>> On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>>
>>>> Not seeing the import option...
>>>>
>>>> *From:* Cameron Crum <cc...@wispmon.com>
>>>> *Sent:* Wednesday, May 25, 2016 8:45 AM
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>> Yeah...easy to do with Sql Express, but make sure you get SQL Server
>>>> Management Studio as well. Once installed, open management studio and
>>>> import your DB. Select the DB and then click the "New Query" "button" at
>>>> the top. Make sure the little pull down shows your database as the default
>>>> "master" is sometimes in there if you haven't run a query yet. Now type
>>>> your query and hit the "Execute" button.
>>>>
>>>>
>>>>
>>>> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>>>
>>>>> Just want to write some custom query/reports.
>>>>>
>>>>> *From:* Cameron Crum <cc...@wispmon.com>
>>>>> *Sent:* Tuesday, May 24, 2016 7:26 PM
>>>>> *To:* af@afmug.com
>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>
>>>>> Maybe SQLServer Express? It's free. I guess it depends on what you are
>>>>> doing with database.
>>>>>
>>>>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
>>>>> li...@smarterbroadband.com> wrote:
>>>>>
>>>>>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>>>>>
>>>>>>
>>>>>>
>>>>>> This is interesting for people who need occasional access.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Get started with Office Online now*
>>>>>>
>>>>>> No install required. Choose your favorite app. It's free.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>>>>>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>>>>>
>>>>>> *To:* af@afmug.com
>>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>>
>>>>>>
>>>>>>
>>>>>> Does that mean concurrent logins?  That is pretty important in my
>>>>>> application.
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>>>>
>>>>>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>>>>>
>>>>>> *To:* af@afmug.com
>>>>>>
>>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>>
>>>>>>
>>>>>>
>>>>>> The home version covers 5 seats and is only $99 a year…..
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Af [mailto:af-boun...@afmug.com 

Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
is it a .bak file or just and mdf?

On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <ch...@wbmfg.com> wrote:

> I think I would probably have to set up a new database and import the
> backup into it.
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Wednesday, May 25, 2016 11:04 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> I'm not sure how you write queries to a database without accessing it?
>
> On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>
>> It is just an exported database backup file.  An mdb file.
>> I don’t trust myself with actually accessing the database.
>>
>> *From:* Cameron Crum <cc...@wispmon.com>
>> *Sent:* Wednesday, May 25, 2016 10:52 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>> Right click on Databases and select Attach.
>>
>> On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>
>>> Not seeing the import option...
>>>
>>> *From:* Cameron Crum <cc...@wispmon.com>
>>> *Sent:* Wednesday, May 25, 2016 8:45 AM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>> Yeah...easy to do with Sql Express, but make sure you get SQL Server
>>> Management Studio as well. Once installed, open management studio and
>>> import your DB. Select the DB and then click the "New Query" "button" at
>>> the top. Make sure the little pull down shows your database as the default
>>> "master" is sometimes in there if you haven't run a query yet. Now type
>>> your query and hit the "Execute" button.
>>>
>>>
>>>
>>> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>>
>>>> Just want to write some custom query/reports.
>>>>
>>>> *From:* Cameron Crum <cc...@wispmon.com>
>>>> *Sent:* Tuesday, May 24, 2016 7:26 PM
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>> Maybe SQLServer Express? It's free. I guess it depends on what you are
>>>> doing with database.
>>>>
>>>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
>>>> li...@smarterbroadband.com> wrote:
>>>>
>>>>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>>>>
>>>>>
>>>>>
>>>>> This is interesting for people who need occasional access.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>>>>
>>>>>
>>>>>
>>>>> *Get started with Office Online now*
>>>>>
>>>>> No install required. Choose your favorite app. It's free.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>>>>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>>>>
>>>>> *To:* af@afmug.com
>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>
>>>>>
>>>>>
>>>>> Does that mean concurrent logins?  That is pretty important in my
>>>>> application.
>>>>>
>>>>>
>>>>>
>>>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>>>
>>>>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>>>>
>>>>> *To:* af@afmug.com
>>>>>
>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>
>>>>>
>>>>>
>>>>> The home version covers 5 seats and is only $99 a year…..
>>>>>
>>>>>
>>>>>
>>>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>>>>> Behalf Of *Chuck McCown
>>>>> *Sent:* Tuesday, May 24, 2016 3:24 PM
>>>>> *To:* af@afmug.com
>>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>>
>>>>>
>>>>>
>>>>> No, $12/month total for 5 seats.
>>>>>
>>>>> They say 5 computers.  One would hope concurrent logins.
>>>>>
>>>>>
>&g

Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
I think I would probably have to set up a new database and import the backup 
into it.  

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 11:04 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

I'm not sure how you write queries to a database without accessing it? 

On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  It is just an exported database backup file.  An mdb file.
  I don’t trust myself with actually accessing the database.  

  From: Cameron Crum 
  Sent: Wednesday, May 25, 2016 10:52 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Right click on Databases and select Attach. 

  On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:

Not seeing the import option...

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 8:45 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Yeah...easy to do with Sql Express, but make sure you get SQL Server 
Management Studio as well. Once installed, open management studio and import 
your DB. Select the DB and then click the "New Query" "button" at the top. Make 
sure the little pull down shows your database as the default "master" is 
sometimes in there if you haven't run a query yet. Now type your query and hit 
the "Execute" button.  



On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  Just want to write some custom query/reports.

  From: Cameron Crum 
  Sent: Tuesday, May 24, 2016 7:26 PM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Maybe SQLServer Express? It's free. I guess it depends on what you are 
doing with database. 

  On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband 
<li...@smarterbroadband.com> wrote:

Home, maybe.  Looks like it.  I’m just reading the web page.



This is interesting for people who need occasional access.




https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



Get started with Office Online now

No install required. Choose your favorite app. It's free.





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:35 PM


    To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives


Does that mean concurrent logins?  That is pretty important in my 
application.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:31 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



The home version covers 5 seats and is only $99 a year…..



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
    To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:20 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



That is $12 per seat?  

Yes, 5 PC but I think only one login?



· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per 
user





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



I looked at those.  Not thrilled.  I may just go with 365.  $12/month 
for 5 seats.  Not terrible.  



From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives




http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373



On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> 
wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.







Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
    An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives



I tried to open and edit an mdb file with Libre and it keeps crashing.  
Hate to go buy access.  Any alternatives that actually work?








Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
I'm not sure how you write queries to a database without accessing it?

On Wed, May 25, 2016 at 11:53 AM, Chuck McCown <ch...@wbmfg.com> wrote:

> It is just an exported database backup file.  An mdb file.
> I don’t trust myself with actually accessing the database.
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Wednesday, May 25, 2016 10:52 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> Right click on Databases and select Attach.
>
> On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>
>> Not seeing the import option...
>>
>> *From:* Cameron Crum <cc...@wispmon.com>
>> *Sent:* Wednesday, May 25, 2016 8:45 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>> Yeah...easy to do with Sql Express, but make sure you get SQL Server
>> Management Studio as well. Once installed, open management studio and
>> import your DB. Select the DB and then click the "New Query" "button" at
>> the top. Make sure the little pull down shows your database as the default
>> "master" is sometimes in there if you haven't run a query yet. Now type
>> your query and hit the "Execute" button.
>>
>>
>>
>> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>>
>>> Just want to write some custom query/reports.
>>>
>>> *From:* Cameron Crum <cc...@wispmon.com>
>>> *Sent:* Tuesday, May 24, 2016 7:26 PM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>> Maybe SQLServer Express? It's free. I guess it depends on what you are
>>> doing with database.
>>>
>>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
>>> li...@smarterbroadband.com> wrote:
>>>
>>>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>>>
>>>>
>>>>
>>>> This is interesting for people who need occasional access.
>>>>
>>>>
>>>>
>>>>
>>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>>>
>>>>
>>>>
>>>> *Get started with Office Online now*
>>>>
>>>> No install required. Choose your favorite app. It's free.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>>>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>>>
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> Does that mean concurrent logins?  That is pretty important in my
>>>> application.
>>>>
>>>>
>>>>
>>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>>
>>>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>>>
>>>> *To:* af@afmug.com
>>>>
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> The home version covers 5 seats and is only $99 a year…..
>>>>
>>>>
>>>>
>>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>>>> Behalf Of *Chuck McCown
>>>> *Sent:* Tuesday, May 24, 2016 3:24 PM
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> No, $12/month total for 5 seats.
>>>>
>>>> They say 5 computers.  One would hope concurrent logins.
>>>>
>>>>
>>>>
>>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>>
>>>> *Sent:* Tuesday, May 24, 2016 4:20 PM
>>>>
>>>> *To:* af@afmug.com
>>>>
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> That is $12 per seat?
>>>>
>>>> Yes, 5 PC but I think only one login?
>>>>
>>>>
>>>>
>>>> · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per
>>>> user
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>>>> Behalf Of *Chuck McCown
>>>> *Sent:* Tuesday, May 24, 2016 8:48 AM
>>>> *To:* af@afmug.com
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> I looked at those.  Not thrilled.  I may just go with 365.  $12/month
>>>> for 5 seats.  Not terrible.
>>>>
>>>>
>>>>
>>>> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>>>>
>>>> *Sent:* Tuesday, May 24, 2016 9:42 AM
>>>>
>>>> *To:* af@afmug.com
>>>>
>>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>>
>>>> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Josh Luthman
>>>> Office: 937-552-2340
>>>> Direct: 937-552-2343
>>>> 1100 Wayne St
>>>> Suite 1337
>>>> Troy, OH 45373
>>>>
>>>>
>>>>
>>>> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net>
>>>> wrote:
>>>>
>>>> We’ve an Office365 for this. Keeping Office up to
>>>>
>>>> date is more expensive than renting it.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
>>>> *Gesendet:* Dienstag, 24. Mai 2016 17:30
>>>> *An:* af@afmug.com
>>>> *Betreff:* [AFMUG] OT MS Access alternatives
>>>>
>>>>
>>>>
>>>> I tried to open and edit an mdb file with Libre and it keeps crashing.
>>>> Hate to go buy access.  Any alternatives that actually work?
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
It is just an exported database backup file.  An mdb file.
I don’t trust myself with actually accessing the database.  

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 10:52 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Right click on Databases and select Attach. 

On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  Not seeing the import option...

  From: Cameron Crum 
  Sent: Wednesday, May 25, 2016 8:45 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Yeah...easy to do with Sql Express, but make sure you get SQL Server 
Management Studio as well. Once installed, open management studio and import 
your DB. Select the DB and then click the "New Query" "button" at the top. Make 
sure the little pull down shows your database as the default "master" is 
sometimes in there if you haven't run a query yet. Now type your query and hit 
the "Execute" button.  



  On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

Just want to write some custom query/reports.

From: Cameron Crum 
Sent: Tuesday, May 24, 2016 7:26 PM
    To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Maybe SQLServer Express? It's free. I guess it depends on what you are 
doing with database. 

On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband 
<li...@smarterbroadband.com> wrote:

  Home, maybe.  Looks like it.  I’m just reading the web page.



  This is interesting for people who need occasional access.



  
https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



  Get started with Office Online now

  No install required. Choose your favorite app. It's free.





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:35 PM


  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives


  Does that mean concurrent logins?  That is pretty important in my 
application.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:31 PM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  The home version covers 5 seats and is only $99 a year…..



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:24 PM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  No, $12/month total for 5 seats.  

  They say 5 computers.  One would hope concurrent logins.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:20 PM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  That is $12 per seat?  

  Yes, 5 PC but I think only one login?



  · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 8:48 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 
5 seats.  Not terrible.  



  From: Josh Luthman 

  Sent: Tuesday, May 24, 2016 9:42 AM

      To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  
http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





  Josh Luthman
  Office: 937-552-2340
  Direct: 937-552-2343
  1100 Wayne St
  Suite 1337
  Troy, OH 45373



  On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> 
wrote:

  We’ve an Office365 for this. Keeping Office up to

  date is more expensive than renting it.







  Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
  Gesendet: Dienstag, 24. Mai 2016 17:30
      An: af@afmug.com
  Betreff: [AFMUG] OT MS Access alternatives



  I tried to open and edit an mdb file with Libre and it keeps crashing.  
Hate to go buy access.  Any alternatives that actually work?







Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
Right click on Databases and select Attach.

On Wed, May 25, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:

> Not seeing the import option...
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Wednesday, May 25, 2016 8:45 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> Yeah...easy to do with Sql Express, but make sure you get SQL Server
> Management Studio as well. Once installed, open management studio and
> import your DB. Select the DB and then click the "New Query" "button" at
> the top. Make sure the little pull down shows your database as the default
> "master" is sometimes in there if you haven't run a query yet. Now type
> your query and hit the "Execute" button.
>
>
>
> On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:
>
>> Just want to write some custom query/reports.
>>
>> *From:* Cameron Crum <cc...@wispmon.com>
>> *Sent:* Tuesday, May 24, 2016 7:26 PM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>> Maybe SQLServer Express? It's free. I guess it depends on what you are
>> doing with database.
>>
>> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
>> li...@smarterbroadband.com> wrote:
>>
>>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>>
>>>
>>>
>>> This is interesting for people who need occasional access.
>>>
>>>
>>>
>>>
>>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>>
>>>
>>>
>>> *Get started with Office Online now*
>>>
>>> No install required. Choose your favorite app. It's free.
>>>
>>>
>>>
>>>
>>>
>>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>>
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> Does that mean concurrent logins?  That is pretty important in my
>>> application.
>>>
>>>
>>>
>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>
>>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>>
>>> *To:* af@afmug.com
>>>
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> The home version covers 5 seats and is only $99 a year…..
>>>
>>>
>>>
>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>>> Behalf Of *Chuck McCown
>>> *Sent:* Tuesday, May 24, 2016 3:24 PM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> No, $12/month total for 5 seats.
>>>
>>> They say 5 computers.  One would hope concurrent logins.
>>>
>>>
>>>
>>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>>
>>> *Sent:* Tuesday, May 24, 2016 4:20 PM
>>>
>>> *To:* af@afmug.com
>>>
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> That is $12 per seat?
>>>
>>> Yes, 5 PC but I think only one login?
>>>
>>>
>>>
>>> · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per
>>> user
>>>
>>>
>>>
>>>
>>>
>>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>>> Behalf Of *Chuck McCown
>>> *Sent:* Tuesday, May 24, 2016 8:48 AM
>>> *To:* af@afmug.com
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> I looked at those.  Not thrilled.  I may just go with 365.  $12/month
>>> for 5 seats.  Not terrible.
>>>
>>>
>>>
>>> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>>>
>>> *Sent:* Tuesday, May 24, 2016 9:42 AM
>>>
>>> *To:* af@afmug.com
>>>
>>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>>
>>> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>>>
>>>
>>>
>>>
>>>
>>> Josh Luthman
>>> Office: 937-552-2340
>>> Direct: 937-552-2343
>>> 1100 Wayne St
>>> Suite 1337
>>> Troy, OH 45373
>>>
>>>
>>>
>>> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net>
>>> wrote:
>>>
>>> We’ve an Office365 for this. Keeping Office up to
>>>
>>> date is more expensive than renting it.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
>>> *Gesendet:* Dienstag, 24. Mai 2016 17:30
>>> *An:* af@afmug.com
>>> *Betreff:* [AFMUG] OT MS Access alternatives
>>>
>>>
>>>
>>> I tried to open and edit an mdb file with Libre and it keeps crashing.
>>> Hate to go buy access.  Any alternatives that actually work?
>>>
>>>
>>>
>>
>>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
Not seeing the import option...

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 8:45 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Yeah...easy to do with Sql Express, but make sure you get SQL Server Management 
Studio as well. Once installed, open management studio and import your DB. 
Select the DB and then click the "New Query" "button" at the top. Make sure the 
little pull down shows your database as the default "master" is sometimes in 
there if you haven't run a query yet. Now type your query and hit the "Execute" 
button.  



On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  Just want to write some custom query/reports.

  From: Cameron Crum 
  Sent: Tuesday, May 24, 2016 7:26 PM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Maybe SQLServer Express? It's free. I guess it depends on what you are doing 
with database. 

  On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband 
<li...@smarterbroadband.com> wrote:

Home, maybe.  Looks like it.  I’m just reading the web page.



This is interesting for people who need occasional access.




https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



Get started with Office Online now

No install required. Choose your favorite app. It's free.





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:35 PM


To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives


Does that mean concurrent logins?  That is pretty important in my 
application.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:31 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



The home version covers 5 seats and is only $99 a year…..



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:20 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



That is $12 per seat?  

Yes, 5 PC but I think only one login?



· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
    To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  



From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives




http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373



On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.







Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives



I tried to open and edit an mdb file with Libre and it keeps crashing.  
Hate to go buy access.  Any alternatives that actually work?






Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
Downloaded and installed it.  Boy oh boy are there a ton of apps.  Found 
management studio.  Trying to puzzle it out.  

From: Cameron Crum 
Sent: Wednesday, May 25, 2016 8:45 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Yeah...easy to do with Sql Express, but make sure you get SQL Server Management 
Studio as well. Once installed, open management studio and import your DB. 
Select the DB and then click the "New Query" "button" at the top. Make sure the 
little pull down shows your database as the default "master" is sometimes in 
there if you haven't run a query yet. Now type your query and hit the "Execute" 
button.  



On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

  Just want to write some custom query/reports.

  From: Cameron Crum 
  Sent: Tuesday, May 24, 2016 7:26 PM
  To: af@afmug.com 
  Subject: Re: [AFMUG] OT MS Access alternatives

  Maybe SQLServer Express? It's free. I guess it depends on what you are doing 
with database. 

  On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband 
<li...@smarterbroadband.com> wrote:

Home, maybe.  Looks like it.  I’m just reading the web page.



This is interesting for people who need occasional access.




https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



Get started with Office Online now

No install required. Choose your favorite app. It's free.





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:35 PM


To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives


Does that mean concurrent logins?  That is pretty important in my 
application.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:31 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



The home version covers 5 seats and is only $99 a year…..



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  



From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:20 PM

    To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



That is $12 per seat?  

Yes, 5 PC but I think only one login?



· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
    To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  



From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives




http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373



On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.







Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives



I tried to open and edit an mdb file with Libre and it keeps crashing.  
Hate to go buy access.  Any alternatives that actually work?






Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Jon Auer
Home version supports multiple discrete users.
You invite family members (different Microsoft/Live ID) through the web
page where you download the installer and change your payment info.
On May 24, 2016 17:35, "Chuck McCown" <ch...@wbmfg.com> wrote:

> Does that mean concurrent logins?  That is pretty important in my
> application.
>
> *From:* SmarterBroadband <li...@smarterbroadband.com>
> *Sent:* Tuesday, May 24, 2016 4:31 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
> The home version covers 5 seats and is only $99 a year…..
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
> *Sent:* Tuesday, May 24, 2016 3:24 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> No, $12/month total for 5 seats.
>
> They say 5 computers.  One would hope concurrent logins.
>
>
>
> *From:* SmarterBroadband <li...@smarterbroadband.com>
>
> *Sent:* Tuesday, May 24, 2016 4:20 PM
>
> *To:* af@afmug.com
>
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> That is $12 per seat?
>
> Yes, 5 PC but I think only one login?
>
>
>
> · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user
>
>
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
> Behalf Of *Chuck McCown
> *Sent:* Tuesday, May 24, 2016 8:48 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> I looked at those.  Not thrilled.  I may just go with 365.  $12/month for
> 5 seats.  Not terrible.
>
>
>
> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>
> *Sent:* Tuesday, May 24, 2016 9:42 AM
>
> *To:* af@afmug.com
>
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
>
> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>
>
>
>
>
> Josh Luthman
> Office: 937-552-2340
> Direct: 937-552-2343
> 1100 Wayne St
> Suite 1337
> Troy, OH 45373
>
>
>
> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:
>
> We’ve an Office365 for this. Keeping Office up to
>
> date is more expensive than renting it.
>
>
>
>
>
>
>
> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
> *Gesendet:* Dienstag, 24. Mai 2016 17:30
> *An:* af@afmug.com
> *Betreff:* [AFMUG] OT MS Access alternatives
>
>
>
> I tried to open and edit an mdb file with Libre and it keeps crashing.
> Hate to go buy access.  Any alternatives that actually work?
>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Cameron Crum
Yeah...easy to do with Sql Express, but make sure you get SQL Server
Management Studio as well. Once installed, open management studio and
import your DB. Select the DB and then click the "New Query" "button" at
the top. Make sure the little pull down shows your database as the default
"master" is sometimes in there if you haven't run a query yet. Now type
your query and hit the "Execute" button.



On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

> Just want to write some custom query/reports.
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Tuesday, May 24, 2016 7:26 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> Maybe SQLServer Express? It's free. I guess it depends on what you are
> doing with database.
>
> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
> li...@smarterbroadband.com> wrote:
>
>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>
>>
>>
>> This is interesting for people who need occasional access.
>>
>>
>>
>>
>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>
>>
>>
>> *Get started with Office Online now*
>>
>> No install required. Choose your favorite app. It's free.
>>
>>
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> Does that mean concurrent logins?  That is pretty important in my
>> application.
>>
>>
>>
>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>
>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> The home version covers 5 seats and is only $99 a year…..
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>> Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 3:24 PM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> No, $12/month total for 5 seats.
>>
>> They say 5 computers.  One would hope concurrent logins.
>>
>>
>>
>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>
>> *Sent:* Tuesday, May 24, 2016 4:20 PM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> That is $12 per seat?
>>
>> Yes, 5 PC but I think only one login?
>>
>>
>>
>> ·     One license covers 5 phones, 5 tablets, & 5 PCs or Macs per
>> user
>>
>>
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>> Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 8:48 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> I looked at those.  Not thrilled.  I may just go with 365.  $12/month for
>> 5 seats.  Not terrible.
>>
>>
>>
>> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>>
>> *Sent:* Tuesday, May 24, 2016 9:42 AM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>>
>> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>>
>>
>>
>>
>>
>> Josh Luthman
>> Office: 937-552-2340
>> Direct: 937-552-2343
>> 1100 Wayne St
>> Suite 1337
>> Troy, OH 45373
>>
>>
>>
>> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net>
>> wrote:
>>
>> We’ve an Office365 for this. Keeping Office up to
>>
>> date is more expensive than renting it.
>>
>>
>>
>>
>>
>>
>>
>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
>> *Gesendet:* Dienstag, 24. Mai 2016 17:30
>> *An:* af@afmug.com
>> *Betreff:* [AFMUG] OT MS Access alternatives
>>
>>
>>
>> I tried to open and edit an mdb file with Libre and it keeps crashing.
>> Hate to go buy access.  Any alternatives that actually work?
>>
>>
>>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread That One Guy /sarcasm
Wanna have a fun day, call microsoft and ask them to explain the licensing
structure for office and windows OS, then call back in 5 minutes and ask
again. Two totally different answers. I think microsoft convoluted it to
such a degree they dont even know anymore

On Wed, May 25, 2016 at 9:33 AM, Chuck McCown <ch...@wbmfg.com> wrote:

> Just want to write some custom query/reports.
>
> *From:* Cameron Crum <cc...@wispmon.com>
> *Sent:* Tuesday, May 24, 2016 7:26 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
> Maybe SQLServer Express? It's free. I guess it depends on what you are
> doing with database.
>
> On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
> li...@smarterbroadband.com> wrote:
>
>> Home, maybe.  Looks like it.  I’m just reading the web page.
>>
>>
>>
>> This is interesting for people who need occasional access.
>>
>>
>>
>>
>> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>>
>>
>>
>> *Get started with Office Online now*
>>
>> No install required. Choose your favorite app. It's free.
>>
>>
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 3:35 PM
>>
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> Does that mean concurrent logins?  That is pretty important in my
>> application.
>>
>>
>>
>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>
>> *Sent:* Tuesday, May 24, 2016 4:31 PM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> The home version covers 5 seats and is only $99 a year…..
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>> Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 3:24 PM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> No, $12/month total for 5 seats.
>>
>> They say 5 computers.  One would hope concurrent logins.
>>
>>
>>
>> *From:* SmarterBroadband <li...@smarterbroadband.com>
>>
>> *Sent:* Tuesday, May 24, 2016 4:20 PM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> That is $12 per seat?
>>
>> Yes, 5 PC but I think only one login?
>>
>>
>>
>> · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per
>> user
>>
>>
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
>> Behalf Of *Chuck McCown
>> *Sent:* Tuesday, May 24, 2016 8:48 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>> I looked at those.  Not thrilled.  I may just go with 365.  $12/month for
>> 5 seats.  Not terrible.
>>
>>
>>
>> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>>
>> *Sent:* Tuesday, May 24, 2016 9:42 AM
>>
>> *To:* af@afmug.com
>>
>> *Subject:* Re: [AFMUG] OT MS Access alternatives
>>
>>
>>
>>
>> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>>
>>
>>
>>
>>
>> Josh Luthman
>> Office: 937-552-2340
>> Direct: 937-552-2343
>> 1100 Wayne St
>> Suite 1337
>> Troy, OH 45373
>>
>>
>>
>> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net>
>> wrote:
>>
>> We’ve an Office365 for this. Keeping Office up to
>>
>> date is more expensive than renting it.
>>
>>
>>
>>
>>
>>
>>
>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
>> *Gesendet:* Dienstag, 24. Mai 2016 17:30
>> *An:* af@afmug.com
>> *Betreff:* [AFMUG] OT MS Access alternatives
>>
>>
>>
>> I tried to open and edit an mdb file with Libre and it keeps crashing.
>> Hate to go buy access.  Any alternatives that actually work?
>>
>>
>>
>
>



-- 
If you only see yourself as part of the team but you don't see your team as
part of yourself you have already failed as part of the team.


Re: [AFMUG] OT MS Access alternatives

2016-05-25 Thread Chuck McCown
Just want to write some custom query/reports.

From: Cameron Crum 
Sent: Tuesday, May 24, 2016 7:26 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

Maybe SQLServer Express? It's free. I guess it depends on what you are doing 
with database. 

On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <li...@smarterbroadband.com> 
wrote:

  Home, maybe.  Looks like it.  I’m just reading the web page.



  This is interesting for people who need occasional access.



  
https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online



  Get started with Office Online now

  No install required. Choose your favorite app. It's free.





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:35 PM


  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives


  Does that mean concurrent logins?  That is pretty important in my 
application.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:31 PM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  The home version covers 5 seats and is only $99 a year…..



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 3:24 PM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  No, $12/month total for 5 seats.  

  They say 5 computers.  One would hope concurrent logins.  



  From: SmarterBroadband 

  Sent: Tuesday, May 24, 2016 4:20 PM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  That is $12 per seat?  

  Yes, 5 PC but I think only one login?



  · One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user





  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
  Sent: Tuesday, May 24, 2016 8:48 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] OT MS Access alternatives



  I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  



  From: Josh Luthman 

  Sent: Tuesday, May 24, 2016 9:42 AM

  To: af@afmug.com 

  Subject: Re: [AFMUG] OT MS Access alternatives



  
http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





  Josh Luthman
  Office: 937-552-2340
  Direct: 937-552-2343
  1100 Wayne St
  Suite 1337
  Troy, OH 45373



  On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

  We’ve an Office365 for this. Keeping Office up to

  date is more expensive than renting it.







  Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
  Gesendet: Dienstag, 24. Mai 2016 17:30
  An: af@afmug.com
  Betreff: [AFMUG] OT MS Access alternatives



  I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate 
to go buy access.  Any alternatives that actually work?





Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Cameron Crum
Maybe SQLServer Express? It's free. I guess it depends on what you are
doing with database.

On Tue, May 24, 2016 at 5:41 PM, SmarterBroadband <
li...@smarterbroadband.com> wrote:

> Home, maybe.  Looks like it.  I’m just reading the web page.
>
>
>
> This is interesting for people who need occasional access.
>
>
>
>
> https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online
>
>
>
> *Get started with Office Online now*
>
> No install required. Choose your favorite app. It's free.
>
>
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
> *Sent:* Tuesday, May 24, 2016 3:35 PM
>
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> Does that mean concurrent logins?  That is pretty important in my
> application.
>
>
>
> *From:* SmarterBroadband <li...@smarterbroadband.com>
>
> *Sent:* Tuesday, May 24, 2016 4:31 PM
>
> *To:* af@afmug.com
>
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> The home version covers 5 seats and is only $99 a year…..
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
> Behalf Of *Chuck McCown
> *Sent:* Tuesday, May 24, 2016 3:24 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> No, $12/month total for 5 seats.
>
> They say 5 computers.  One would hope concurrent logins.
>
>
>
> *From:* SmarterBroadband <li...@smarterbroadband.com>
>
> *Sent:* Tuesday, May 24, 2016 4:20 PM
>
> *To:* af@afmug.com
>
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> That is $12 per seat?
>
> Yes, 5 PC but I think only one login?
>
>
>
> ·         One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user
>
>
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com <af-boun...@afmug.com>] *On
> Behalf Of *Chuck McCown
> *Sent:* Tuesday, May 24, 2016 8:48 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
> I looked at those.  Not thrilled.  I may just go with 365.  $12/month for
> 5 seats.  Not terrible.
>
>
>
> *From:* Josh Luthman <j...@imaginenetworksllc.com>
>
> *Sent:* Tuesday, May 24, 2016 9:42 AM
>
> *To:* af@afmug.com
>
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
>
>
> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>
>
>
>
>
> Josh Luthman
> Office: 937-552-2340
> Direct: 937-552-2343
> 1100 Wayne St
> Suite 1337
> Troy, OH 45373
>
>
>
> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:
>
> We’ve an Office365 for this. Keeping Office up to
>
> date is more expensive than renting it.
>
>
>
>
>
>
>
> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
> *Gesendet:* Dienstag, 24. Mai 2016 17:30
> *An:* af@afmug.com
> *Betreff:* [AFMUG] OT MS Access alternatives
>
>
>
> I tried to open and edit an mdb file with Libre and it keeps crashing.
> Hate to go buy access.  Any alternatives that actually work?
>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread SmarterBroadband
Home, maybe.  Looks like it.  I’m just reading the web page.

 

This is interesting for people who need occasional access.

 

https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online

 

Get started with Office Online now

No install required. Choose your favorite app. It's free.

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:35 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

Does that mean concurrent logins?  That is pretty important in my application.  

 

From: SmarterBroadband <mailto:li...@smarterbroadband.com>  

Sent: Tuesday, May 24, 2016 4:31 PM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

The home version covers 5 seats and is only $99 a year…..

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  

 

From: SmarterBroadband <mailto:li...@smarterbroadband.com>  

Sent: Tuesday, May 24, 2016 4:20 PM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman <mailto:j...@imaginenetworksllc.com>  

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 



Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread SmarterBroadband
I think the home version covers 5 different Users.

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of SmarterBroadband
Sent: Tuesday, May 24, 2016 3:32 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

The home version covers 5 seats and is only $99 a year…..

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  

 

From: SmarterBroadband <mailto:li...@smarterbroadband.com>  

Sent: Tuesday, May 24, 2016 4:20 PM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman <mailto:j...@imaginenetworksllc.com>  

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 



Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Chuck McCown
Does that mean concurrent logins?  That is pretty important in my application.  

From: SmarterBroadband 
Sent: Tuesday, May 24, 2016 4:31 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

The home version covers 5 seats and is only $99 a year…..

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  

 

From: SmarterBroadband 

Sent: Tuesday, May 24, 2016 4:20 PM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 


Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread SmarterBroadband
The home version covers 5 seats and is only $99 a year…..

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 3:24 PM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

No, $12/month total for 5 seats.  

They say 5 computers.  One would hope concurrent logins.  

 

From: SmarterBroadband <mailto:li...@smarterbroadband.com>  

Sent: Tuesday, May 24, 2016 4:20 PM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman <mailto:j...@imaginenetworksllc.com>  

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 



Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Bill Prince
Last time I got this, it was $99 (total) for 5 seats for a year. Plus 
you could add/remove seats at will. IOW, if someone got a new laptop, 
you could remove that "seat", and add another one.



bp
<part15sbs{at}gmail{dot}com>

On 5/24/2016 3:23 PM, Chuck McCown wrote:

No, $12/month total for 5 seats.
They say 5 computers.  One would hope concurrent logins.
*From:* SmarterBroadband <mailto:li...@smarterbroadband.com>
*Sent:* Tuesday, May 24, 2016 4:20 PM
*To:* af@afmug.com <mailto:af@afmug.com>
*Subject:* Re: [AFMUG] OT MS Access alternatives

That is $12 per seat?

Yes, 5 PC but I think only one login?

·One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

*From:*Af [mailto:af-boun...@afmug.com] *On Behalf Of *Chuck McCown
*Sent:* Tuesday, May 24, 2016 8:48 AM
*To:* af@afmug.com
*Subject:* Re: [AFMUG] OT MS Access alternatives

I looked at those.  Not thrilled. I may just go with 365.  $12/month 
for 5 seats. Not terrible.


*From:*Josh Luthman <mailto:j...@imaginenetworksllc.com>

*Sent:*Tuesday, May 24, 2016 9:42 AM

*To:*af@afmug.com <mailto:af@afmug.com>

*Subject:*Re: [AFMUG] OT MS Access alternatives

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net 
<mailto:s...@genias.net>> wrote:


We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

*Von:*Af [mailto:af-boun...@afmug.com <mailto:af-boun...@afmug.com>] 
*Im Auftrag von *Chuck McCown

*Gesendet:* Dienstag, 24. Mai 2016 17:30
*An:* af@afmug.com <mailto:af@afmug.com>
*Betreff:* [AFMUG] OT MS Access alternatives

I tried to open and edit an mdb file with Libre and it keeps 
crashing.  Hate to go buy access.  Any alternatives that actually work?






Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Chuck McCown
Damn these rose colored glasses...

From: Mike Hammett 
Sent: Tuesday, May 24, 2016 4:25 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

"per user"




-
Mike Hammett
Intelligent Computing Solutions

Midwest Internet Exchange

The Brothers WISP








From: "Chuck McCown" <ch...@wbmfg.com>
To: af@afmug.com
Sent: Tuesday, May 24, 2016 5:23:57 PM
Subject: Re: [AFMUG] OT MS Access alternatives


No, $12/month total for 5 seats.  
They say 5 computers.  One would hope concurrent logins.  

From: SmarterBroadband 
Sent: Tuesday, May 24, 2016 4:20 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

That is $12 per seat?  

Yes, 5 PC but I think only one login?



· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user





From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives



I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  



From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives



http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/





Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373



On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.







Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives



I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?





Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Mike Hammett
"per user" 




- 
Mike Hammett 
Intelligent Computing Solutions 

Midwest Internet Exchange 

The Brothers WISP 




- Original Message -

From: "Chuck McCown" <ch...@wbmfg.com> 
To: af@afmug.com 
Sent: Tuesday, May 24, 2016 5:23:57 PM 
Subject: Re: [AFMUG] OT MS Access alternatives 




No, $12/month total for 5 seats. 
They say 5 computers. One would hope concurrent logins. 




From: SmarterBroadband 
Sent: Tuesday, May 24, 2016 4:20 PM 
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives 



That is $12 per seat? 
Yes, 5 PC but I think only one login? 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user 




From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown 
Sent: Tuesday, May 24, 2016 8:48 AM 
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives 




I looked at those. Not thrilled. I may just go with 365. $12/month for 5 seats. 
Not terrible. 






From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM 

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives 




http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
 








Josh Luthman 
Office: 937-552-2340 
Direct: 937-552-2343 
1100 Wayne St 
Suite 1337 
Troy, OH 45373 



On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt < s...@genias.net > wrote: 


We’ve an Office365 for this. Keeping Office up to 
date is more expensive than renting it. 






Von: Af [mailto: af-boun...@afmug.com ] Im Auftrag von Chuck McCown 
Gesendet: Dienstag, 24. Mai 2016 17:30 
An: af@afmug.com 
Betreff: [AFMUG] OT MS Access alternatives 




I tried to open and edit an mdb file with Libre and it keeps crashing. Hate to 
go buy access. Any alternatives that actually work? 




Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Chuck McCown
No, $12/month total for 5 seats.  
They say 5 computers.  One would hope concurrent logins.  

From: SmarterBroadband 
Sent: Tuesday, May 24, 2016 4:20 PM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman 

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 


Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread SmarterBroadband
That is $12 per seat?  

Yes, 5 PC but I think only one login?

 

· One license covers 5 phones, 5 tablets, & 5 PCs or Macs per user

 

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Chuck McCown
Sent: Tuesday, May 24, 2016 8:48 AM
To: af@afmug.com
Subject: Re: [AFMUG] OT MS Access alternatives

 

I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

 

From: Josh Luthman <mailto:j...@imaginenetworksllc.com>  

Sent: Tuesday, May 24, 2016 9:42 AM

To: af@afmug.com 

Subject: Re: [AFMUG] OT MS Access alternatives

 

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/

 

 

Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

 

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

We’ve an Office365 for this. Keeping Office up to

date is more expensive than renting it.

 

 

 

Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives

 

I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?

 



Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Josh Luthman
If it works and you can use it well, just do $12.  Costs more in time to
find another solution (even if it's free).  $144 a year for a program that
works is awesome.


Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

On Tue, May 24, 2016 at 11:47 AM, Chuck McCown <ch...@wbmfg.com> wrote:

> I looked at those.  Not thrilled.  I may just go with 365.  $12/month for
> 5 seats.  Not terrible.
>
> *From:* Josh Luthman <j...@imaginenetworksllc.com>
> *Sent:* Tuesday, May 24, 2016 9:42 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] OT MS Access alternatives
>
>
> http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/
>
>
> Josh Luthman
> Office: 937-552-2340
> Direct: 937-552-2343
> 1100 Wayne St
> Suite 1337
> Troy, OH 45373
>
> On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:
>
>> We’ve an Office365 for this. Keeping Office up to
>>
>> date is more expensive than renting it.
>>
>>
>>
>>
>>
>>
>>
>> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
>> *Gesendet:* Dienstag, 24. Mai 2016 17:30
>> *An:* af@afmug.com
>> *Betreff:* [AFMUG] OT MS Access alternatives
>>
>>
>>
>> I tried to open and edit an mdb file with Libre and it keeps crashing.
>> Hate to go buy access.  Any alternatives that actually work?
>>
>
>


Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Chuck McCown
I looked at those.  Not thrilled.  I may just go with 365.  $12/month for 5 
seats.  Not terrible.  

From: Josh Luthman 
Sent: Tuesday, May 24, 2016 9:42 AM
To: af@afmug.com 
Subject: Re: [AFMUG] OT MS Access alternatives

http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/



Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

  We’ve an Office365 for this. Keeping Office up to

  date is more expensive than renting it.







  Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
  Gesendet: Dienstag, 24. Mai 2016 17:30
  An: af@afmug.com
  Betreff: [AFMUG] OT MS Access alternatives



  I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate 
to go buy access.  Any alternatives that actually work?



Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Josh Luthman
http://www.isunshare.com/blog/how-to-open-and-edit-mdb-file-without-microsoft-access/


Josh Luthman
Office: 937-552-2340
Direct: 937-552-2343
1100 Wayne St
Suite 1337
Troy, OH 45373

On Tue, May 24, 2016 at 11:39 AM, Stefan Englhardt <s...@genias.net> wrote:

> We’ve an Office365 for this. Keeping Office up to
>
> date is more expensive than renting it.
>
>
>
>
>
>
>
> *Von:* Af [mailto:af-boun...@afmug.com] *Im Auftrag von *Chuck McCown
> *Gesendet:* Dienstag, 24. Mai 2016 17:30
> *An:* af@afmug.com
> *Betreff:* [AFMUG] OT MS Access alternatives
>
>
>
> I tried to open and edit an mdb file with Libre and it keeps crashing.
> Hate to go buy access.  Any alternatives that actually work?
>


Re: [AFMUG] OT MS Access alternatives

2016-05-24 Thread Stefan Englhardt
We've an Office365 for this. Keeping Office up to

date is more expensive than renting it.







Von: Af [mailto:af-boun...@afmug.com] Im Auftrag von Chuck McCown
Gesendet: Dienstag, 24. Mai 2016 17:30
An: af@afmug.com
Betreff: [AFMUG] OT MS Access alternatives



I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?





[AFMUG] OT MS Access alternatives

2016-05-24 Thread Chuck McCown
I tried to open and edit an mdb file with Libre and it keeps crashing.  Hate to 
go buy access.  Any alternatives that actually work?