Can Access do this

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

Hi

I am in the process a developing a database for an
organization. I am not sure whether should I use
Access/VBA or SQLSERVER/VBA or ASP.NET/SQLSERVEr. The
problem is that we have users for this new system on two
different networks. Forexample some users r on "H" drive
and Some are on "P" drive and network guys cant give
permission due to security reasons to access eachother
network drives.

But we need one database for these people. How can I do
and what choices I have . also please advice as whether i
use Access for this purpose as most of the users(lets say
30) will be inputting data in the database.

thanks in advance

Regards

Neha
 
Hi Neha,

I'm not sure what you mean about network drives, anyhow whether it's Access
or SQL Server or another backend database technology the users are going to
need a central location to access the database. Example:

Users on Domain "A"
\
\
\------------- Database
residing on
/------------- Trusted
Domain "C"
/
/
Users on Domain "B"


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| Content-Class: urn:content-classes:message
| From: "ali" <[email protected]>
| Sender: "ali" <[email protected]>
| Subject: Can Access do this
| Date: Wed, 25 Feb 2004 05:50:21 -0800
| Lines: 21
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP7pk+/pV9/IxinSWCUgg8N07svRQ==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:8682
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.security
|
| Hi
|
| I am in the process a developing a database for an
| organization. I am not sure whether should I use
| Access/VBA or SQLSERVER/VBA or ASP.NET/SQLSERVEr. The
| problem is that we have users for this new system on two
| different networks. Forexample some users r on "H" drive
| and Some are on "P" drive and network guys cant give
| permission due to security reasons to access eachother
| network drives.
|
| But we need one database for these people. How can I do
| and what choices I have . also please advice as whether i
| use Access for this purpose as most of the users(lets say
| 30) will be inputting data in the database.
|
| thanks in advance
|
| Regards
|
| Neha
|
 
You could keep the two separate databases and use Access' replication
feature to synchronize between the two versions. The two networks must
still have a common point of connection to use for synchronizing.


Hi

I am in the process a developing a database for an
organization. I am not sure whether should I use
Access/VBA or SQLSERVER/VBA or ASP.NET/SQLSERVEr. The
problem is that we have users for this new system on two
different networks. Forexample some users r on "H" drive
and Some are on "P" drive and network guys cant give
permission due to security reasons to access eachother
network drives.

But we need one database for these people. How can I do
and what choices I have . also please advice as whether i
use Access for this purpose as most of the users(lets say
30) will be inputting data in the database.

thanks in advance

Regards

Neha
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
No access can't do what your asking, surely the network
administrators can give one folder its own security
permission, don't take no for an answer this is a very
basic network permissions issue.
 
Hi

thanks for everyones contribution. I think I didnt explain
the question properly.

I have users on three different networks.(think of three
companies having their own networks). These networks dont
talk to each others and they dont let eachothers user to
access data because of data sensitiviy and security issues.

I have to create one database for these three network
users. I came up with the soln that I can put replica of
my database on two networks and at the end of every week
they will email me database and I syncronize the data at
the third location.

This seems to me one of the soln. But some one suggested
that If i use SQLSERVER as a backend, this problem can be
solved and we can put our database on one network and
other networks can access it ( i dont know how this make
any sense when you dont let other users to talk to your
network).

My Question is that is it possible in SQL Server? or the
soln I suggeted is the only soln in this case.

Thanks in advance

Neha
 
emailing a replica between computers will eventually lead to database
corruption, so your solution is not recommended. See
http://www.trigeminal.com/usenet/usenet009.asp

Replication requires a connection such as LAN, WAN, internet, or
dialup.


If you don't have a common point of connection, perhaps you need to
mount the database on a web site somewhere?

Hi

thanks for everyones contribution. I think I didnt explain
the question properly.

I have users on three different networks.(think of three
companies having their own networks). These networks dont
talk to each others and they dont let eachothers user to
access data because of data sensitiviy and security issues.

I have to create one database for these three network
users. I came up with the soln that I can put replica of
my database on two networks and at the end of every week
they will email me database and I syncronize the data at
the third location.

This seems to me one of the soln. But some one suggested
that If i use SQLSERVER as a backend, this problem can be
solved and we can put our database on one network and
other networks can access it ( i dont know how this make
any sense when you dont let other users to talk to your
network).

My Question is that is it possible in SQL Server? or the
soln I suggeted is the only soln in this case.

Thanks in advance

Neha
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Thanks for your reply. I consider the website option but
my client is not interested in it.

The other option could be is to have a field in both
databases with data type "ReplicationID" and at the end of
the day user can export the data in xml, text format and
email it to me and i can import it in third database. Is
this sound ok?

Can u export/Import whole Access database in MS Access
2002 instead of exporting/importing each table

A friend of mine suggested that I can create Linked Server
in SQl Server 2000 and the create user groups.

Can some one elaborate on it or my first soln is better.

this is my first professional job after school so thats
why I m going through real tough time at my work

Regards

Confused Neha
 
Thanks for your reply. I consider the website option but
my client is not interested in it.

The other option could be is to have a field in both
databases with data type "ReplicationID" and at the end of
the day user can export the data in xml, text format and
email it to me and i can import it in third database. Is
this sound ok?

Can u export/Import whole Access database in MS Access
2002 instead of exporting/importing each table

A friend of mine suggested that I can create Linked Server
in SQl Server 2000 and the create user groups.

Can some one elaborate on it or my first soln is better.

this is my first professional job after school so thats
why I m going through real tough time at my work

Regards

Confused Neha
 
Back
Top