I designed a database into which I loaded a good number of
records taking the size of the database up to around
128Mb.  After this I deleted all the records and expected
the size to come back down as well.

I am looking for a way to automatically delete an existing
database ( and all it's tables, etc.)  and then recreate
it.
Problem - I have multiple DTS set up in a SQL database to

Hi,
I have developed a system with backend database Access97.
Number of users that use the system is about 20. The
system has been run for about    3 to 4  years. As number

Upgraded to Access 2003. In Access 2000 I used to be able
to insert a picture into a form, now I find I can only
get a reference to a picture which when selected bring up
the application that created it. How do I get back to an

    I am setting up a database to keep track of
frequencies in various police scanners.  There are 3
police scanners, with up to 400 channels in each one.  I
set up one table that has the following fields, CH Number

I am pulling my hair out trying to get around
this "problem".
I am trying to
(a) concatenate or merge a list of rows in Tbl_A (email

Hi group,
I have Table 1 and Table 2. How can I have a field from
table one added to Table2. I know if I use UpdateQ I'll
get the result, but I don't remember the syntax. ANd I

I'm using two unrelated tables to append another table.  
Each time I run the query, it adds the correct
information, but does it twice.  
Table1: Employee ID, and other employee info

I'm design a database where an employee (--officer) can
issue an asset to employee such as pager and cell phone
so that we can keep track if they return the item yet.
Since Office and Employee are on the same

Hi I am trying to learn how to design a relational database.  I have
designed one database in access 97 but it was a flat database file
since I didn't know how to do relational ones and needed it done
quick.  I am using access 2002 to design this one but it will be read

H
using access 2003 adp mode.
want main sql server database for central common data
want a separate MDB file (jet database) for each project. there maybe many hundreds of projects