Multiple Users at Once

A

Amy

Is there a way to have more than one preson entering data
into a table or a form at once? I need a report to have
information from 6 different people and they all will try
and enter stuff at the last minute.

Thanks,
Amy
 
P

Pavel Romashkin

Amy,

This is accomplished using a split design, where your data resides on a
network share and each user has the "front end" - the part of your
application that usually has no data, only forms, reports etc that
connects to the data file on the network.
Six simultaneous users is about as far as I would push a split design
Access db. Any more and I would upsize to MSDE (a mini SQL server).

Pavel
 
A

Amy

I replicated the file and then did a database split. It
told me it worked, but I am the only one who can open it.
Anyone else gets this "Unrecognized database format ....."
where is then lists the shared file name. Any clue what I
messed up? I am trying to figure out how to make
them "Front end" users.

Thanks,
Amy
 
J

Jasmine2345

-----Original Message-----
Is there a way to have more than one preson entering data
into a table or a form at once? I need a report to have
information from 6 different people and they all will try
and enter stuff at the last minute.

Thanks,
Amy
.
Split your database. You can use the data base splitter
Click to expand...
under tool/database utilites. The wizard will put your
table into a backend database that will be name something
like amy_be Make sure the backend database is stored on a
shared drive or someplace that everyone can get to. Then
take your front end DB "amy" and install that on each work
station Make sure that you refresh your links using the
linked table manager found in tool/database utilites That
should allow you to have multiple people entering data at
the same time. I've used it here and it works just fine.
 
P

Pavel Romashkin

I think the others may not have the links fixed. The split design
maintains the links to what used to be data tables, and now became
"linked tables". If you give the front end to others, the absolute path
to the back end with the tables will become invalid. You should fix this
using the linked table manager in Tools.
Alternatively, I think that you can use the manager on your original
front end before giving it to others and instead of choosing the actual
drive (C:\Myfolder\MyBackEnd.mdb) use a fully qualified network path
called UNC (like \\AmyPC\BeFolder\ MyBackEnd.mdb). This sort of address
will be valid on any computer on your LAN, so when you give the users
the front end database to put on their desktops, these FEs will find the
back end immediately.

Pavel
 
T

Tony Toews

Amy said:
I replicated the file and then did a database split.
Click to expand...

In this situation there was no need to replicate the file. You only
need one BE MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Tony Toews

Pavel Romashkin said:
Six simultaneous users is about as far as I would push a split design
Access db.
Click to expand...

I have a client happily running 25 users on MS Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Tony Toews

Amy said:
I replicated the file
Click to expand...

See ACC2000: How to Make a Replicated Database a Regular Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;208394&Product=acc

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp.htm for more info. See
the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
A

Amy

-----Original Message-----

under tool/database utilites. The wizard will put your
table into a backend database that will be name something
like amy_be Make sure the backend database is stored on a
shared drive or someplace that everyone can get to. Then
take your front end DB "amy" and install that on each work
station Make sure that you refresh your links using the
linked table manager found in tool/database utilites That
should allow you to have multiple people entering data at
the same time. I've used it here and it works just fine.
.
Click to expand...


Got them to link, but can't open the file on other
computers on the network. They are mdb files. Any idea.
They say that they are "unrecognized." It may be that I
need a UNC path like everyone has been mentioning, but I
don't know how to set that up.

Thanks,
Amy
 
A

Amy

Got them to link, but can't open the file on other
computers on the network. They are mdb files. Any idea.
They say that they are "unrecognized." It may be that I
need a UNC path like everyone has been mentioning, but I
don't know how to set that up.

Thanks,
Amy
 
R

Rick Brandt

Amy said:
Got them to link, but can't open the file on other
computers on the network. They are mdb files. Any idea.
They say that they are "unrecognized." It may be that I
need a UNC path like everyone has been mentioning, but I
don't know how to set that up.
Click to expand...

Do they have the same version of Access as you? That error often means you are
attempting to open a file in a newer version than what you have installed.
 
T

turhan masat

merhaba
haber iletisinde sunlari said:
Got them to link, but can't open the file on other
computers on the network. They are mdb files. Any idea.
They say that they are "unrecognized." It may be that I
need a UNC path like everyone has been mentioning, but I
don't know how to set that up.

Thanks,
Amy
Click to expand...
 
H

Harlan

Joe,
If the tables are already linked to one be and you want to relink them to
another one, using the Linked Table Manager, put the absolute address in the
FILE NAME box..... don't forget to use the actual file name
also....something like this: \\MyServerName\MyFolderName\MyDB.mdb.

If your FE isn't linked yet to any tables, use the FILE, GET EXTERNAL DATA,
LINK TABLES way and put the absolute address in the FILE NAME box....

HTH
Harlan
 
Top