SAPDB stored metadata as case sensitif, use SQL Studio to query metadata of
your database
table, and see how the table stored.
"USER"."table2" is different than "USER"."TABLE2"
Your error only require to analyze, whos have this table ? How the table
name stored in database, uppercase or lowercase ? to debugging grant the
table to public.
----- Original Message -----
From: "H�bschen, Peter" <[EMAIL PROTECTED]>
To: "Mailingliste SAPDB (E-Mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 2:24 PM
Subject: MS Access with SAPDB problem
> Hello,
>
> I'm using MS Access as frontend and I'm trying to use SAPDB as backend.
> Since Access is version 97 I have to use DAO+ODBC. Now I'm facing an error
> and I don't know how to solve it. I'm trying to execute a simple
> SQL-Statement through the following VB-Code (the table tbl_Teile exists
and
> is owned by the usergroup 'allusers'; user xxxx is member of allusers):
>
> Dim rs As DAO.Recordset
> Dim dbsODBC As DAO.Database
> Dim ODBCCOnnect As String
> Dim SQLString As String
> ODBCCOnnect =
> "ODBC;DSN=DEV_ANFR;SERVER=IP.Ad.re.ss;DATABASE=DEV_ANFR;UID=xxxx;PWD=xxxx"
>
> Set dbsODBC = DBEngine.OpenDatabase("DEV_ANFR", dbDriverNoPrompt,
False,
> ODBCCOnnect)
>
> SQLString = "Select * from tbl_Teile"
> Set rs = dbsODBC.OpenRecordset(SQLString)
> .....
>
> If I run this version of SQLString I get (Translated from german): The MS
> Jet-Databasemodule can't find table or query 'tbl_teile'. Are you sure
that
> it exists and the name is right.
>
> If I change SQLString to 'Select * from TBL_TEILE" I get: The MS
> Jet-Databasemodule can't find... 'ADMIN.TBL_TEILE'...
> That looked promising, so I changed in SQLString "TBL_TEILE" to
> "ALLUSERS.TBL_TEILE". And now Access is looking for a file called
> 'Allusers.mdb'.
>
> Last try was to put ALLUSERS.TBL_TEILE in simple quotes
> ('ALLUSERS.TBL_TEILE') and access gets another runtime error: "The
> Database-Module can't find "ALLUSERS.TBL_TEILE". Are you sure, that it's
an
> allowed parameter or aliasname, which contains no illegal Characters or
> wrong (Zeichensetzung) und whose name isn't to long.
>
> So please can anyone tell me what I have to do, to get access to my tables
> which are stored in SAPDB? I don't know which other options I can try.
>
> Thanks in advance
> Peter Huebschen
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
