FE/BE question

I'm currently making some modifications to a copy of a database that is not
split. The mods are to both forms/reports, as well as tables. After I
finish the modifications, I intend to try splitting the database so there is
a FE/BE structure. Because users are still using the original database, data
in the tables has changed, so at some point, I will need to ask everyone to
stay out of the original so I can make the table structure updates without
losing any data.

In my mind, a split database is really nothing more than my Front End (being
all the forms and reports) with linked tables (which is the Back End). So if
I get rid of the tables in my modified database, then make the table mods in
the original database, and finally use the "File - Get External Data - Link
Tables" feature in the modified one to link the tables from the original one,
that in turn creates my split database.

My question is this: Is my thinking correct on this? Does that in fact
create a "split database"?

Having never done this before, I guess I wanted to make sure I was looking at
this in the right frame of mind. I appreciate any opinion!

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: The amazing disappearing VBA code
    ... Windows Explorer, and make a copy of your database, as Access is about to ... the original database wasn't deleted because it is read-only. ... might be an issue with mapped drives like when were the last updates from MS ... resource management in the OS or any other application is hoarding RAM. ...
    (microsoft.public.access.modulesdaovba)
  • Re: copying ? Record #isnt working
    ... If you have copied to old database there is no need to put the ... If you wish to keep the old database simply rename it "MyDbOLD.mdb". ... Then re-name the new updated database to the original database name ... ' Rename original Db to a new name in the same folder ...
    (microsoft.public.access.gettingstarted)
  • Re: Run-time error 2465 after database import
    ... The original database is in Access 2000 and the ... and importing everything from the original database. ... Visual Basic Editor - Tools / database Properties ... If I go into debug at this point and try using PaddedLotNumber ...
    (microsoft.public.access.formscoding)
  • Re: Altering Identity Columns for Bidirectional Transasctional Replication
    ... Backup the original Database containing all the data: ... Destroy the orginal database and recreate the database only. ... Take the scripts that created the original database (if none is ...
    (microsoft.public.sqlserver.replication)
  • Re: autonummering in table gives problems
    ... manually recreate the "bad" records in the new table, ... sequence of AutoNumber identifications may be regenerated (but don't count ... I made the new database with all the ... > the original database). ...
    (comp.databases.ms-access)