asked on

Compact MSDE Database

Hi,

I have a local MSDE database, which I access via Microsoft Access 2003.

The problem is that its size is getting quite large. (~ 5MB).

I have deleted all entries from the database, yet it remained the same size - Is there somehow I can company the database (same as I could do in Access) ?

Thanks,

Agmon.

SOLUTION

curtis591

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pique_tech

But how is a user who uses MSDE through Access supposed to implement your suggestion without query analyzer? Can one issue those kinds of commands via ADO or ADOX, or alternately, does MSDE install the command line isql (or osql--I never use it so I can't remember exactly what it is for SQL 2000).

curtis591

You should be able to run that through ADO. All you would need to do is execute the dbcc command. The use command is just switching to the proper database. I would assume you would be connected through ADO to the database you want to do this on.

I have always just Enterprise Manager and query analyzer to connect to the MSDE server so I am not sure if it installs with the command prompt tools.

l_agmon

ASKER

Hmmm...

I don't have Query Analyzer nor Enterprise Manager installed. (They are not free for download).

Is there anoter way in whcih I can run that code?

arbert

"You should be able to run that through ADO. "

Run it as a passthru query in the Access query builder....Or use OSQL from the command prompt...

arbert

Also, here are some MSDE tools that you can use to Administer things:

http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm
http://squirrel-sql.sourceforge.net/index.php?page=faq
http://www.mylittletools.net/scripts/en/mla_sql/
http://www.msde.biz/
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

Brett

ASKER CERTIFIED SOLUTION

pique_tech

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

arbert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

l_agmon

ASKER

Hi All,

I did not manage to compact the database as suggested above, hence I do not really know who to award points to.

Regards,

Agmon.

arbert

You should reply to the question and let us know it didn't work so we can assist you further. There is no way we could know your problem was or wasn't solved without you telling us....

l_agmon

ASKER

You are right. My apologies.