Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: If I convert to "Front End"/"Back End"

    If I convert my .mdb file to a "front end/back end" database, will I be able to add tables and relationships or any other things once it is split?

    Michael
    Gotta to do some code

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes
    the back end contains the data so you define all columns, relationships etc in the back end, these can be changed as required (however you can only take changes if you have exclusive access to the mdb containing the data

    the front end contains queries, forms & reports, and as above you can make whatever changes your require, providing you have exclusive access other the mdb containing the front end
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    To which? A simple answer is YES ...
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    one caveat...
    When you make a change to a table on the back end (like adding a column),
    you need to refresh the links on the front end in order to see the change.
    Inspiration Through Fermentation

  5. #5
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    I am trying to split a database now. When I name the file it only gives the first letter. Example: I name it WorkOrder and it shows up as W.mdb

    Any ideas of this error?

    Michael
    Gotta to do some code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •