Hi Mike,
Use an operating system tool, such as the Microsoft Windows 98 or Microsoft
Windows Millennium (Me) NetWatcher utility, the Microsoft Windows NT 4.0
Server Manager, or the Microsoft Windows 2000 Computer Management utility.
Also see: HOW TO: Determine Who Is Logged onto a Database by Using
Microsoft Jet UserRoster in Access 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;285822
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| From: "Mike Thomas" <
[email protected]>
| Newsgroups: microsoft.public.access.setupconfig
| Subject: One User Lacks Permission to Open mdb
| Lines: 24
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <vLtTb.35863$P%
[email protected]>
| NNTP-Posting-Host: 68.72.58.110
| X-Complaints-To: (e-mail address removed)
| X-Trace: newssvr28.news.prodigy.com 1075734619 ST000 68.72.58.110 (Mon,
02 Feb 2004 10:10:19 EST)
| NNTP-Posting-Date: Mon, 02 Feb 2004 10:10:19 EST
| Organization: SBC
http://yahoo.sbc.com
| X-UserInfo1:
[[O]R\CF\ZTWRV@YOBCBNWX@RJ_XPDLMN@GZ_GYO^ZUDUWYAKVUOPCW[ML\JXUCKVFDYZKBMSFX^OMSAFNTINTDDMVW[X\THOPXZRVOCJTUTPC\_JSBVX\KAOTBAJBVMZTYAKMNLDI_MFDSSOLXINH__
FS^\WQGHGI^C@E[A_CF\AQLDQ\BTMPLDFNVUQ_VM
| Date: Mon, 02 Feb 2004 15:10:19 GMT
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfeed.esat.net!fr.ip.ndsoftware.net!newshostingcom!news-xfer1.atl.newshosting.com!diablo.voicenet.com!prodigy.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newss
vr28.news.prodigy.com.POSTED!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.setupconfig:28918
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| In Access 2000 running on Windows NT / Citrix, i have one user, the boss,
| who receives the following error whenever he tries to open an application
| via a batch file. Everybody else, who in fact has lower levels of
permission
| as far at NT is concerned, can run this with npo problem. I do not think
it
| is opened exclusively by someone else, because everybody else can run it.
| In fact, the app runs itself, staying open for a minute or two, then shuts
| itself down.
|
| Here is the error.
|
| Run time error '3051'
|
| The Microsoft Jet database engine cannot open the file
| 'D:\Apps\CMS\CMSData.mdb'. It is already opened
| exclusively by another user or you need permission to view its data.
|
| I suspect somehow Access itself is making this determination. Is there a
| way to check this?
|
| Many thanks,
| Mike Thomas
|
|
|
|
