Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Trouble with split database

I am running Access 2013.  I just split a database but when I try to open the back-end file I get a seci=urity warning and then Access opens but not the file I'm trying to open.

What am I doing wrong?

Here is the message I'm getting...

User generated image
Avatar of Nick67
Nick67
Flag of Canada image

when I try to open the back-end file I get a security warning and then Access opens but not the file I'm trying to open.


The backend will have no forms, reports, macros or queries in it.
Only tables.
Does the wrong file open, or you were expecting other things to be in the backend?
Your warning is a Trust Center warning.
If you have been trusting individual files, then the backend is a new file and not already trusted--you just created it
The front-end will now have linked tables instead of the original local tables, and all the other objects in it. Have you opened the frontend?  Does it work as expected?
Avatar of SteveL13

ASKER

The front end opens just fine and of course I can see the linked tables.  But if I wanted to make a change to a table or add a field I wouldn't be able to do so because I can't open the BE file.
And here's something strange.  I just copied the file to a computer running Access 2010, split the file, and I am able to open the BE file just fine on that computer.

?????????????????????
Trust Center settings.
Indubitably.
Check them on both and compare.
99 for 100 the problem machine is set to disallow, rather than prompt, for any file without a digital signature
Ok.  But how do I get to the trust center settings in the BE file if I can't open it?
SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is there a chance that I can't add the desktop as a trusted location?  I did the steps you list above and still can't open the backend file.
I wouldn't add the desktop as a trusted location but if you can navigate to it in the trusted locations dialog, you can set it as trusted.  Just keep in mind that each user has a different name for his desktop folder.

Since the desktop is really a phony folder to make Windows more Mac-like, behind the scenes it has a weird name.  I'm still finding bugs in various Office programs that pre-date the change from the 8.3 file naming convention and don't accept "new" name formats.   Make the folder on the C:\ drive and don't use the desktop.  Drag the folder to the desktop if you want a shortcut.