Deleting reports from another database

[Artc]

I have created a client server application where users can create reports locally and on the server through the docmd.transferobject.

However, the reports i placed on the server, i want to clean from the client side, so each user can delete what he placed in the server. But using docmd.deleteobject acreport,reportname only deletes the one in current db.

Is there anyway to say i want to delete the report "ReportX" in say "//company/servermdb.mdb" ?

I had spent the whole afternoon already trying to figure it out.

Thanks for any response - Art

 

[vidny]

I believe it is able to be done, but it is a pain. The basic problem is that you can only make alterations to the current mdb unless you define a Workspace. I do have sample code somewhere but don't have time to find it right now. I think if you search help for Workspace's it may lead you somewhere. If this is a really big problem for you, respond back an I should be able to find the sample code in a week or so. I've got to deliver a functioning program next week.

 

[Artc]

i really desperately need it vidny. I had tried the shell command API to open the server's mdb file which automatically read a file and execute from it. But when i do it from the access client mdb it wont work. Manually it does.

I also tried automating it by creating another access app , and executing deleteobj from that database but to no avail.

I would really appreciate oit if you could email me. I tried looking for workspace, and assigning another db to that workspace. But I dont know how to docmd.delete object which could take a report from that db2 as parameter.

still hoping .... Art