Re: splitting app & db in 2007

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks, some things are so simple yet hard to find.

Jeff Boyce wrote:
1. Make two copies of the file.

2. Rename one something like "YourApp_FE"; rename the other something like
"YourApp_BE".

3. In "YourApp_BE", remove everything but the tables (all forms, queries,
...)

4. In "YourApp_FE", remove all the tables. Then "link" to the tables in
"YourApp_BE".

5. Celebrate - you're done. (it can get a little more complex, if you're
setting this up as a multi-user application...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

can anyone point me to a step-by-step on how to separate my app/code from
the
tables. I've looked at various materials; books, forums, including skimpy
material on the Microsoft access site and couldn't find anthing
worthwhile.
Any help & guidance appreciated

--
Thanks
Brian

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

.

Relevant Pages

  • Re: splitting app & db in 2007
    ... setting this up as a multi-user application...) ... Jeff Boyce ... Microsoft Office/Access MVP ... I've looked at various materials; ...
    (microsoft.public.access.setupconfig)
  • Re: How do you categorize sum of fields
    ... If you are currently handling this via a spreadsheet, ... "Jeff Boyce" wrote: ... Created a table (tbl PO) with the following fields: ... the fields Avg Of Paper% + avg Of Other Materials + avg Of Other ...
    (microsoft.public.access.gettingstarted)
  • Re: Redesign slow database or archive records ?
    ... Wide Area Network to run an Access application. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Initial database entry. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form does not open in design view
    ... You can probably find a copy of JetComp the same way, ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... While I am in design view of this form, I get a memory error - ...
    (microsoft.public.access.forms)
  • Re: Change Filed type using VB
    ... Jeff Boyce ... Microsoft Office/Access MVP ... An alternative to just "taking it" and changing it via VBA code would be ... to create a table definition in Access that has the field data types you ...
    (microsoft.public.access.tablesdbdesign)