Help migrating from MS Access

Discuss the database features

Help migrating from MS Access

Postby mattjackson » Tue Dec 04, 2018 3:04 pm

I've been trying to migrate a database from Access (a .mdb file) to Base. I followed the process of connecting to an existing database, choosing Access, and it worked fine - I have a new .odb file where I can view the database. I created a form similar to the one I had in Access and that worked fine too.

Thinking I was done, I cleaned up the old Access files I had been using (I have got them backed up). The next time I went to open the .odb file, it wouldn't work and showed me the error message saying the connection to the data source couldn't be established, and I realised it was still trying to access my original .mdb file. I (obviously mistakenly) thought that the process had imported all the data into Base, but clearly that's not the case.

Can this be done? i.e. can I import the original data so that the .odb file no longer requires a connection to the original .mdb file?
OpenOffice 4.1.6 on MacOS Mojave
mattjackson
 
Posts: 1
Joined: Tue Dec 04, 2018 2:58 pm

Re: Help migrating from MS Access

Postby John_Ha » Tue Dec 04, 2018 4:45 pm

Welcome to the forum

Search the forum with access to find plenty of posts about Access.
LO 6.3.5.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7612
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest