Oops! Yes, Access 2010.

I have maintained my nonprofit’s membership database (in Access) for many years, and have also published its newsletter (with Publisher). I’m turning both jobs over to somebody else who has far fewer computer skills than I do. I think he’d be scared to death of LibreOffice. (So am I, BTW) .

Does it have an equivalent to Publisher? (I have a bunch of custom templates.)

Can it work on a Mac? (The new guy has one, and will have to buy a PC to use Microsoft 365 Access and Publisher. The money is no big deal.)

Adding to the above from this morning…

My Access application uses quite a lot of VBA, put in there by its creator. How does LO do with VBA? (You are tempting me here… )

Thanks! I lack current Access and VBA skills, but I can figure out most of the little things I need.

I want to turn my mailing list over to a new person, but due to its size and complexity, I’d rather not have him limited to Excel. The current Access database has some forms that make it easy to see everyone’s detailed record on one screen, to search for records, to change and update records, etc. (See attachment)

When it’s time to use the list for a mailing or something similar. with a few clicks an existing query can export the necessary items to Excel.

We are a nonprofit Navy reunion group from a ship that was in commission from WWII to 1970. Our youngest members are in their early 70s. I expect the group to last 5 more years or so. We would do quite a bit to find somebody to give us occasional help with Access.

Everyone on the list is guilty. Anyway, it’s just a screen shot.

Right now, what I need is to upgrade to Microsoft 365 without clobbering my Access 2010 installation.  I don’t really have a second computer to try that on, but I suppose I could free one up from my wife, if needed. (Right now I also need to go to bed.)

I tried to make a subset database, with no success. The back end database has several tables, all related to one another. When  I delete lots of records from the main table, the back end database doesn’t change size.

Balancing security with the need to get some help, security takes a back seat. I could upload everything to a secret place, or I could send you a Thumb drive with both databases, or ???.

Another thought… over half of my records are of dead people, or of people we haven’t found. Maybe I could temporarily mark everybody as dead. You could tweak the front end, using the dead people’s back end. When the tweaking is finished, I could open the original back end with it.

BTW, Retired Geek is a friend of mine from the past. How do I send him a private message? It isn’t obvious to me.

Got it! Silly me!

I found him. Thanks!

PaulT: That’s something to think about. I will keep it on hand for the future.

access-mdb: I DO have the compact and repair database, and have used it in the distant past. I’ll give it a try later today.

@access-mdb:  I have minimized the sizes of both the front end and back end databases, thanks to Compact and Repair Database!

Both of them are still slightly larger than the 2 MB upload limit here, and I don’t know how to shrink them further. I can upload them to my website, where you can download them at your convenience. I’ve got some changes in mind that I’m pretty sure will be easy to make for somebody more knowledgeable than me. That would be a giant step forward for me!

I can give you private access to the files on my OneDrive, if I can remember how to do it. I’ll figure it out in the morning.

I think the changes are pretty simple. Mostly deleting fields from forms, some of them based on tables that can also be deleted. I just don’t remember how to do it. Basically I don’t know how to delete something without messing other things up. The more I look at it, the less threatening and mysterious it looks.