Setting Database Propertys

[Bakr Z via AccessMonster.com]

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...

 

[TC]

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

 

[Bakr Z via AccessMonster.com]

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
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

 

[TC]

What is the message exactly?

TC

 

[Bakr Z via AccessMonster.com]

the message when I click database properties from file menu, is:
"Microsoft Access is unable to load the Database Properties"

 

[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

 

[Bakr Z via AccessMonster.com]

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

 

[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...le-to-load-the-database-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