Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 20th, 2006, 07:17 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Ms Access DB in Server


 Hi Guy's

         What i have to do is centralizing an Access Datadase . (i.e) i want to keep the backend of the DB in One comupter and an the Access frontend in Userend computer . My doubt is weather i have configer my computer into web / file server if so pls give the details or show the web site ih which i can get the detials.
 Pls do this help ( iam going to use this DB only for 6 PC's)
 I think i won't be more complicated to do this .. pls explain me wat i have to do i am blank..

 Thanks in Advance ,

 ur's
 pap Raguv
 
Old February 23rd, 2006, 02:28 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   If you want to make a client/server type of database using Access as the front and back end, then put the back end (tables) on the server, and put a copy of the front end on each users' machine. Make sure they are all mapped to the network drive the same way.

For example, all PCs should see the back end at the same mappng, like "F:\Database\YourBackEnd_be.mdb"

All computers may be able to see it as different mappings, but this will not work, for example if one user sees it as above, and another sees it as "G:\Users\Database\YourBackEnd_be.mdb"

So where ever you develop the database, you need to make sure all computers are mapped the same way when you split the database, using the database splitter.

HTH

mmcdonal
 
Old February 24th, 2006, 02:15 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

 Hi mc,

 I understand wat u said, but i going to use an personal computer as sever using IIS or SQL Server tool .. wat my question is the sever system may get slower when the users are use it .. wat about ur exprience.
and another thing is iam having an idea to use ms publisher as front end is it possible for me generate the report in the ms publisher bcs iam not having any idea on this issue ..

bye,
pap. raguv





Similar Threads
Thread Thread Starter Forum Replies Last Post
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
how to convert ms access db to sql server method SQL Server 2000 1 March 11th, 2005 11:44 PM
MS Access db on a website lawrenceh VB Databases Basics 0 September 25th, 2004 06:32 PM
JDBCRealm using MS access DB ZouK01 Java Databases 0 May 26th, 2004 02:01 PM
JDBCRealm using MS access DB ZouK01 Apache Tomcat 0 May 26th, 2004 01:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.