INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Split Database Primer

Split Database Primer

(OP)
Is there some resource that would help a newbie to Split Databases learn some of the cardinal rules, like "Don't Do This" or "Always Modify a Table In The Part That Contains The Tables - Not Links To The Tables", etc.

RE: Split Database Primer

I am sure there is something on the web, but it is very simple
1) create two brand new databases
2) Use a naming convention so you know which is front end and back
Backend gets just the tables. Front end gets a link to those tables and all other forms, reports, queries and code.
3) Open the backend and use the import external data feature to import in all the tables. (you are done with the backend)
4) Open the front and use the import external data feature but this time choose link to the backend tables. If you did that correct the tables showing in the front end should have little arrow icons showing that they are links.
5) Make sure to do 4 first. Now do step 4 again but this time import all the other queries, forms, reports and code.
You are done

You can only modify tables in the backend, not possible from the front end.
6) If you move the backend, rename it, change folder location you will have to relink that backend tables.

RE: Split Database Primer

(OP)
MajP.

Thanks much for your reply! I'm not sure that I followed all of your guidelines, when I tried splitting my database the first time. I'll go back and try again.
By the way, does it make any difference whether the database application was written with splitting in mind? I'm sure the database in my case was NOT written with splitting in mind.

RE: Split Database Primer

Any Access database can be split, there is no design ahead of time. You are just putting the tables by themselves into a separate database. Even if you are not splitting a database it is often useful to create a blank new database so it is nice and clean. Then use the import external data feature to import your objects into a clean database. A lot of crap can build up in the background so this is a way to clean it up.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close