Access Database - .accdb and .mdb Mixed

[Lou Sander]

I have an Access 2010 database with about 3,000 records, which I want to switch over to Microsoft 365. I know nothing about Microsoft 365, but I'm willing to learn.



I know very little about Access, since the whole thing was set up 15 years ago by a now-departed database genius. I AM able to do changes, additions and deletions to records, to use existing queries, etc. Everything works fine as is.

My database is organized as a main database with a separate back end datafile. All the data is in the latter.

In preparing for the switch to 365, I made a troubling discovery. Although everything seems to work fine, and has for many years, my main database is in.accdb format, while the back end data file is in the older .mdb format.

I have no idea what this means for the switch to Microsoft 365.

Who can help this very confused old-timer?

[ranman256]

it should be backwards compatable and read old formats.

[Micron]

365 is really all about being an annual subscription. You can have for example, version 2016 with 365 or a stand alone purchase. 2016 will open an mdb no problem, and IIRC it won't prompt you to alter it. For your own peace of mind, you could save a back end (be) copy for insurance (which you should be doing on a regular basis anyway) and convert your production version to accdb. Unless you require some special feature that applies only to your be file, I doubt you'd have any issue just leaving it as is.

BTW, M$ seems to have altered their stance on 64 bit vs 32 bit and now seem to default to 64. Unless you need some very specialized data types, I'd go with 32 bit Office. I'd check that out for you situation. Here's one point of view
https://www.devhut.net/2017/04/13/ac...compatibility/

[Lou Sander]

Thanks! I'm starting to feel more comfortable with this.

[ranman256]

360 is legal ransomware.