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.
| Author |
Topic |
|
loonatik3
Starting Member
5 Posts |
 Posted - 2003-09-29 : 11:19:38
|
| i have a problem compacting one of my databases which is gigatinormous. When I try to compact and repair I get this message "Table 'TempMSysAccessObjects' already exists", can anyone help me?thanksLoonatik |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-29 : 11:23:33
|
quote:
Originally posted by loonatik3
i have a problem compacting one of my databases which is gigatinormous. When I try to compact and repair I get this message "Table 'TempMSysAccessObjects' already exists", can anyone help me?thanksLoonatik
Well that certainly is quantifiable....How about some specifics...What versionHow big is gigatinormousHave you tried to repair first?Are you trying to compact it into itself?Why do the Jets suck?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
loonatik3
Starting Member
5 Posts |
Posted - 2003-09-29 : 11:28:11
|
| Its just a bit large not too bad, I just want to compact and repair and it comes up with that message. It's Access 2000 and it doesnt matter if I compact it to itself or elsewhere I get the same message. I can compact and repair all my other databases it's just this one. I had a network connection problem on and off with my machine last week and the error message first occurred after that. Is that better? We don't have the Jets over here we have Man United! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-29 : 11:36:02
|
| You didn't answer Brett's questions...What version, how big...Tara |
|
|
|
loonatik3
Starting Member
5 Posts |
Posted - 2003-09-29 : 11:37:54
|
| Access 2000 and its 80kbI am looking into the Jet Compact right now, I'd not heard of it before |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-29 : 11:43:25
|
| 80kb or 80GB? Huge difference. How big of a database does Access 2000 even support?Tara |
|
|
|
loonatik3
Starting Member
5 Posts |
Posted - 2003-09-29 : 11:47:34
|
| Thank you for your help I found the Microsoft Jet has worked now to compact the database thanks. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-29 : 11:55:16
|
quote:
Originally posted by tduggan
80kb or 80GB? Huge difference. How big of a database does Access 2000 even support?Tara
80GB...I think access would choke to death at 1GB..I got a kick out of this in Access helP:quote:
Database has reached maximum size. (Error 3036)To add data to this database, you must first reduce its size by deleting data.
Now why didn't I think of that?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
problem compacting dbase