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