• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

Save front end databases in Access

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
cansevin
Asked:
cansevin
2 Solutions
 
Kelvin SparksCommented:
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
 
cansevinAuthor Commented:
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
 
pdebaetsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now