Create Empty Access DB From an Existing Access DB

[DavidMS]

I have a production access application with no development environment. We need to create a develoment access environment with an empty db. We are not allowed to see the production data. How do I create a template of the existing db and then use it to create my development environment

[NeoPa]

This all really depends on what you mean by "with no development environment".
If it's not an MDB file and you don't have the MDB file it was created from, then it appears that someone has made a grand faux-pas.
Is that what you're trying to say?

[DavidMS]

This all really depends on what you mean by "with no development environment".
If it's not an MDB file and you don't have the MDB file it was created from, then it appears that someone has made a grand faux-pas.
Is that what you're trying to say?

I do have a MDB file. It has my production forms and data. I can copy it over to the development world. I just need a way of deleting all of the data but keep the tables.

[NeoPa]

Clearing the data from a single table is simple enough :

DELETE
FROM [TableName]

You can apply a WHERE clause too if you want to keep any of it.

[NeoPa]

The following code should be used with caution. Do it only on the copied version.

Public Sub ClearAll()
  Dim tblThis As TableDef
  Dim strSQL As String
 
  For Each tblThis In CurrentDb.TableDefs
    With tblThis
      If Left(.Name, 4) <> "MSys" Then
        strSQL = Replace("DELETE FROM [%T]", "%T", .Name)
        Call DoCmd.RunSQL(strSQL, False)
      End If
    End With
  Next tblThis
End Sub

[NeoPa]

Please let us know how well this works for you, or if you come across any Cascaded-Delete type issues.

[nico5038]

Just a warning, first check or the tables aren't linked !

Just open the table in design mode and when there's no warning that you can't change the definition, it's OK.
Linked tables also have an icon with a black arrow.

Nic;o)