Solved

Save front end databases in Access

Posted on 2013-05-23
3
562 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

832 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