We recently upgraded to Windows 10 & Office 365. i have an old access database created, I think, in 2013 which now will not open. Is there any way to open this with all of the links & relationships intact in Access for Office 365?
We recently upgraded to Windows 10 & Office 365. i have an old access database created, I think, in 2013 which now will not open. Is there any way to open this with all of the links & relationships intact in Access for Office 365?
all old versions of a db should open in New versions of Access.
try starting Access, then open the db while holding the shift key? does this do anything?
Do you get a message that the database was created in an earlier version of Access?
If not, it may be a references issue
Another possible issue could be if you have also changed from 32-bit to 64-bit Access
isladogs, I do get the earlier version message. I am using 64 bit but it worked OK in 64bit Win7.
what is the file type for your old db?
.mdb or .mde?
or perhaps .accdb or .accde?
And Isladogs is referring to the access version 64bit or 32bit, not the windows version
it will be there somewhere - I use 2010 so it has probably moved. On the file tab - do you have an account option? if so go to that and then you might need to click an 'about' option
see this link https://support.office.com/en-gb/art...9-e334518b8b19
As its 32-bit that's one less thing to worry about.
When you open the database, do you see a yellow security 'bar' with an Enable Content button? If so, click it.
Then go to File...Options...Trust Center and check the various settings e.g. Macro settings
Next click Database Tools...Visual Basic in the ribbon to open the Visual Basic Editor (VBE)
In the VBE, go to Tools...References and check if any references are marked MISSING.
If so, you will need to browse and locate the missing references.
Let us know what you find out.
mdb's ran from the original access v1 back in 1992 until 2003. All earlier mdb's could be opened by all later versions of access until access 2013 at which point access versions prior to and include access 2000 could no longer be opened.
In your original post you said the database was created in 2013 - but the default then was .accdb. You could still create a .mdb but that would be unusual. Without knowing the exact message you are getting - perhaps you can provide it - I suspect that your .mdb was created in access 2000 or earlier. If that is the case, the only option is to get an earlier version of access - say 2007 or 2010 to open the file and upgrade to a later version.
What goes against this theory is that you say you recently upgraded to Office 365 with the implication you were using access 2013 - and if it was working under that, then it is not possible you would have a pre access 2000 mdb.
So there is something wrong with the picture or it is incomplete. Can you double check the info you have provided and also whether or not you are using workgroups for data security - it creates a .mdw file which is associated with the database.
I can't open the database at all, I just get the 'earlier version' message.As its 32-bit that's one less thing to worry about.
When you open the database, do you see a yellow security 'bar' with an Enable Content button? If so, click it.
Then go to File...Options...Trust Center and check the various settings e.g. Macro settings
Next click Database Tools...Visual Basic in the ribbon to open the Visual Basic Editor (VBE)
In the VBE, go to Tools...References and check if any references are marked MISSING.
If so, you will need to browse and locate the missing references.
Let us know what you find out.