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 <[email protected]> wrote: > Just want to write some custom query/reports. > > *From:* Cameron Crum <[email protected]> > *Sent:* Tuesday, May 24, 2016 7:26 PM > *To:* [email protected] > *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 < > [email protected]> 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:[email protected]] *On Behalf Of *Chuck McCown >> *Sent:* Tuesday, May 24, 2016 3:35 PM >> >> *To:* [email protected] >> *Subject:* Re: [AFMUG] OT MS Access alternatives >> >> >> >> Does that mean concurrent logins? That is pretty important in my >> application. >> >> >> >> *From:* SmarterBroadband <[email protected]> >> >> *Sent:* Tuesday, May 24, 2016 4:31 PM >> >> *To:* [email protected] >> >> *Subject:* Re: [AFMUG] OT MS Access alternatives >> >> >> >> The home version covers 5 seats and is only $99 a year….. >> >> >> >> *From:* Af [mailto:[email protected] <[email protected]>] *On >> Behalf Of *Chuck McCown >> *Sent:* Tuesday, May 24, 2016 3:24 PM >> *To:* [email protected] >> *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 <[email protected]> >> >> *Sent:* Tuesday, May 24, 2016 4:20 PM >> >> *To:* [email protected] >> >> *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:[email protected] <[email protected]>] *On >> Behalf Of *Chuck McCown >> *Sent:* Tuesday, May 24, 2016 8:48 AM >> *To:* [email protected] >> *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 <[email protected]> >> >> *Sent:* Tuesday, May 24, 2016 9:42 AM >> >> *To:* [email protected] >> >> *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 <[email protected]> >> wrote: >> >> We’ve an Office365 for this. Keeping Office up to >> >> date is more expensive than renting it. >> >> >> >> >> >> >> >> *Von:* Af [mailto:[email protected]] *Im Auftrag von *Chuck McCown >> *Gesendet:* Dienstag, 24. Mai 2016 17:30 >> *An:* [email protected] >> *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? >> >> >> > >
