First question is there a way to tell who is logged into a database on
a server?
I did some checking and found several things at MS support for access
2007, log in run some code and get a list.
The problem is all of these databases are access 97 and 2003
The databases are not set for exclusive access, the problem comes when
we have to make a change and someone left it on their desktop and
forgot to log out.
second question I sometimes use Dlookup, and after reading about its
problems I went with Elookup by Browne.
I did this the other day without thinking and wanted to ask if its ok
to do it.
If Not IsNull(DLookup( StudyID, "tblObservation ", "StudyID = " &
Me.StudyID & " And " & "[Q6PrePost] = """ & Me!Q6PrePost.Co lumn(1) &
"""")) Then
I was not thinking about multi statements and neither D or E lookup
say anything about AND/OR and since it works I was thinking its ok.
IS this ok and will not cause any problems?
thanks for any ideas help or flames 2 1628
sparks wrote:
First question is there a way to tell who is logged into a database on
a server?
I did some checking and found several things at MS support for access
2007, log in run some code and get a list.
The problem is all of these databases are access 97 and 2003
The databases are not set for exclusive access, the problem comes when
we have to make a change and someone left it on their desktop and
forgot to log out.
You can check out http://www.mvps.org/access/general/gen0034.htm. Check
out UserRoster part for your version.
There was a recent exchange at http://groups.google.com/group/comp....ea7f0789ec0f66
Check out Ron Paii's function.
I should think the data for versions above A97 would work in your
environment.
>
second question I sometimes use Dlookup, and after reading about its
problems I went with Elookup by Browne.
I did this the other day without thinking and wanted to ask if its ok
to do it.
If Not IsNull(DLookup( StudyID, "tblObservation ", "StudyID = " &
Me.StudyID & " And " & "[Q6PrePost] = """ & Me!Q6PrePost.Co lumn(1) &
"""")) Then
I was not thinking about multi statements and neither D or E lookup
say anything about AND/OR and since it works I was thinking its ok.
IS this ok and will not cause any problems?
thanks for any ideas help or flames
You could create a query and run some D/E lookups of the same thing in
the debug window. Do they return the same values?
Lookups work on 1 table/query. Since you are simply creating a filter
there's no reason why you can't and and or to your hearts content. Just
remember to use () to create your logicals.
thanks for the info I believe I can make this work the way I want.
Since you are simply creating a filter there's no reason why you can't
and and or to your hearts content.
It worked but I wanted to ask before I got too cocky with it.
On Mon, 20 Aug 2007 09:23:51 -0700, Salad <oi*@vinegar.co mwrote:
>sparks wrote:
>First question is there a way to tell who is logged into a database on a server? I did some checking and found several things at MS support for access 2007, log in run some code and get a list. The problem is all of these databases are access 97 and 2003 The databases are not set for exclusive access, the problem comes when we have to make a change and someone left it on their desktop and forgot to log out.
You can check out http://www.mvps.org/access/general/gen0034.htm. Check out UserRoster part for your version.
There was a recent exchange at http://groups.google.com/group/comp....ea7f0789ec0f66 Check out Ron Paii's function.
I should think the data for versions above A97 would work in your environment.
>>
second question I sometimes use Dlookup, and after reading about its problems I went with Elookup by Browne. I did this the other day without thinking and wanted to ask if its ok to do it.
If Not IsNull(DLookup( StudyID, "tblObservation ", "StudyID = " & Me.StudyID & " And " & "[Q6PrePost] = """ & Me!Q6PrePost.Co lumn(1) & """")) Then
I was not thinking about multi statements and neither D or E lookup say anything about AND/OR and since it works I was thinking its ok.
IS this ok and will not cause any problems?
thanks for any ideas help or flames
You could create a query and run some D/E lookups of the same thing in the debug window. Do they return the same values?
Lookups work on 1 table/query. Since you are simply creating a filter there's no reason why you can't and and or to your hearts content. Just remember to use () to create your logicals.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Robert M |
last post by:
Hello,
I actually have a couple of questions regarding this project.
First, I have a pretty good understanding of SQL code. I use to work
with dBase III and IV. I now work with Access 97 and 2000 and can do
simple Query designs.
I have a text file that is about 915mb and consists of records that
are fixed in length of 331 characters. There are no records
|
by: DFS |
last post by:
If you're listening, I want the middle of the calendar (showing 1 month) to
open below the cursor position. It currently opens just to the right and
below the cursor position.
I hunted through the code, but can't determine what to alter.
Very nice piece of work, by the way.
Thanks
|
by: Steve Wagner |
last post by:
This is kind of lengthy as I wanted to include as much relevant
information as possible. This problem has me dead in the water and
clients waiting, any help is extremely appreciated!
Configuration Details
Web Server:
* Window 2000 Server, SP4
|
by: MP |
last post by:
I'm interested to learn how to use mdb files via ado/adox via vb6
Since I'm not using Access are those types of questions o.t. here?
I see very few ado questions here. But there's a lot more traffic here than
the ado groups.
:-)
Thanks
Mark
|
by: Paul H |
last post by:
I am developing a simple database (a list of names and addresses), no
reports, but a requirement to integrate with word for a simple mail merge.
10 users, no one has access, all Windows XP machines
Questions:
1. I want to use the runtime version of Access, which version of the runtime
should I use?
1a. I want to make the installation as easy as possible for the users, so to
| |
by: David |
last post by:
Hi,
Has anyone had this problem ?
I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11
standard log.
I created my tables in MS Access, then exported them via ODBC to an
externally hosted MySQL database (fasthosts) . I then import-linked
|
by: Jeff |
last post by:
Hey
IDE: VS .NET 2005
#1
I want to start developing web parts in visual studio 2005 and are wondering
where is the latest version of the web part templates. I did find this
download (the link below), but the file is from 2004 and I don't think the
file is meant to be used in visual studio 2005.... (2 years old) There must
be something newer I must download and install instead... I'm not sure what
|
by: Adam |
last post by:
I'm having some trouble getting a Page to work the way I want it to in
Access 2003. I'm trying to do some simple internal tracking at my
office for a specific item that we sell. Each item has a serial
number, so I created two tables. Here's the structure:
Table Name: T_ITEM
Primary Key: SERIAL_NUMBER
Other fileds: CLIENT_ID, DEPLOY_DATE, COMMENTS
|
by: Lysander |
last post by:
I'm sure there is a very simple answer to this, but I can't work it out. In my new contract I am running Access 2003 on Windows XP and whenever I open a dbs I get asked two security questions.
1st is 'Security Warning, Unsafe Expressions not blocked"
2nd is 'Opening mydbs.mdb, this file may not be safe blah blah blah'
How do I turn these warnings off, I cant find any option to do so?
TIA
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |