| Author |
MS Access network ver.
|
|
| sparkle_vy 2005-04-06, 8:06 pm |
| Hello,
can somebody please explain to me what ms access version should i use for
mutliple users? is there an ms access network ver.?
i will appreciate your help. thanks!
vy
| |
| Rick B 2005-04-06, 8:06 pm |
| Read your post from yesterday.
"sparkle_vy" < sparkle_vy@discussio
ns.microsoft.com> wrote in message
news:F43DB21F-DC57-4653-B29F- 8266EAD5B7AB@microso
ft.com...
> Hello,
>
> can somebody please explain to me what ms access version should i use for
> mutliple users? is there an ms access network ver.?
>
> i will appreciate your help. thanks!
>
> vy
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| hi rick!
i ddin't get any response from my yesterday's posting. i saw your response
to a posting similar to mine, can you give me some thoughts about mine. i
don't know if there's such a thing as ms access network ver. or what we can
use for multiple users?
thanks!
"Rick B" wrote:
> Read your post from yesterday.
>
>
> "sparkle_vy" < sparkle_vy@discussio
ns.microsoft.com> wrote in message
> news:F43DB21F-DC57-4653-B29F- 8266EAD5B7AB@microso
ft.com...
>
>
>
| |
| Rick B 2005-04-06, 8:06 pm |
| Your post from yesterday has SEVERAL responses. go look at it.
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:1BFE2C95-A287-4DD6-BD55- DAD49A6B6B5B@microso
ft.com...
> hi rick!
>
> i ddin't get any response from my yesterday's posting. i saw your
response
> to a posting similar to mine, can you give me some thoughts about mine. i
> don't know if there's such a thing as ms access network ver. or what we
can[color=darkred]
> use for multiple users?
>
> thanks!
>
> "Rick B" wrote:
>
for[color=darkred]
| |
| Rick B 2005-04-06, 8:06 pm |
| Make that "2" posts. One from me, and one from an MVP.
Rick B
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:1BFE2C95-A287-4DD6-BD55- DAD49A6B6B5B@microso
ft.com...
> hi rick!
>
> i ddin't get any response from my yesterday's posting. i saw your
response
> to a posting similar to mine, can you give me some thoughts about mine. i
> don't know if there's such a thing as ms access network ver. or what we
can[color=darkred]
> use for multiple users?
>
> thanks!
>
> "Rick B" wrote:
>
for[color=darkred]
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| i can't find it. there's just one post dated 03-31-05; running slow
report..., i can't find mine.
"Rick B" wrote:
> Make that "2" posts. One from me, and one from an MVP.
>
> Rick B
>
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:1BFE2C95-A287-4DD6-BD55- DAD49A6B6B5B@microso
ft.com...
> response
> can
> for
>
>
>
| |
| Rick B 2005-04-06, 8:06 pm |
| From John...
On Thu, 31 Mar 2005 14:01:04 -0800, "sparkle_vy"
< sparkle_vy@discussio
ns.microsoft.com> wrote:
>help! i'm developing a database, very complicated one and it will be saved
>in a server. there will be multiple users for this database, what version
of
>ms access can i use?
1.0, 1.1, 2.0, 95, 97, 2000, 2002, or 2003 should work just fine.
Access is multiuser out of the box.
>is there such thing as ms access network version?
All of the above.
What you'll need to do is use the Database Splitter Wizard, or
manually split the database into a "Frontend" containing the forms,
reports, queries and so on, linked to a shared "Backend" containing
only the data tables. Each user will need Access installed (either
retail Access or the "runtime" available from the Developer's
Toolkit), and a copy of the frontend.
John W. Vinson[MVP]
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:0306FB25-67C6-4557-8EFD- 6D347489600E@microso
ft.com...[color=darkred]
> i can't find it. there's just one post dated 03-31-05; running slow
> report..., i can't find mine.
>
> "Rick B" wrote:
>
mine. i[color=darkred]
we[color=darkred]
use[color=darkred]
| |
| Rick B 2005-04-06, 8:06 pm |
| From me...
Any version of Access will work.
Each user will need Access on their local machine, unless you plan to
purchase the developer's edition and package the database application with a
run-time version of Access.
Do your users all have the application?
How many users will you have?
Are you a pretty advanced application developer?
Rick B
"sparkle_vy" < sparkle_vy@discussio
ns.microsoft.com> wrote in message
news:AD26B899-5E84-45B8-B1C1- 87150EBF1C46@microso
ft.com...
> help! i'm developing a database, very complicated one and it will be
saved
> in a server. there will be multiple users for this database, what version
of
> ms access can i use? is there such thing as ms access network version?
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:0306FB25-67C6-4557-8EFD- 6D347489600E@microso
ft.com...[color=darkred]
> i can't find it. there's just one post dated 03-31-05; running slow
> report..., i can't find mine.
>
> "Rick B" wrote:
>
mine. i[color=darkred]
we[color=darkred]
use[color=darkred]
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| i only saw 2 postings for 03-31-05: compacting and reparing and record
locking, i can't find mine.
"Rick B" wrote:
> Make that "2" posts. One from me, and one from an MVP.
>
> Rick B
>
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:1BFE2C95-A287-4DD6-BD55- DAD49A6B6B5B@microso
ft.com...
> response
> can
> for
>
>
>
| |
| Rick B 2005-04-06, 8:06 pm |
| You did not post it in the multiuser newsgroup.
you posted it in microsoft.public.access
Rick B
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:B3E86CA6-2331-4C66-8CF6- FA98938D73CE@microso
ft.com...[color=darkred]
> i only saw 2 postings for 03-31-05: compacting and reparing and record
> locking, i can't find mine.
>
> "Rick B" wrote:
>
mine. i[color=darkred]
we[color=darkred]
use[color=darkred]
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| thanks! i got the one you forwarded from mvp too.
there will be at least 10 users who will update and work on the database. i
was wondering why is it that when my coworker tried to open the database
while i am also using it didn't allow her to open the database. and we're
using ms access 2000. it's not allowing us to open/update at the same time.
yeah, the users have the application on their own hard drive and the database
file is saved on the server.
nope, im just learning to use ms access, i know a little of c++ and that's
it. i will need alot of tips to finish a project.
thanks
"Rick B" wrote:
> From me...
>
> Any version of Access will work.
>
> Each user will need Access on their local machine, unless you plan to
> purchase the developer's edition and package the database application with a
> run-time version of Access.
>
> Do your users all have the application?
>
> How many users will you have?
>
> Are you a pretty advanced application developer?
>
> Rick B
>
>
> "sparkle_vy" < sparkle_vy@discussio
ns.microsoft.com> wrote in message
> news:AD26B899-5E84-45B8-B1C1- 87150EBF1C46@microso
ft.com...
> saved
> of
>
>
>
>
>
>
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:0306FB25-67C6-4557-8EFD- 6D347489600E@microso
ft.com...
> mine. i
> we
> use
>
>
>
| |
| Rick B 2005-04-06, 8:06 pm |
| Do you all have FULL access to the folder in which the database lives? When
one person opens a database it creates a lock file (ldb) in the folder.
When the next user opens the databse they update that file. When the last
person using the database shuts it down, they delete that lock file.
Full windows permissions to the folder are needed to perform those tasks.
Rick B
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:B7291221-BB29-47AE-B790- 2065571A0FCE@microso
ft.com...
> thanks! i got the one you forwarded from mvp too.
>
> there will be at least 10 users who will update and work on the database.
i
> was wondering why is it that when my coworker tried to open the database
> while i am also using it didn't allow her to open the database. and we're
> using ms access 2000. it's not allowing us to open/update at the same
time.
> yeah, the users have the application on their own hard drive and the
database[color=darkr
ed]
> file is saved on the server.
>
> nope, im just learning to use ms access, i know a little of c++ and that's
> it. i will need alot of tips to finish a project.
>
> thanks
>
> "Rick B" wrote:
>
with a[color=darkred]
version[color=darkre
d]
version?[color=darkred]
what[color=darkred]
message[color=darkre
d]
should i[color=darkred]
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| i don't even know how i did that. it was my first time to do this yesterday.
thanks for letting me know.
"Rick B" wrote:
> You did not post it in the multiuser newsgroup.
>
> you posted it in microsoft.public.access
>
>
> Rick B
>
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:B3E86CA6-2331-4C66-8CF6- FA98938D73CE@microso
ft.com...
> mine. i
> we
> use
>
>
>
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| every body have full access to the folder where the database is saved. how
do i do that, to activate/deactivate the full windows permission?
"Rick B" wrote:
> Do you all have FULL access to the folder in which the database lives? When
> one person opens a database it creates a lock file (ldb) in the folder.
> When the next user opens the databse they update that file. When the last
> person using the database shuts it down, they delete that lock file.
>
> Full windows permissions to the folder are needed to perform those tasks.
>
>
> Rick B
>
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:B7291221-BB29-47AE-B790- 2065571A0FCE@microso
ft.com...
> i
> time.
> database
> with a
> version
> version?
> what
> message
> should i
>
>
>
| |
| Rick B 2005-04-06, 8:06 pm |
| Your system administrator who creates the network logons should be able to
set the appropriate permissions, or tell you how.
Rick B
"sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
news:B41C68B2-05A8-47F8-9276- C5A3DF78BE8C@microso
ft.com...
> every body have full access to the folder where the database is saved.
how[color=darkred]
> do i do that, to activate/deactivate the full windows permission?
>
> "Rick B" wrote:
>
When[color=darkred]
last[color=darkred]
tasks.[color=darkred]
database.[color=darkred]
database[color=darkr
ed]
we're[color=darkred]
that's[color=darkred
]
to[color=darkred]
application[color=da
rkred]
be[color=darkred]
slow[color=darkred]
message[color=darkre
d]
your[color=darkred]
about[color=darkred]
or[color=darkred]
| |
| sparkle_vy 2005-04-06, 8:06 pm |
| i see, so access 2000 can be used and updated by multiple user, only if the
administrator changes the network logons that will allow everybody to use the
database. thanks rick!
"Rick B" wrote:
> Your system administrator who creates the network logons should be able to
> set the appropriate permissions, or tell you how.
>
> Rick B
>
> "sparkle_vy" < sparklevy@discussion
s.microsoft.com> wrote in message
> news:B41C68B2-05A8-47F8-9276- C5A3DF78BE8C@microso
ft.com...
> how
> When
> last
> tasks.
> database.
> database
> we're
> that's
> to
> application
> be
> slow
> message
> your
> about
> or
>
>
>
| |
| Larry Linson 2005-04-06, 8:06 pm |
| "sparkle_vy" wrote
> i see, so access 2000 can be used and
> updated by multiple user, only if the
> administrator changes the network logons
> that will allow everybody to use the
> database. thanks rick!
To add to Rick's very good advice, just a word of caution -- if you are
doing anything with Access 2000, make certain that you have all three
Service Packs applied, and all other updates. Even so, I'd feel more
comfortable with Access 2002 or 2003 with all Service Packs and updates.
And, covering other general topics on multiuser, there's an introductory
presentation on Access in a Multiuser Environment that I did for my user
group that you can download from http://appdevissues.tripod.com. It will
identify topics that I thought worthwhile to discuss, and a bit more. The
best collection of detailed information and links on the subject of Access
in the multiuser environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.
Larry Linson
Microsoft Access MVP
| |
| Klatuu 2005-04-06, 8:06 pm |
| Sparkle,
I think Rick B spent more time referring you to a previous post than it
would to have answered the question.
Any verison will do; however, I would recommed at least 2000. Now, there
are some issues regarding multi-users. Get a good book on Access that will
explain it in detail. The short of it is:
Once you have your application to a point where the tables and indexes are
defined, use the database splitter to create a back end database. It should
contain data and only data. All other object should be in the front end.
Put the back end mdb file on a server where all users have rights.
Distribute the front end to the users for them to put on their own PC. Be
sure to use absolute addressing in you table links since all users will not
have the same drive mappings.
Be sure you address record locking. The more users you have, the more
important this becomes. It is too involved to discuss here. Read you book.
Good Luck
"sparkle_vy" wrote:
> Hello,
>
> can somebody please explain to me what ms access version should i use for
> mutliple users? is there an ms access network ver.?
>
> i will appreciate your help. thanks!
>
> vy
|
|
|
|