[AccessD] Dropbox/MS Access problem.

jack drawbridge jackandpat.d at gmail.com
Thu May 30 09:27:45 CDT 2013


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
>


More information about the AccessD mailing list