Create New Back End DB

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I have an access app that is split into Front End and Back End DBs. Is there
anyway to automatically create a blank Back End DB that has the same
structure but no data?

For instance, the deparment manager wants to be able to click a button,
choose a path and filename, and then this would create a new back end but
with no data in it.

I have the code from The Access Web that would allow a new back end to be
linked, but I do not know how to automatically create the blank back end DB.

Any ideas?

Thanks in advance

Joe
 
Sure. On my website (www.rogersaccesslibrary.com) is an of Access sample
database that might help. Look for: "ImportToTempDatabase.mdb". I use this
process to create a temporary back-end to be used for importing and updating
data. Using a temporary database reduces bloat. But the same process will
work for what you want to do. Look in the "basCreateDatabase" module for
the relevant code. Also, it creates the TempDB when the app opens and
deletes when the app closes, so you'll want to change that.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top