 |
| 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
|
|
|
|
May 10th, 2007, 04:23 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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...
|
|
May 10th, 2007, 06:37 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
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
|
|
May 11th, 2007, 01:37 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I have tried but it showing Disk or network error..
please give me some solution
anukagni
|
|
May 11th, 2007, 06:08 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
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
|
|
May 30th, 2007, 11:53 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
Sorry, I have blocked all email from Wrox until they get rid of this douche bag choooper.
mmcdonal
|
|
May 31st, 2007, 07:56 AM
|
 |
Wrox Staff
Points: 18,059, Level: 58 |
|
|
Join Date: May 2003
Posts: 1,906
Thanks: 62
Thanked 139 Times in 101 Posts
|
|
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
|
|
June 13th, 2007, 12:18 AM
|
|
Friend of Wrox
|
|
Join Date: Dec 2005
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hey,
What happen to my question guyz..?
anukagni
Learn as you can..
------------------------
pap...
|
|
June 13th, 2007, 06:22 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
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
|
|
|
