I need to delete Reports ( or non file objects)in not CurrentDB,How ?

[Artc]

I want to make users in client side DB be able to access another DB (server.MDB) and delete the reports there that he/she placed in using the docmd.databasetransfer. Is there any way of doing this ?

Or I just have to link to that other MDB in the server side and executew deletion from there. I'm not sure how can this be done .

Any help is gereatly appreciated.

 

[mymou]

I guess you can use automation - cant think of an easier way.

Sub deletereport()

Dim aApp As New Access.Application
aApp.Visible = True
aApp.OpenCurrentDatabase ("OtherDataBase.mdb&quot
aApp.DoCmd.DeleteObject acReport, "rptToBeDeleted"

End Sub

Hope it helps


Stew

 

[Artc]

thanks. But I tried it and didnt work.

I have the following code...
on my client's MDB delete_report module
but still it doesnt work:

aApp.DoCmd.DeleteObject acReport, strRpt

I also tried the shell command and still doesnt.
I made the server MDB an auto function to delete the report
but it is still a no go.

I'm already so frustrated at this point.

Thanks for trying - Art

 

[mymou]

Everything works fine over here.

What error messages come up - and where in the code?

Stew

 

[Artc]

Thanks anyways. What i did was perhaps the hardway. I created the server mdb to be an auto run job which will read the list of report to delete, and delete the reports and quit.

My client side MDB will shell to this MDB everytime.

- Art