there is not enough disk space

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

there is not enough disk space

Author

Topic

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-08 : 12:30:14

Hi All
In a table the amount field is imported as Text...When i try and change it to Currency, I get the error message that there is not enough disk space...any quick way to correct this problem?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-04-08 : 12:35:07

You'll need to move the MDB file to a larger disk. You could also try compacting the database before you do the conversion, that will free up space but you'll probably need to move it anyway.

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-08 : 12:40:15

Thanks,

I am using MS Access 2007, how to do this.
just copy past the accdb file to larger disk will this do?

Regards,
aak

quote:
Originally posted by robvolk

You'll need to move the MDB file to a larger disk. You could also try compacting the database before you do the conversion, that will free up space but you'll probably need to move it anyway.

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-08 : 12:53:01

My disk size is 150GB, then also I am getting this err.
and the accdb file is placed on the same disk

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-04-08 : 13:07:54

you have a 150 GB access file? wow!

may the gods have mercy on your soul

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-08 : 13:43:46

Sir,

It is not 150GB file its 150GB disk
the file is not that big. it is in mb less than 100mb.

Regards,
aak

quote:
Originally posted by spirit1

you have a 150 GB access file? wow!

may the gods have mercy on your soul

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-09 : 01:24:17

any help on this ?

dsindo
Starting Member

45 Posts

Posted - 2009-04-20 : 17:31:20

compact and repair the mdb then try changing the datatype again.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources