Old to new

[cmccarter]

I presently have a db that is used to manage an event run by a local garden club It manages attendees, seminars to be attended and several other items, only once a year . It was created using MS access 2007, I did not create it, it was built by a person I do not remember. the DB contains both a Frontend and a backend and still works great but I am worried that at sometime this will need to be passed on to someone else so here are my questions.



its is an accdb format with both a FE and BE. this was done so the created could correct any issues I had and not screw up the data.

1. is it possible to convert the db from 2007 to 2019 for starters or would that entail a lot of work?
2. once I get it converted i would like to create a standalone program so that the next user will not need to buy access 2019 but instead just be able to run the program and create new data for next year. All the old data is erased each year and restarted for the next event.

the man that created the present system used a lot of (code) that i have no idea how it would translate. Probably vba that is way over my measely capabilities.

hoping someone can help here. my wife just cannot keep doing this forever.

[June7]

There should not be any conversion necessary. 2019 should have no problem opening accdb created with earlier version. If there are no edits that incorporate later version features, should continue to be able to open in 2007/2010/2013/2016.

[pbaldy]

To your second question, you can't create a standalone version; Access is always required. There is a free runtime version available from Microsoft. The user won't be able to make design changes.

[cmccarter]

tnx for the info. we are perfectly happy with the design and the stuff used to create the db. the only thing that changes year to year is the actual data. BTW the person that created the Db was named David Grimes.
so if I install access 2019 on my pc then open the backend file everything should be hunky-dory? No idea what was uses to create the entry tables, reports and forms (look to be some type basci guessing VBA. SInce I have access to 2019 I may give it a try.

[June7]

If frontend is not an Access file, then you would probably not even need Access installed at all, unless you wanted to modify backend structure.

So, what is file extension of frontend?

[cmccarter]

both the FE and BE are both .accdb files

[June7]

Then you need Access installed to modify design of either file.