SQL tables
Tue, 10 Jan 2006 11:37:23 -0500
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 SQ ...
|
How to Identifier Users
Mon, 9 Jan 2006 11:19:02 -0800
I have a shared db on the network. How can I determine if anyone is in the
db, and their Network ID. When I need to perform maintenance on the db, I
want to make sure that noone is in it. And if someone is it, I need to
identify who they are so that I can contact them.
Thanks ...
|
Multiple Users Can't Open Database on WIN2003 Server
Sun, 08 Jan 2006 17:04:21 GMT
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
sec ...
|
Logoff Idle Users
Sat, 7 Jan 2006 22:13:32 -0800
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 ...
|
ODBC SQL table update
Thu, 5 Jan 2006 21:41:11 -0500
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 SQ ...
|
access runtime error Windows XP
Thu, 5 Jan 2006 03:40:02 -0800
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 ...
|
Refresh probelm with MS Access.
5 Jan 2006 01:09:47 -0800
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 ...
|
|
|
"enabling" an mdb from 2000--how?
05 Jan 2006 04:28:08 GMT
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 ...
|
VB 5 Program trying to utilize Record Locking (.LDB) with MS Access
Tue, 3 Jan 2006 21:33:36 -0500
I have a program that was developed originally for single-user use and we
are now trying to modify it to allow multi-user. We need to be able to
perform record locking, and everything that we have read would indicate that
the .LDB file will take care of that automatically (with the proper
parameters set f ...
|
Data Access Pages - Usable by those without Access? (Multiuser)
Tue, 3 Jan 2006 08:05:01 -0800
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 ...
|
