If there aren't that many tables/records, you could also make a copy of the mdb file in explorer, then open the database, open each table, and delete all the records in each table.
Mal: He calls back, you keep them occupied. Wash: What do I do, shadow puppets?
'The Message'
Buffistechnology 2: You Made Her So She Growls?
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Jon B. - Aug 24, 2005 1:23:39 pm PDT #4194 of 10003
A turkey in every toilet -- only in America!
tommyrot - Aug 24, 2005 1:29:31 pm PDT #4195 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Or you could enter and run the following function
Function cleartables()
Dim tdf As TableDef
DoCmd.SetWarnings False
For Each tdf In CurrentDb().TableDefs
if left(tdf.name,4) <> "msys" then
DoCmd.RunSQL "DELETE FROM " & tdf.name
end if
Next
DoCmd.SetWarnings True
End Function
I forgot how to quote while preserving formatting, which is why nothing in the above is indented....
eta: wait, don't do that, as it deletes system tables too.
eta2: There. All better.
§ ita § - Aug 25, 2005 3:26:37 am PDT #4196 of 10003
Well not canonically, no, but this is transformative fiction.
Sophia Brooks - Aug 25, 2005 4:15:30 am PDT #4197 of 10003
Cats to become a rabbit should gather immediately now here
Thanks tommy and DX. I'm going to get the hang of this soon, I hope!
Jon B. - Aug 25, 2005 4:31:24 am PDT #4198 of 10003
A turkey in every toilet -- only in America!
TiVo reports first profit.
Well, breakeven actually. But still! Good News!
Jessica - Aug 25, 2005 4:53:57 am PDT #4199 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
TiVo reports first profit.
Hooray!
Consuela - Aug 25, 2005 5:18:44 am PDT #4200 of 10003
We are Buffistas. This isn't our first apocalypse. -- Pix
Go TiVo! t clings to her TiVo
Sophia Brooks - Aug 25, 2005 6:50:11 am PDT #4201 of 10003
Cats to become a rabbit should gather immediately now here
This is NOT an Access question....
I am trying to use limewire (windows something-- I don't know how to find out.
Limewire says that I am either not connected to the internet or there is a firewall bloacking me.
I checked the firewall, and limewire is listed as an exception.
I turned the firewall off
I still cannot connect through limewire.
I am clearly connected to the internet, as I am typing this
My cow-orker is using limewire Right Now, AIFG, with the same computer, network connection, etc.
Any ideas?
Do I need to change the port? How would I know what to change it to?
Gandalfe - Aug 25, 2005 7:03:48 am PDT #4202 of 10003
The generation that could change the world is still looking for its car keys.
Limewire is EVIL. EEEEEEEEVIL. Bad, spyware laden piece of crap.
But you can try looking at [link] to see if they have anything on it.
Jessica - Aug 25, 2005 7:39:19 am PDT #4203 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Gmail apparently open to everyone now.
I can't see the supposed "Sign up for Gmail!" thingy on the front page, but that might be because Google thinks I'm in the UK. (And my Gmail account still says "Gmail Beta" in the logo, but maybe they just haven't gotten around to changing that yet?)