Linking table to IN-USE back-end mdb ???
Tue, 30 May 2006 13:54:52 -0400
Hello All:
I have a multi-user app with back-end, front -end using AC2002 runtime.
I have code that checks on startup and if needed relinks tables.
What are the issues with linking to a back-end that has other users
connected?
Will linking fail if another connected user has the table being linked ...
|
...a state that prevents it from being opened or locked...
24 May 2006 11:05:31 -0700
Hello,
We have a database on a network drive used by 6 people. At the moment,
when anyone tries to open it, they receive the error message:
"The database has been placed in a state by 'Admin' on machine
'<computername>' that prevents it from being opened or locked."
Here's the quandry. The person who wo ...
|
configuration or a different problem?
Wed, 24 May 2006 15:47:58 GMT
To Access Heros,
I deployed my new database this week complete with Access security, with the
assistance of this user group.
My problem is this:
I assigned permissions in Access by group and not users. However, some of
the users are having problems.
1) The user gets a "Report Action Cancelled" message w ...
|
multiple users writing records to the same table at the same time
Wed, 24 May 2006 12:54:42 +0100
Hi,
I am working as part of a team which has an Access 2003 application, whereby
3 or 4 users could be simultaneously running processes which write large
numbers of records to a single log table. Because of the nature of the
process, each record is written individually in VBA, rather than using a SQL
tr ...
|
Earn up to 1000 $ per month only for reading your Mails!!!!!!!!
Tue, 23 May 2006 16:39:21 +0200
...
|
Struggling to enable more than one user
Sun, 21 May 2006 19:25:56 +0100
Hi,
I've been struggling to get a db usable by more then one person. My last
post on another Access ng is as follows: Does the database really have to be
split? I only want two users to have simultaneous use. This is what I have
done so far:
- Checked security settings on the folder (2nd tab in
the prope ...
|
Designing an interface - need serious help
18 May 2006 14:52:13 -0700
Greetings all. I've been asked by the engineering department at my
place of work to redesign a database used to store information about
schematics drawn over the past 60 years. I've created a table of
approximately 17,700 records, including stored file paths to the
scanned versions of the drawings here on our ...
|
|
|
Problem withing multi user form
Thu, 18 May 2006 07:35:41 -0500
I have a spit mulituser database. Two workstations, if one station enters a
call and puts in a start time it should appear on both stations and it does.
My problem is if the second station tries to close the call (buy entering
stop time), they select the record in the list box to be edited and the very
fir ...
|
Split Databases - Best Practices?
16 May 2006 12:43:32 -0700
I'm starting this thread to pull together related questions and to
check my understanding. Please debate apparent misconceptions.
Do you agree that these are best practices?
1. Use JET OLE DB when connecting to BackEnd (BE) MDB file. Reason -
thread safety.
a. ODBC Table Links should be updated usin ...
|
Split databases and ADO Cursors
16 May 2006 10:05:10 -0700
I've read that OLE DB is the best connection technology when working on
a slow/unstable network because it is thread safe. I've also read that
only ADO supports OLE DB, so I'm limiting myself to JET OLE DB and ADO.
I'm having trouble understanding which cursors to use when developing
for a split/file server ...
|
