[AccessD] Dropbox/MS Access problem.

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