 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2005Setting Database Propertys
Hi to all, I am facing a problem that when everyone try to access my database via a hyperlink, it shows a publisher not defined and will not open!!! when I open the database directly and go to database properties under File menu, it shows a message "MS Access is unable to load database properties". My Question: How to set the property of the databas? Should I have to write a script for that? I've read that I have to user CreateProperty function... How it can be used? Warm Regards... If your PC's macro security is set to High, that might explain why they can not open your database. Set it to Medium or Low, and try again. But understand, this exposes your PC to a greater risk of VBA virus attacks. If it /was/ the macro security setting, and your database is /not secured/, you could set the macro security back to High, then use the "AutomationSecurity" property to suppress the warnings. Google this group for posts from me (TC) containing that word. I doubt that this is anything to do with the database properties in the normal sense of that word. HTH, TC I've tried that but it didn't work... >If your PC's macro security is set to High, that might explain why they >can not open your database. Set it to Medium or Low, and try again. But [quoted text clipped - 11 lines] >HTH, >TC What is the message exactly? TC the message when I click database properties from file menu, is: "Microsoft Access is unable to load the Database Properties" >What is the message exactly? > >TC I don't mean that one. You told me that one before. I meant the one that occurs when the user clicks a hyperlink to open your database. TC when the user clicks the hyperlink will happen the follow: 1- Message appears that says: Open - Save - Cancel When I click open it show after that a message: 2- (unkown publisher message) Run - Don't Run If I click run nothing happens, but if you go to task manager you'll find a MCACESS.EXE process is running !!! But other mdb files when you you click database properties it will open it and shows company-other-comments information, and also it will open from a hyperlilnk!!! This what I've tested personlly!!! Sorry for bothering, it seems a little bit confusing, bus this what XP brought to us!!! LOL >I don't mean that one. You told me that one before. I meant the one >that occurs when the user clicks a hyperlink to open your database. > >TC Ok, so maybe the "can't run database" problem, and the "can't load properties" problems, are related somehow. Initially, I assumed that they weren't. Here are two ideas you could try. (1) The "can't load properties" message might be due to using Access 2002 to alter the db properties in an Access 2000 format db. Here's some information from Dirk Goldgar MVP: http://www.access-database-help.com/top/ng/group~5/~50580~__Unable-to-load-the-d atabase-properties/index.aspx Perhaps you could recreate the properties with Access 2000 & then try again? - To delete an existing property: dbengine(0)(0).properties.delete "PropNameHere" - To create a new property: see F1 Help for the CreateProperty method. (2) You can disable the hyperlink warning with the instructions given here: http://support.microsoft.com/default.aspx?id=829072 Perhaps disabling the warning would then allow your file to run. Personally, I'm not sure which of those two things, I would try first. Maybe (1), because (1) will only affect one file - your database. (2) will presumeably affect every other database & document that you can click a hyperlink from. HTH, TC |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.