Segregating database schema from my data

  • Thread starter Thread starter George Papadopoulos
  • Start date Start date
G

George Papadopoulos

Hello everybody

I have this problem. The database I have built has the database schema
integrated along with my data. I would like to segregate the schema, as well
as the design of my forms from the actual table schema and their relations.
Is that possible under Access?
I currently have set my database to open up a splash form, when I press on
the mdb file. Could that complicate things further?

thx, in advance

George Papadopoulos
 
George,

What you're describing is the classic front end / back end scheme... as a
matter of fact so classic that Access has a built-in wizzard to do it! The
menu path is Tools > Database Utilities > Database Splitter.
Don't be afraid of complications, it can only make things better, especially
if you plan for your database to be a multi-user one (in which case the
split is an absolute must). In that case, take some time to browse through
the access.multiuser newsgroup, it will save you lots of time and grief!

HTH,
Nikos
 
Back
Top