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?
