|
sharing backend on NAS
I'm thinking of getting a Network Attached Storage such as a Synology:
http://www.synology.com/enu/products/diskstation/DS-101g_plus/index.php?page=overview.html
to share the backend of a FE-BE database with 2-5 users.
Is this possible? How fast must the transfer rates be for it to be reliable?
I know WAN is too slow but what transfer rates are sufficient?
Jesper
...
|
4 |
09.01.2006 00:53:17 |
|
|
Free access to several paysites! Free movies - games - software - mp3 - and more!
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>I found this great site that offers loads of content for
free! I got a bunch of mp3's from it, but they offer movies, games and software
too!</P>
<P>Go check it out! Quickly!</P>
<P><A href="http://w...
|
1 |
17.01.2006 22:41:13 |
|
|
Different FE and replication
Using Acces 2003.
Different FE's: The client will be the main user of the small database
capturing sales information. He wants his sales guys to also have a copy of
the database, but essentially a 'cut down' version which will not show all
the same fields on some of the forms but will allow them to enter the data
to update the database.
1. Each salesguy should only be able to pull ...
|
3 |
16.01.2006 23:28:43 |
|
|
Slow Forms Over Network Until Compact/Repair
We just recently upgraded from Windows NT client OS to XP (I have no idea
what the network server is) and from Access 2000 to 2003. I have some
existing applications that run very very slowly when the mdb is run from a
network share, and then run fine when run from my local harddrive.
The weird thing is, when running on the network, if I perform a
Compact/Repair database by going through t...
|
4 |
16.01.2006 19:46:28 |
|
|
SQL tables
I have an access mdb with ODBC links to a SQL table on a remote server. I
can update records in the SQL table by just typing. I also wrote some
update queries using joins between local table and the SQL table. Works OK
but slow. So now I want a fast and easy way to update larger groups of
records in the SQL table based on matching records in the local table. Need
speed for this. Don;t w...
|
6 |
15.01.2006 02:47:06 |
|
|
Creating & Editing a Log File
I have a Table bound to my Main form that opens automatically (autoexec).
The table contains an Auto field, UserID, Date/Time In & Date/Time out fields.
When the user opens the database the Main form opens and a record is created
with the Auto field(Key), UserID and Date/Time In. When the user closes the
Main form to exit the application, I want to find the record and edit it to
include t...
|
3 |
13.01.2006 18:23:36 |
|
|
pop up message
I am looking for a way to have a pop up message saying that my clients are
due to pay their bill with 3 days. pls help, I am not too much familiar with
macro or any other programmation but i can catch fast if you explain to me
in details. thank you
jiji
...
|
2 |
12.01.2006 15:22:34 |
|
|
Access database record locking in VB6
How do I lock a record so that only one person at a time can make
changes but any number can view the record at the same time?
...
|
2 |
12.01.2006 12:28:40 |
|
|
Access database record locking in VB6
How do I lock a record so that only one person at a time can make
changes but any number can view the record at the same time?
...
|
1 |
11.01.2006 18:49:48 |
|
|
Word Mail-merge hangs Access and spikes CPU
Hello,
We have a multi-user Access 2003 db, with the tables and forms split.
This works fine for most things. However, when a user does a mail-merge
(from Access to Word), the Access database hangs up and the CPU
utilization spikes. The only way to free it is to reboot. All suggests
appreciated.
Thanks,
ChrisW
...
|
1 |
10.01.2006 17:28:54 |
|
|
Logoff Idle Users
Hello,
I have a MS-Access 97/2003 database, on a Windows XP system acting as a
server for the database. The database is on a Windows network.
At any given time there are 13 to 20 people connected to this database
I need to do the following:
Automatic logoff of devices/Users attached to the database, after 20
minutes of non-use.
Can ANYONE point me to some examples of this process???
...
|
3 |
08.01.2006 22:42:50 |
|
|
Multiple Users Can't Open Database on WIN2003 Server
I recently moved my Access Database from a shared folder on a workstation to
a shared folder on my new 2003 Server. Now it will only allow one user at a
time to open the database. When a second user tries to open the database they
get a "this file is already in use" error. As far as I can tell, sharing and
security are set up correctly.
Before moving it to the server it worked fine. I have ch...
|
2 |
08.01.2006 17:56:54 |
|
|
Refresh probelm with MS Access.
Hi All,
I am using MS Access in our application. We are now updating our
application for multi-user environment. While testing I found that the
changes done in one client is not reflecting in the other client
immediately.
Even when I do some changes manually in DB, and try to see
immediately through application, it is taking time to show the changes.
Is this behaviour dependent o...
|
4 |
06.01.2006 10:39:00 |
|
|
ODBC SQL table update
I have an access mdb with ODBC links to a SQL table on a remote server. I
can update records in the SQL table by just typing. I also wrote some
update queries using joins between local table and the SQL table. Works OK
but slow. So now I want a fast and easy way to update larger groups of
records in the SQL table based on matching records in the local table. Need
speed for this. Don;t w...
|
1 |
06.01.2006 02:41:11 |
|
|
access runtime error Windows XP
Hi there,
My Access client program is running in multi-user enviroment. Some user has
Windows XP with no rights to write to C:\Program Files folder.
There is no way to change user rights. (Company policy)
But the Access runtime (aka AccessRT), (what needs on machines doesn't have
Office) always want to use this folder (C:\Program Files).
I try to install AccessRT to other folder, but it do...
|
2 |
06.01.2006 00:50:48 |
|
|
"enabling" an mdb from 2000--how?
I have some co-workers with 97, some with 2000, a few with a later
version.
In an article at www.suite101.com/article.cfm/ms_office2000/118644
I saw this (last paragraph), which seemed to be just the ticket for my
situation:
"Rather than convert an earlier version Access database to Access 2000,
you may want simply to enable an Access database. This is especially
useful in a multiuser e...
|
3 |
05.01.2006 09:59:34 |
|
|
Funky Record locking problem
I have a multi user application, running on A2002 in Windows XP.
User/group security is in place. I am receiving a record locking
message which seems a bit odd. It appears when the app attempts to add
text to a memo field and save the current record. The error is 3202
"Could not save; currently locked by another user". The text,
incidentally, IS saved, despite the error message.
Now, my...
|
6 |
04.01.2006 19:17:03 |
|
|
Data Access Pages - Usable by those without Access? (Multiuser)
Hi there, I have a database I would like others to be able to input to on a
web site. If I design a data access page, but some users do not have Access
(but do have MS Office) will they be able to use this page to enter data?
Thanks...
|
2 |
04.01.2006 09:43:06 |
|
|
Subform not showing over network
Hi Guys,
I have a form with a subform that works when I run it locally, but not when
it is used over the network? Anyone any answers for this issue
TIA
...
|
2 |
03.01.2006 12:15:39 |
|
|
Back-end security without Workgroup - is this possible?
Hi there,
I develop multi user applications with front-end/back-end deployment.
Although the front-end is compiled and the back-end in a hidden folder on the
server I am concerned that a user might open it and change data (on purpose
or an accident).
I don't use the access workgroup/user security feature since I use a custom
user entry verification incl access rights feature.
The qu...
|
6 |
01.01.2006 11:27:28 |
|
|
weird and sudden speedup
Hi Access gurus,
I want to report an amazing and sudden speedup of my database, which I
cannot explain.
Split, front end and back end, about 8 MB each, in a2003, several
clients some using a2000, some using a2003. (I know, mixed versions, a
definite danger sign.) The front end is on each client's machine as an mdb
file. (I know, it should be mde, and I am working on that.)...
|
2 |
30.12.2005 19:22:02 |
|
|
MULTIPLE ACCESS DATABASE BACK-ENDS ON THE SERVER - VIRTUAL MULTIUSER
I need an opinion about the following situation:
- There is a compay which has very good administered LAN (20 nodes) with
a very strong server.
There is a need within a company that 10 to 12 persons can
simultaniously access the server and run the
separate ACCESS acountiong software.When I say separate it means that
there wlill be up to 20 separate
ACCESS data...
|
3 |
28.12.2005 06:33:02 |
|
|
Earn money Online - without risk!
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary?
Then you should take yourself a couple minutes time. You happily will be
that you ...
|
1 |
25.12.2005 01:36:16 |
|
|
Access can't find database file.
I can open the file if I do a file open within access but a short cut or
clicking within windows explorer gives me a message that the file can't be
found. It is residing on a netware 6.5 server and all users have all rights
to this folder.
Any help?...
|
1 |
23.12.2005 14:30:02 |
|
|
Performance Nightmare and Seemingly Corrupt ldb File
I have a group of people running queries off tables in multiple
versions of Access. To explain my problem I will use the following
scenario:
User running Access 2002 on his desktop to run a query based on a table
in an Access 97 database on the network.
First problem is that the ldb file that gets created for the 97
database, even when he is the only user in it, contains garbage text.
...
|
5 |
22.12.2005 20:44:41 |