Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| 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 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 March 24th, 2006, 02:17 AM
Registered User
 
Join Date: Mar 2006
Location: , , Hong Kong.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to Upload Access DB to the intranet

Hi All,
I have created an Access DB with some forms, queries and VBA. I want to set up a few different levels of access right and put it on the intranet. So that my colleagues (roughly about 15) can use it if they are connected to the LAN.
As I'm new to Access and programming, what's the easiest and quickest way to meet my needs?
1) Allow users to log in the system with their username and password.
2) Different leverls of access right (e.g. Read-Only, Edit, Admin)
3) Access the Database thru LAN
4) Multi-users to use the DB at the same time
5) Audit Tracking
I need these solutions ASAP.
Thank you very much for your help!!

 
Old March 24th, 2006, 01:10 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,

   Standard procedure is to use the Database Splitter and store the back end in a netowrk folder to which all your users are mapped the same. Then distribute the front end to all your users.

HTH


mmcdonal
 
Old March 25th, 2006, 05:50 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,

   iam also having the same doubt i.e. if i want to share my DB to different user with different level then i have to set an file server.Is it correct?, then if i am doing like that for eg. iam using an sql server how sould i make my Ms Access backend in the server .i.e converting the DB for SQL server .. pls help me .. and it is possible for me to adapte the some to Linux server with MySQL option ..

 thank in adavance..
bye,
pap
 
Old March 27th, 2006, 02:47 AM
Registered User
 
Join Date: Mar 2006
Location: Odessa, Odessa, Ukraine.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Our solution:

your fax server re-sends image files to our email address;
we change image file name to a reference mentioned on it;
then files are sent to your FTP Server, email address or attached to web form;
thus you can use names of image files as references in order to post e-documents to the designated cells of a database.

For detail information welcome to our website http://www.alcom.od.ua
e-mail: alcom@te.net.ua or alcom.info@gmail.com



All things are difficult before they are easy (Thomas Fuller)





 ALcom offers a cost effective service in Document Image Processing (DIP).
For detail information welcome to our website http://www.alcom.od.ua

Kind Regards,
Konstantin
ALcom,
Sales Manager
e-mail: alcom@te.net.ua or alcom.info@gmail.com

I hope this message finds you well. Thanks for the opportunity to brief you our cost effective services in Document Image Processing (DIP).

 

Our solution:

your fax server re-sends image files to our email address;
we change image file name to a reference mentioned on it;
then files are sent to your FTP Server, email address or attached to web form;
thus you can use names of image files as references in order to post e-documents to the designated cells of a database.
You may try 3 days for free!!! The free trial period can be prolonged!!!
 
Old March 27th, 2006, 04:36 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

wats the meaning hide in the above mess , J.K.W.Y did u understand?



P.A.P.Raguv
 
Old March 28th, 2006, 09:43 PM
Registered User
 
Join Date: Mar 2006
Location: , , Hong Kong.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by anukagni
 wats the meaning hide in the above mess , J.K.W.Y did u understand?



P.A.P.Raguv
It's an ad. I guess... ...

 
Old March 29th, 2006, 01:49 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

OOH i know ,
        But wats the solution ...? my head is blasting pls any body give an solution for the above said issue....

bye

P.A.P.Raguv




Similar Threads
Thread Thread Starter Forum Replies Last Post
How to upload complex xml file to 1 db table vangogh XML 3 October 8th, 2007 04:43 AM
upload multiple files in db with persits aspjpeg dann2 Classic ASP Basics 0 May 10th, 2007 11:20 PM
how to upload a mysql db on web server umair_rathore MySQL 2 May 14th, 2005 05:46 AM
How to upload a database onto the intranet? MilkPudding Access ASP 8 June 16th, 2004 03:17 PM
Q. How do I upload files to a DB and view them? richard.york PHP FAQs 0 April 3rd, 2004 07:45 PM





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