General :: Pinned Database Won't Open - Unknown Publisher
Jun 16, 2015
I work in three different databases, but for one of them (the main company db), if I right clicked the pinned Access program on the taskbar and click the pinned database, it does nothing if someone else has the file open already. If the file isn't open, it'll pop up with an "Unknown publisher" warning (new, never happened before this), but it'll open the file. If someone has the database open, it doesn't flicker or even try, it just does nothing.
I am able to open Access and click on the database in the "Recent files" and have it open that way. I don't know what to troubleshoot, its like it's not seeing the file, but I can go to the properties on the pinned db and it shows the correct file location. I'm the only one having this issue, the other users here can right click the pinned program and open the file like normal.
I've rebooted my computer; unpinned and removed from list; compacted and repaired; nothing is making a difference.
View Replies
ADVERTISEMENT
Sep 14, 2005
Hi all,
Our company is currently rolling out an SP2 update to all of our PC's and this problem has reared its head on all of the updated PC's so far.
Basically when someone opens a database from a shared drive, they get an error stating that the file was made by an unknown publisher (seems to be a security warning), they click ok and then can open the file fine.
However, once someone is in the database, if anyone else tries to open it on an SP2 machine, nothing happens, the double click the file and it refuses to open. If they open Access, then click file>open and navigate to the file, they can open it. They just can't double click the file.
People using the SP1 machines can open the database with no problems whether someone is already in the file or not.
I'm guessing this is something to dow tih the SP2 security measures.
To try to sort it out, I made myself a self signed digital ceritificate and signed my macros, thinking that once the macros were signed, it would then realise who had published the file.
The only thing this does is brings up a second notice (after the initial publisher message) which gives you the option to trust content from my signature. Once this has been done once, there's no need to keep trusting it but the publisher message still comes up.
I went into the database properties and under the custom tab changed the "publisher" value to my name "Rob Jones". This still didn't work and when the database is opened it still says it's an unknown publisher.
Does anyone know how to either turn off this check or publish a database?? I've tried google / MS but can't find anything on the subject.
Cheers,
Rob.
View 7 Replies
View Related
Jul 16, 2014
The code below allows me to open a publisher document that is already merged to the current record. What I need is to allow the user to open the document according to the group they are reviewing. How to accomplish this?
For example:
IF Group = A1 OR B1 THEN OPEN AB_1.pub
IF Group = A2 OR B2 THEN OPEN AB_2.pub
IF Group = A3 OR B3 THEN OPEN AB_3.pub
Dim pubApp As Publisher.Application
Dim pubDoc As Publisher.Document
Set pubApp = New Publisher.Application
Set pubDoc = pubApp.Documents.Add.Application.Open("c:Publishe rAB_1.pub)
pubDoc.ActiveWindow.Visible = True
View 3 Replies
View Related
Feb 22, 2013
I am running windows 7 and access 2007 same with pub When I do a mail-merge from pub I can see some Queries but not all. and thoughts?
View 1 Replies
View Related
Jun 28, 2012
I've been working on a database for the past month and all of a sudden I'm getting an error "the microsoft jet database engine could not find the object 'database'" and when I click ok nothing is showing (i.e. no project window or anything). I normally do backups on something this large but for some reason I didn't on this one. The size of the file is still large but doesn't look like anything is in it.I've tried opening a new one and link and import everything but I get the same error.
View 4 Replies
View Related
Oct 20, 2012
I'm having problems with my database. It was on a USB memory stick and suddenly I got a message to format the entire USB memory. I managed to retrieve the files on the USB and loaded them onto anothe USB, but when I tried to open the database I got the message:
"Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt."
However, when I tried it on another computer I managed to open the database but when I was closing it I got the same message again. The database is working OK, but how do I get rid of the message?
View 2 Replies
View Related
Mar 10, 2014
I am probably staring right at it - but where is the option to set Access 2010 so that it automatically opens a specified database on startup?
View 1 Replies
View Related
Jun 9, 2015
Cannot Open Database". It may not be a database that your application recognizes, or the file may be corrupt. I have a colleague that is using Microsoft Access to import objects from SQL server but he's getting the above error. I've checked the login my colleagues uses and it has all the right permissions ect but I cannot seem to figure out why this error is still happening. Is it something to do with the SQL server or Microsoft Access?
View 1 Replies
View Related
Sep 17, 2013
I am trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it stop. I tried a .bat file to open it as well and im still getting the same thing. If I just click on the database and open it manually it runs just fine.
View 3 Replies
View Related
Sep 20, 2013
I have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks.
View 2 Replies
View Related
Jan 18, 2015
I want edit my Access Database on my Android phone, is there any good App recommend ?
View 2 Replies
View Related
Dec 11, 2012
i want to ask is there any way to open another access database using when click button at form.. for example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb. can these possible for me to do it..?
View 3 Replies
View Related
Jan 20, 2015
I have a 2003 .mdb file and the associated Workgroup Information File which normally resides on a network in a folder V:V-Base-DatabaseDATA. I have the Workgroup Information File.
The database is unsupported and we need to migrate the data to a new web based database.
When I try to open the database with the shift key down I get the following message :
You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.
What is the best way to access the data and do I need to do this on the server instead of a local drive off site?
View 1 Replies
View Related
Jan 9, 2014
All of the sudden I get an error message when I try to open my database from a file rather than through Access. If I open Access first and open the file that way, there is no problem but if I click on it from Windows Explorer, I get the error.
See picture.
View 7 Replies
View Related
Mar 22, 2013
I have MS access database. The database is password encrypted. I do not own this database but it is critical for me to see the contens of this database. I do not want to edit the contents.
View 9 Replies
View Related
Aug 17, 2014
I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies
View Related
Oct 22, 2012
I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.
View 1 Replies
View Related
Sep 28, 2012
I linked table rawdata from a database called competitor from a ODBC Database. I run a query with to make a table with a criteria where it retrieves roughly 10 columns with 719,000 rows. And it gives me this error.
(Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.
I asked the creator of the database and they said the database grows automatically and it was created with the same Access version as i am using to run the query.
Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.
View 4 Replies
View Related
Jul 2, 2013
I am currently using Access 2010, and have successfully split a database, using the Access wizard.However, whenever a second or third user opens the database - with their front-end database file - they encounter the following message;The Microsoft Access Database engine cannot open or write to the file ". It is already opened exclusively by another user, or you need permission to view and write its data.
I have researched the internet and see that it has something to do with network permissions. I have worked with my IT department and this appears to be resolved!
Is there a setting I need to check in the front-end and/or back-end copies of the databases?Why is there no file name in the error message?
View 6 Replies
View Related
Jun 29, 2015
I have a database that has a main form, and from that main form there are buttons that open their respected forms. I am curious as to how I control the size of all of my forms. They are all pop-ups at the moment. It all works fine on my monitor, but when opened on a smaller monitor it is too big and I can't even see the bottom of the screen. The main form is set to open automatically after the user logs into the database and it opens to fit the screen. also, all of my forms are modals.
View 4 Replies
View Related
Jan 3, 2008
Is there any way to get rid of this message?
I am running an Access 2003 mde file across an intranet and want to remove this error so the users do not have to contend with it.
The users are going to gain access to the file via link on the "home" page.
I know this is an issue with IE but I only have limited authority so any "backdoor" way of getting rid of this would be greatly appriciated.
Thanks
tgi171:confused:
View 1 Replies
View Related
Jan 29, 2006
Hi,
I've got some id card templates in publisher than i want to merge in access.
i can merge the text details into access but i dont know how to link the photos. should i store the file path of the image in the database or should i embed the file.
would this work with publisher or do i need to use some code?
any help on this would be appriciated as i have no experience with pictures in access.
Thanks
View 1 Replies
View Related
Jan 17, 2007
In an access table I have hyperlinks to various documents mainly word docs. I have recently added a Publisher doc and when I H/L to it it will open the application but not the doco.
Obviously Publisher behaves differently than Word in this regard.
I do need the link to open the doc. Is there a way around this please?
Thanks
Peter
View 3 Replies
View Related
Apr 4, 2005
I have a list of publishers for software titles in a table.
1=Adobe
2=Macromedia
and so on and so forth.
I have a form that pulls the publisher name and displays it, and it used to display correctly with the NAME but now all of a sudden it's displaying the publisher number "1" instead of "Adobe"
what's going on?
View 1 Replies
View Related
Jun 25, 2014
I'm currently using the following to edit a publisher document using access VBA.
Code:
For Each pubShape In pubDoc.Pages(1).Shapes
If pubShape.HasTextFrame Then
If pubShape.Name = "Text Box 440" Then pubShape.TextFrame.TextRange.Text = Item1
If pubShape.Name = "Text Box 441" Then pubShape.TextFrame.TextRange.Text = Item2
If pubShape.Name = "Text Box 442" Then pubShape.TextFrame.TextRange.Text = Item3
If pubShape.Name = "Text Box 443" Then pubShape.TextFrame.TextRange.Text = Item4
If pubShape.Name = "Text Box 444" Then pubShape.TextFrame.TextRange.Text = Item5
If pubShape.Name = "Text Box 445" Then pubShape.TextFrame.TextRange.Text = Item6
If pubShape.Name = "Text Box 446" Then pubShape.TextFrame.TextRange.Text = Item7
If pubShape.Name = "Text Box 447" Then pubShape.TextFrame.TextRange.Text = Item8
End If
Next
Obviously there are a lot of shapes/boxes etc in the document and this code is very inefficient and takes a few moments to complete. Is there a way to directly reference a text box and change its value. For word I have been using bookmarks but this doesn't seem to work with publisher.
I'm looking for something like pubshape.Value("text Box 440") = Item1 but cannot find the correct syntax.
View 2 Replies
View Related
Oct 22, 2011
In 2007 how do you add a site or publisher to your trusted list.
View 1 Replies
View Related
