is it a .bak file or just and mdf? On Wed, May 25, 2016 at 12:12 PM, Chuck McCown <[email protected]> wrote:
> I think I would probably have to set up a new database and import the > backup into it. > > *From:* Cameron Crum <[email protected]> > *Sent:* Wednesday, May 25, 2016 11:04 AM > *To:* [email protected] > *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 <[email protected]> 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 <[email protected]> >> *Sent:* Wednesday, May 25, 2016 10:52 AM >> *To:* [email protected] >> *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 <[email protected]> wrote: >> >>> Not seeing the import option... >>> >>> *From:* Cameron Crum <[email protected]> >>> *Sent:* Wednesday, May 25, 2016 8:45 AM >>> *To:* [email protected] >>> *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 <[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? >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
