jack drawbridge
jackandpat.d at gmail.com
Thu May 30 10:13:41 CDT 2013
I should clarify this *I didn't do anything proactively to do this ( as far as I know or can recall ) *But at the time the 2010 UI was all new and confusing to me; still somewhat confusing but I don't do any real development . * *jack* * On Thu, May 30, 2013 at 11:08 AM, jack drawbridge <jackandpat.d at gmail.com>wrote: > Charlotte, > Yes, that one is for a new blank database-- default format for blank > database. But I was opening mdb and it was being saved as accdb. I did > not know if I had set up some flag to do so; I didn't do anything > proactively to do this and this is not the expected default behavior. I > can see mdb --> accdb if you open an mdb and specifically ask for it to be > converted/saved as accdb. > > jack > > > On Thu, May 30, 2013 at 10:55 AM, Charlotte Foust < > charlotte.foust at gmail.com> wrote: > >> It's in Access Options under the General tab under creating databases. >> >> Charlotte >> >> On Thu, May 30, 2013 at 7:27 AM, jack drawbridge <jackandpat.d at gmail.com >> >wrote: >> >> > I don't recall specifically at the moment. I was having issues with new >> UI >> > with 2010, and was happy and used to 2003. Each time I tried something, >> if >> > i went to the other versio, Access was reloading the software, and I was >> > getting frustrated -- have to wait seems 3-5 minutes to start the >> program >> > each time. Whatever, I was doing, I was getting accdb files. >> > When I look at the options now, I see it says format for blank database >> on >> > the Options. So I'm not sure what I did. I don't open 2003 anymore so >> maybe >> > I have corrected my own manual processes/procedures unknowingly. >> > >> > Sorry for being so vague, but my initial response was really trying to >> say >> > -- perhaps you have some flag set to convert to accdb (that's what I >> > thought my issue was). But doesn't appear to be any such flag. >> > >> > jack >> > >> > >> > On Thu, May 30, 2013 at 1:46 AM, William Benson (VBACreations.Com) < >> > vbacreations at gmail.com> wrote: >> > >> > > Jack, where is toggle you mention? I cannot find any setting other >> than >> > the >> > > one which controls new database formats. Beyond that, only the Save As >> > > command controls conversion format, as mentioned in this article. >> > > http://goo.gl/VJ63D >> > > >> > > Convert an Access 2000 or Access 2002 - 2003 database to the .accdb >> > format >> > > To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the >> > > .accdb file format, you must first open the database by using Access >> 2007 >> > > or >> > > Access 2010, and then save it in the .accdb file format. >> > > 1.On the File tab, click Open. >> > > 2.In the Open dialog box, select and open the Access 2000 or Access >> 2002 >> > - >> > > 2003 database (.mdb) that you want to convert. >> > > Note If the Database Enhancement dialog box appears, the database >> is >> > > using a file format that is earlier than Access 2000. To continue, see >> > the >> > > section Convert an Access 97 database to the .accdb format. >> > > 3.On the File tab, click Save & Publish, and then, under Database File >> > > Types >> > > click Access Database (*.accdb). >> > > 4.Click Save As. >> > > If any database objects are open when you click Save As, Access >> prompts >> > you >> > > to close them prior to creating the copy. Click Yes to make Access >> close >> > > the >> > > objects, or click No to cancel the entire process. If needed, Access >> will >> > > also prompt you to save any changes. >> > > 5.In the Save As dialog box, type a file name in the File name box, >> and >> > > then >> > > click Save. >> > > Access creates the copy of the database, and then opens the copy. >> Access >> > > automatically closes the original database. >> > > >> > > From: William Benson [mailto:vbacreations at gmail.com] >> > > Sent: Thursday, May 30, 2013 1:19 AM >> > > To: Access Developers discussion and problem solving >> > > Subject: Re: [AccessD] Dropbox/MS Access problem. >> > > >> > > If you open an mdb and work on it in access 2007/2010 appli cation, it >> > > should leave it as an mdb unless you convert it. The setting you >> > mentioned >> > > is supposed to deal with new databases, not magically convert and >> upgrade >> > > existing databases. That wouls create chaos in multiuser environments. >> > > That just seems wrong. It has to be how it is being published, not >> just >> > > worked in... ??? >> > > On May 28, 2013 7:52 AM, "jack drawbridge" <jackandpat.d at gmail.com> >> > wrote: >> > > Doug, >> > > >> > > Do you happen to have the "save files as accdb" turned on? I just >> loaded >> > > Acc2010 recently and each file I looked at got saved with accdb. I >> then >> > set >> > > the "save files as 2003 or similar and I then had mdb files. >> > > I'm wondering if your default/current setting is 2007/2010, then you >> > might >> > > get accdb automatically. ie nothing to do with dropbox??? >> > > jack >> > > >> > > On Mon, May 27, 2013 at 3:11 PM, Doug Steele <dbdoug at gmail.com> >> wrote: >> > > >> > > > I got a baffled call from a client this morning, wanting to know >> why I >> > > had >> > > > changed their back end from an .mdb file to an .accdb file. >> > > > >> > > > I said I had downloaded the accdb file from their Dropbox account to >> > work >> > > > on it. The client said they didn't have an accdb file on Dropbox. >> > > > >> > > > Assuming that I had had (yet another) senior moment, I logged in and >> > sure >> > > > enough, the copy of the back end was definitely an mdb. >> > > > >> > > > Then, before my very eyes, as soon as I clicked on the mdb file to >> > > download >> > > > it, Dropbox changed the extension to 'accdb' on my computer (which >> only >> > > has >> > > > Office 2010 installed). Arghhh! >> > > > >> > > > I checked, and Dropbox doesn't do any conversion - it's just an mdb >> > with >> > > > the wrong extension. So be warned! >> > > > >> > > > Doug >> > > > -- >> > > > AccessD mailing list >> > > > AccessD at databaseadvisors.com >> > > > http://databaseadvisors.com/mailman/listinfo/accessd >> > > > Website: http://www.databaseadvisors.com >> > > > >> > > -- >> > > AccessD mailing list >> > > AccessD at databaseadvisors.com >> > > http://databaseadvisors.com/mailman/listinfo/accessd >> > > Website: http://www.databaseadvisors.com >> > > -- >> > > AccessD mailing list >> > > AccessD at databaseadvisors.com >> > > http://databaseadvisors.com/mailman/listinfo/accessd >> > > Website: http://www.databaseadvisors.com >> > > >> > -- >> > AccessD mailing list >> > AccessD at databaseadvisors.com >> > http://databaseadvisors.com/mailman/listinfo/accessd >> > Website: http://www.databaseadvisors.com >> > >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > >