|
Disk Error
A client wanted to place an MS Access 2000 database in a folder on her
C: drive and then share the folder on her c: drive out to certain users
using a local network setup. Those certain users all have Full Control
(through the shared folder). However, if more than one person attempts
to add new data to the table or to access to different forms, the
second person gets a DISK ERROR message an...
|
1 |
6/8/2006 10:32:45 PM |
|
|
Connections in ADO
Hi, I need help with setting up a 'dummy' connection. I'm developing an
application that will be used by a field of remote users eventually, I have a
parameter query setup in a class module that I want to test, however it is
looking for the connection criteria. The app is currently set up as single
user, so there is no database other than the one I am currently working in to
connect to. ...
|
4 |
6/7/2006 9:48:01 PM |
|
|
Locking records in multiuser environments
Hi.
What is the recommended way to lock files/records for an Access 2003 DB in a
multi-user environment?
If you can refer me to any documentation and samples, it would be great.
Basically I want to correctly handle updates/queries to records in my
programs for
multiuser environment.
I'm using Visual Studio .Net 2003 Pro, Visual Basic and C#.
Thank you.
...
|
7 |
6/5/2006 3:34:02 PM |
|
|
Each user with the codes or with a shortcut of the codes?
Our database is split : iftm and iftm_princip. The data (iftm_princip) are
in the server and each user has the codes (iftm).
I am thinking to put the codes (iftm) too in the server and make a shortcut
of the codes (iftm) in each user.
What would be the best?
Thank you.
...
|
3 |
6/3/2006 2:17:32 PM |
|
|
Linking table to IN-USE back-end mdb ???
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
opened for adding new records or editing?
I have run a few tests and linking see...
|
3 |
5/30/2006 6:36:01 PM |
|
|
configuration or a different problem?
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 when clicking on a
button that opens that report. The user(s) is able to open the fo...
|
4 |
5/25/2006 5:58:27 PM |
|
|
Struggling to enable more than one user
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 properties window), and confimed that the users have modify,
read, write, execute permisi...
|
6 |
5/23/2006 9:48:17 PM |
|
|
Designing an interface - need serious help
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 network.
What I'm trying to duplicate is this. <a href="http://photobucket.com"...
|
6 |
5/23/2006 7:56:01 AM |
|
|
Reliability of Access (JET) Over a LAN?
Hello,
I'm looking to build a solution. It is a simple .NET app which will use a
network shared JET database. The database will consist of a single table
with a single field containing a telephony number. There will be 26 clients
each of which will periodically query to see if a specific number is in the
table (once a minute or so.) In addition, they will periodically use Access
o...
|
13 |
5/18/2006 5:47:26 PM |
|
|
Problem withing multi user form
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
first record in the table appears to be edited instead of the record
selected. If I cl...
|
1 |
5/18/2006 12:35:41 PM |
|
|
Can't open already open MDB files
Over the weekend one of our servers was replaced. The files were
copied from the old to the new. The same drive letter, e.g. Q drive,
for mapping was used but the name of the server was changed.
Initially there were no problems for Access database users. On
Wednesday several problems began to appear.
Some users have no problems opening and sharing the same database.
Others cannot open...
|
2 |
5/18/2006 8:51:00 AM |
|
|
Split databases and ADO Cursors
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 environment (a local mdb linked to a remote mdb
on a network share).
Does a split...
|
9 |
5/18/2006 12:13:24 AM |
|
|
Recording user events
Hi There
I wonder if someone could help me please. I have a multi-user database
application and I would like to record specific events within the database,
especially the user that has initiated the event. At the moment I have a
startup form that asks for the user to enter his/her name and it is this
that I currently record against certain events. However this could be I'd
like to...
|
9 |
5/17/2006 4:25:11 AM |
|
|
Need Help with Access Reports
I am running into a very strange error while trying to rebuild my Access 97
frontend from Source Safe. It just started a couple of days ago and I have
not been able to figure out what the cause is or how to fix it. Any help
would
be greatly appreciated.
The error is output to an error.txt file on rebuld. Below is the error
Error encountered at line 74. Expected: 'End'. Found: 0x00...
|
3 |
5/16/2006 3:01:02 PM |
|
|
24
24 owns all of you punk ass motherfucckers
...
|
1 |
5/16/2006 9:52:32 AM |
|
|
IF...THEN with SQL
I'm writing a SELECT SQL statement and need to use an IF THEN statement in
the select line. I have one field that selects Point Deductions and I want
to create another field that says "IF Point Deduction is > 26, then PRINT
"Fail" ELSE PRINT "PASS". I know its possible to have IF...THEN statements
in a SELECT query, I just can't figure out the syntax....
|
3 |
5/15/2006 11:50:02 AM |
|
|
Windows Installer appears ALL the time.
I have no idea what Discussion Group to post this under, but since I'm an
Access Developer I figured I'd start here. I'm new to this.
After un-installing Visio 2003 from my PC the Windows Installer dialog now
appears every time I start a new application. The Windows Installer Dialog
does nothing but hang up my machine and thus I must cancel it three times
before my application loads.
...
|
4 |
5/15/2006 1:40:03 AM |
|
|
database locked - but no users!
Hi Again,
Don't know if you can help with this but here goes. I've got an Access 2000
database that several users access. What I'm trying to do is to amend one
of its reports but it won't let as it says i don't have exclusive access to
the database. The thing is, I know for sure that no-one else is in it (i've
checked every computer on our network). I've tried to delete the ldb file ...
|
3 |
5/10/2006 11:57:43 PM |
|
|
Cant share a database?
I cant share a database with another user - the database is split and both
ends are in the one network folder
Both users have windows read/write permission on the folder and both parts
(front & back) of the database are set to share (left at default)
but when one user opens the front end the other user it locks the other user
out
any thoughts?
...
|
11 |
5/6/2006 12:39:01 AM |
|
|
unrecognized database format
I recently split my Access 2000 database in order to make it easier to
use in a multiuser setting, but one day after I did so, my users (who
number only 5) began getting an "unrecognized database format error",
because the backend had become corrupt.
Each user is running a local frontend that connects to a backend MDB
that resides on a Win 2003 server.
I've restored the database from a cop...
|
1 |
5/5/2006 1:24:06 PM |
|
|
Protection
1st I want to thankyou for all the help. I have a computer that 3 different
people use. When I log on I can use my data base to update and export data to
excel. when the other 2 people log on they can updat the data base but they
can't export the data to excel. Is there any way to take all the protection
off this data base so that anyone can import or export data?
--
Arthur Bourgeois Jr
...
|
2 |
5/4/2006 9:59:48 AM |
|
|
Getting message "Could not update, currently locked"
I have a database that uses several tables. Two tables, based on a
parent/child relationship, is set up in one form. This has been in
production for about one year with multiple users.
Today the user's received a message "Could not update, currently locked".
This message is produced as a user tries to add a new child record. Editting
of an existing child records is no problem. This...
|
1 |
5/3/2006 5:36:02 PM |
|
|
mde queries
I have 2 questions concerned to deployment
1. Can I supress the "Security Warning" dialog box when I open an MDE file.I
want my first form (Login form) to be opened directly when ever I open the
exe file.(I selected Display Form/Page as login form (frmLogin) in Tools -
Start up option)
2.Can I supress the default menu while making an MDE file. I don't want any
menu bar,neither do I w...
|
2 |
5/2/2006 7:38:26 PM |
|
|
Unrecognized database format ? No solution, data lost!!
Hi,
I have a multi-user database file, which was being used by 30+ users at
anytime for about 6 months, and it has now got corrupted possibly..I
have tried all possible options, to compact, repair, tried to open it a
thousand times, cant even import.
Could someone please help, how i can retrieve the data?
Cheers
Sunny
...
|
7 |
4/28/2006 2:47:27 PM |
|
|
Filtering in a form
I have a form which displays user comments. On the Load event, I apply a
filter in VBA using the following code:
''''''''''''''''''''''''
Me.Filter = "StudentID = " & Me.StudentID & " AND PracticalIDNumber = " &
Me.PracticalIDNumber & " AND PractCatID = " & Me.PractCATID & " AND
InstGrader = " & Me.InstGrader & " AND UODeduction > 0 AND UOComments is null"
Me.FilterOn = True
''''''...
|
3 |
4/28/2006 2:04:02 PM |