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
| 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 Search this Thread Display Modes
  #1 (permalink)  
Old May 10th, 2007, 04:23 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 Access Vs Server

I want to deploye my ms access datbase in a microsoft server 2003 .
 i want some idea how to deploye it & i dont want to use my sql or sql for this process ....

 please give me some idea to do this so...

anukagni

Learn as you can..
------------------------
pap...
Reply With Quote
  #2 (permalink)  
Old May 10th, 2007, 06:37 AM
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

Split the database into a back end with tables only, and perhaps some queries if you are processing very large amounts of data, and store the back end in a folder that all your users have access to and is mapped the same way. The front end should have everything else (queries, forms, reports, modules [what's a macro?]) and you can either leave this in a single folder and give your users a shortcut to the file, or distribute the file to each user. The problem with the second option here is that if you make a change, the users will all have to get the new version.

You also have the option of connecting the front end directly to the back end, or using code to pull and push data depending on the action in the front end. Usually when I uses Access/Access I do the former, and when I use Access/SQL I do the latter (prevents persistent connections to the server.)

Is that what you wanted?

mmcdonal
Reply With Quote
  #3 (permalink)  
Old May 11th, 2007, 01:37 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

I have tried but it showing Disk or network error..

 please give me some solution

anukagni
Reply With Quote
  #4 (permalink)  
Old May 11th, 2007, 06:08 AM
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

I'm sorry, but I don't understand what you have tried and on what process that error is being thrown. Can you give me more details?


mmcdonal
Reply With Quote
  #5 (permalink)  
Old May 30th, 2007, 11:53 AM
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

Sorry, I have blocked all email from Wrox until they get rid of this douche bag choooper.

mmcdonal
Reply With Quote
  #6 (permalink)  
Old May 31st, 2007, 07:56 AM
jminatel's Avatar
Wrox Staff
Points: 18,940, Level: 59
Points: 18,940, Level: 59 Points: 18,940, Level: 59 Points: 18,940, Level: 59
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Location: Indianapolis, IN, USA.
Posts: 1,945
Thanks: 73
Thanked 139 Times in 101 Posts
Default

mmcdonal: He's blocked, still in the process of deleting the last of his junk. Sorry. I'm having to do this every morning with at least one spammer.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press

Jim's Book of the week: No book this week - Donate to the Red Cross!

Last edited by jminatel; May 18th, 2016 at 04:17 PM.. Reason: deleted dead link
Reply With Quote
  #7 (permalink)  
Old June 13th, 2007, 12:18 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

Hey,

 What happen to my question guyz..?

anukagni

Learn as you can..
------------------------
pap...
Reply With Quote
  #8 (permalink)  
Old June 13th, 2007, 06:22 AM
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

I am not sure what the problem is. You should develop the database as one file, and then split it to a network drive that all your users can map to as the same drive and path (that is the easiest way to do it). Use the database splitter.

What exactly did you do that gave you an error?




mmcdonal
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
how can i access my url outside my server? priyaram SQL Server 2005 12 February 14th, 2007 12:20 PM
remote server access javatamil Java GUI 1 March 16th, 2005 11:01 AM
Sql server access problems mbje ADO.NET 0 October 29th, 2004 03:18 AM
Server access lamada BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 3 August 23rd, 2004 03:44 PM
Access on Terminal Server rbrady Access 0 April 14th, 2004 08:43 AM



All times are GMT -4. The time now is 04:51 PM.


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