Re: VBA Script to Read WMP 11 Database



On Thu, 5 Apr 2007 06:36:02 -0700, Lou G
<LouG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

A couple of years ago, I wrote a custom Access VBA script to keep track of my
Media Player 10 music files. Now that I've ?upgraded? to Media Player 11, my
script doesn't run. Instead, it just produces "-2147467259 automation
error" at the line:

Set objplayer = CreateObject("WMPlayer.OCX")

A far less functional VBS script uses exactly the same line and reads the
WMP 11 database perfectly. Any ideas about how to get into the database in
Access VBA?


See if you have permissions to read that key in the registry to create
the object in the first place : HKEY_CLASSES_ROOT\WMPlayer.OCX should
have read permissions for the user account which is running that
script

The single line above is unrelated to reading the WMP database, you
may have to request access permissions from the user (via WMP) in that
case http://msdn2.microsoft.com/en-us/library/bb262910.aspx

Cheers - Neil
------------------------------------------------
Digital Media MVP : 2004-2007
http://mvp.support.microsoft.com/mvpfaqs
.



Relevant Pages

  • Re: VBA Script to Read WMP 11 Database
    ... The script failed on the desktop when I downloaded WMP11, ... Just reviewing the bidding -- WMP 11 responds properly to commands in a VBS ... That's why the computer wouldn't let me manually change the permissions. ... Digital Media MVP: 2004-2007 ...
    (microsoft.public.windowsmedia)
  • Re: VBA Script to Read WMP 11 Database
    ... The script failed on the desktop when I downloaded WMP11, ... Just reviewing the bidding -- WMP 11 responds properly to commands in a VBS ... That's why the computer wouldn't let me manually change the permissions. ... The CREATOR OWNER is likely on windows to be one of the admin accounts ...
    (microsoft.public.windowsmedia)
  • Re: Knowledge Base Article - 815154 Configure SQL Server Security for .NET Applications
    ... db_ roles were inclusive in this context and I'll find the script very ... >> Do I as the admin have to check each and every object one at a time? ... > your application references nor what permissions ... > the user to the fixed db_datareader database role. ...
    (microsoft.public.sqlserver.security)
  • Re: Same Server and DB - Copy users and roles
    ... > The script generator worked great with one exception. ... The permissions set ... > the roles were not transferred along with the role to the new database. ... >> Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Same Server and DB - Copy users and roles
    ... The script generator worked great with one exception. ... The permissions set on ... the roles were not transferred along with the role to the new database. ...
    (microsoft.public.sqlserver.security)