By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,840 Members | 1,754 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,840 IT Pros & Developers. It's quick & easy.

2 questions for access 2003

P: n/a
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.Column(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

Aug 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.Column(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.
Aug 20 '07 #2

P: n/a
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.comwrote:
>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.Column(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.
Aug 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.