Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 30th, 2007, 03:41 PM
Registered User
 
Join Date: Nov 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Access Functions

I am writing an application to import a series of Excel spreadsheets into Access (2003) and need some file access functions. I found the following which works fine.

Declare Function adh_accOfficeGetFileName Lib "msaccess.exe" _
 Alias "#56" (gfni As adh_accOfficeGetFileNameInfo, ByVal fOpen As Integer) As Long

In the same place I found the following, which doesn't work:

Declare Sub adh_accSplitPath Lib "msaccess.exe" Alias "#59" _
 (ByVal strPath As String, ByVal strDrive As String, _
 ByVal strDir As String, ByVal strFName As String, ByVal strExt As String)

(I have omitted the rest of the code to keep it simple)

When I execute the adh_accSplitPath subroutine it complains that it can't find entry point #59. The code was intended for Access 97 and I am using Access 2003, so I assume the library has changed.

Where can I find a list of these functions for Access 2003?

Does anyone know the alias for this function in Access 2003?

Is there a more portable way of doing it?

Thanks

Charlie





Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the format of MS Excel Cells from MS Access hewstone999 Access VBA 0 March 7th, 2008 07:19 AM
Convert Ms Access report to MS Word doc kite Access 1 October 22nd, 2007 01:45 AM
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
MS Data Grid control in ms access application roshla_p Access VBA 5 October 16th, 2006 02:37 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.