Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 20th, 2006, 06:17 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
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
Reply With Quote
  #2 (permalink)  
Old February 23rd, 2006, 01:28 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
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
Reply With Quote
  #3 (permalink)  
Old February 24th, 2006, 01:15 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 10: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



All times are GMT -4. The time now is 04:11 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.