It sounds like you are trying to open the table "C:\clients.mdb" from
the Micro$oft access database C:\clients.mdb.
>>> sfileName = FileOpenDlg("","","","Open Table")
This returns the directory structure as well as the file name
>>> Register Table sfileName Type "Access" Table sfilename Into stableName
Becomes
Register Table "C:\clients.mdb" Type "Access" Table "C:\clients.mdb"
Into stableName
A MDB file may contain multiple tables. I assume that the table you
want open in the database has the same name as the MDB file??? If so
then try the following line of code instead.
Register Table sfileName Type "Access" Table
Left$(PathToFileName$(sfileName),Len(PathToFileName$(sfileName))-4)
Into stableName
On Thu, 17 Mar 2005 18:28:19 -0000, Lu�s Marcos <[EMAIL PROTECTED]> wrote:
> Hello,
>
> i'm trying to register a table ms access with mapbasic, but i'm having a
> problem:
>
> "Microsoft Access Error: The Microsoft Jet database engine could not find
> the object 'C:\clients.mdb'. Make sure the object exists and that you spell
> its name and path name correctly. Unable to prepare .TAB."
>
> I'm using the following code:
>
> Dim sfileName, stableName, s_tab As String,
>
> sfileName = FileOpenDlg("","","","Open Table")
>
> Register Table sfileName Type "Access" Table sfilename Into stableName
>
> Open Table stableName
>
> Any sugestions?
>
> Many Thanks
>
> Lu�s Marcos
>
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15708
