Solved

Save front end databases in Access

Posted on 2013-05-23
3
569 Views
Last Modified: 2013-05-23
How do I save an access database as just a "front end"? I then want to move that to another computer where I will hook it up to the tables on a network. Thanks!
0
Comment
Question by:cansevin
3 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 250 total points
ID: 39193026
You need to use the database "splitter". In Access 2007, goto Database Tools ribbon, then in the Move Data panel, Choose Access Database.

This should start the wizard. Once you locate the "back end" onto the right click on any linked table in the "front end" and select linked table manager, select all your linked tables and navigate to the network file and select it, then link. You can now copy this to any other computer.


Kelvin
0
 

Author Comment

by:cansevin
ID: 39193042
Thanks Kelvin... I actually did that. Is there a different ending to it when it is only the front end, like a dot something?

Also, to make a separate copy, do I simply copy and past it?
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 250 total points
ID: 39193045
The database front-end and back-end will have .mdb or .accdb filename extensions.

To copy an Access database file, close the database file if you have it open, then go to Windows Explorer and copy it like you would any other file.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question