[mso] Re: Access question
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 9 Apr 2003 13:16:48 -0400
Karen-
Access 2000 is good, it seems to handle multiple connections pretty well.
Access 2000 also supports replication. Where there is a 'master' copy of the
backend database. Each user has a replica of this and makes changes/updates and
then synchronizes with the master.
How would the external user connect to you? VPN, terminal service, Citrix? and
more importantly how would Access connect from the outside? All these protocols
are different in how you would approach programming Access connectivity.
-Anthony
-----Original Message-----
From: Karen Willingham [ mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, April 09, 2003 11:33 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access question
What version of Access are you using? 2000
How is the external user networked to your network? We sit on a LAN with T1
.
Creating a new .mde each week seems like allot of work. At time its months
before I do a update. But at times its once a week or more.
===================================
Karen-
Looks like you have an interesting project going on. What version of Access
are you using? How is the external user networked to your network? Both of
these answers might determine how to proceed.
Creating a new .mde each week seems like allot of work. If your deploying an
application to a remote location weekly, and the external user needs to
link/relink tables, seems likely allot could go wrong there too. You'll need
to
build an interface or at least a check in code.
One issue that SQL server will help solve is security. If you have remote
users accessing your database they can do as they please, in MS Access there
is
basically no real security model. In SQL server you can define who has
access
to tables, views, procedures.... SQL server will help with having many
concurrent connections too. It handles it much better than Access.
Do you have access to a Citrix server/client? One issue with remote users is
that they might not log off when you need to make changes in the backend
database. You as Admin will not be able to log them off, so your stuck.
Using
Citrix you can place the front end and back end on your server and have the
external users access the front end from their network connection.
Everything
will reside at your location.
-Anthony
-----Original Message-----
From: Karen Willingham [ mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx
< mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx> ]
Sent: Wednesday, April 09, 2003 9:44 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access question
Lets see where to start.
1. Access is divided into 2 parts.
a)One part has the tables (44) One is the master with all items and pricing
info one is descriptions and other items not use often. Leaves 42 other
tables with each list of Items that is sold to each company. [We send out
pricing updates to each company of items only they buy from us]. I have most
tables set with relationship to Cascade Update Related to code (primary key)
. Since Access limits how many relationship you can have I had to do a work
around ( Master Table relation to Description Table then a relation to a few
tables so they get the new code.)
b)2nd part has the forms and queries and reports.
2. At this time 3 different people use us it. I have to now let someone else
use it. She works in a different town. We are networked. My Questions is:
What's the best course to do the new tables (about 15) I need to build for
her companies she deal with. She will use the Master table and the
description table, I need to add relationship so if a code is change it will
change on your other tables. Should I have a file for just the Master Table
and Description Table? Then do a 2nd file for each town set with there
tables and have the master and description link with the relations set
there?
Note: I build the 2nd part of the database as a .mde for them to use.
Sometimes it gets updated once a week. Each time they will have to relink
all the tables.
Do you think it would be best to make the tables set on a SQL server? Since
I have so many tables that needs to have a relationship say 75 tables? If so
what's the next step?
Karen
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
