Hello? Gay now!

Willow ,'Showtime'


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!


Sophia Brooks - Aug 24, 2005 12:05:35 pm PDT #4191 of 10003
Cats to become a rabbit should gather immediately now here

Hi--

Here am I with my daily Access question:

Is it possible to create an empty duplicate of a database. Currently, every class has a database, and, while I'd like to eventually make one registration database, right now I would like to not seem like I am changing everything.

In Filemaker, I could save a "clone, no records" copy of the database. It appears there is no good way to do this in Access. I would prefer not to build 35 identical databases.


tommyrot - Aug 24, 2005 12:17:20 pm PDT #4192 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.

Create a new database. Import all the tables from the existing database, but tell Access to import the table design only. (Also, import any queries, reports, forms, etc.)


Sophia Brooks - Aug 24, 2005 12:19:14 pm PDT #4193 of 10003
Cats to become a rabbit should gather immediately now here

Thanks!


Jon B. - Aug 24, 2005 1:23:39 pm PDT #4194 of 10003
A turkey in every toilet -- only in America!

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.


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.

TiVo reports first profit.


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