Delete All Tables from MS Access Database

HI

I want to delete all tables from an MS Access database.

i cannot use the designer . i have to do it thru an sql statement

a bunch of statements will also do . .

any body has a solution ?

P.s: All replies will be appreacited

Hi,

this is the SQL Server forum, perhaps you might try a Access forum, which might give you a wider variety of answers and experiences.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Default Values not Selected on Report Manager

I have a report with quite a few parameters, both multivalue and single, all populated from a query. In the Report Designer I have set up default values and everything works great. When I deploy these reports the default values are not being set. Am I missing a step?It's a SQL report or an MDX report?

In the report manager when you choose the parameters and execute the report. It's rendered fine?|||

The server has behavior that it keeps the old parameter defaults that are set, even after republishing. Try deleting the report and republishing.

|||I have not seen the Report Server maintain default parameter values when a report is redeployed. After redeploying the report I have to manually reset the defaults (Properties tab --> Parameters page --> Override Default button).

If there is some property of the server that would persist the defaults between deployments, I'd love to learn about it. Thanks.

Default police

Hi,
How can you define the default police used from the textbox in report
designer ?
Thanks
(a French user...)Police? I'm not sure what the English word is you're trying to say...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"tonio932" <tonio932@.discussions.microsoft.com> wrote in message
news:9CCF34D7-D5D0-4E63-A37E-1DFCFC6C4BED@.microsoft.com...
> Hi,
> How can you define the default police used from the textbox in report
> designer ?
> Thanks
> (a French user...)