HOW TO: Change MS Access database ownership in code?

[AvatarZA]

I am looking for some code to change the ownership of an Access database, could someone please help me.

Thanks in advance
Regard
Av

 

[Dimandja]

The Owner of a MS Access database cannot be changed.

However you can create a new (blank) database and import all objects from the old database. You own the new database. Of course, you'll need the new owner to create this new database, because the creator is automatically the owner (for life).

 

[chrissie1]

And what happens if the owner dies??

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

And what happens if the owner dies??

Then all of the senior Access developers go into a closed door meeting a vote on a new owner. It's kinda like picking a pope, but with out the smoke.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[chrissie1]

or they burn the dead owner and wait for the white smoke

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[Dimandja]

>...or they burn the dead owner and wait for the white smoke

Not to be confused with the false white smoke that MS Access is known to emit sporadically, on a whim, out of nowhere.

 

[ThatRickGuy]

It's like my Dad used to always say...

Son, never trust a database that has a 'repair' option in the menu

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[AvatarZA]

Thanks guys.