Return Path of mdb file

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

How do you return the path of where the mdb file is? For
example if my desktop shortcut target is
C:\MyDocument\Inventory\dbfile01.mdb then I would like to
return this to a string when I open the database. How do
I do this function to return the path? I have tried
different things and have found that CurDir() is not the
answer.

Thank you,

Douglas
 
Douglas wrote:
--------------------
| Content-Class: urn:content-classes:message
| From: "Douglas" <[email protected]>
| Sender: "Douglas" <[email protected]>
| Subject: Return Path of mdb file
| Date: Mon, 19 Jan 2004 13:44:55 -0800
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPe1XorSeKpqaaoQuKx8+S/Dlwe8w==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.security:7601
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.security
|
| How do you return the path of where the mdb file is? For
| example if my desktop shortcut target is
| C:\MyDocument\Inventory\dbfile01.mdb then I would like to
| return this to a string when I open the database. How do
| I do this function to return the path? I have tried
| different things and have found that CurDir() is not the
| answer.
|
| Thank you,
|
| Douglas
|

Have you seen this knowledge base article:
ACC2000: How to Get the Name and Path of the Current Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;210395

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."
 
Back
Top