[AccessD] Dropbox/MS Access problem.

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


More information about the AccessD mailing list