Hello,
my problem isn't to analyze who is the owner of the table. Even if I make a
'grant all on tbl_teile to public' I get the error, that there is no table
"ADMIN.TBL_TEILE" (SQLString = ' Select * from TBL_TEILE '). So Access is
looking for a table called tbl_Teile, but under a wrong 'environment'
(ADMIN).
On creation I wrote everything in uppercase, so that should not be the error
too.
My problem is: How can I tell Access the correct "environment/path"
(ALLUSERS). If I use a dot to separate the username from the table name I
get errors too (see the last two error messages from my first mail.)
Has anyone experiences with Access as frontend (97 and/or 2000) with a
SapDB-Backend. Or are there some better ways to create a frontend?
Peter
> -----Urspr�ngliche Nachricht-----
> Von: Eko Subagio [SMTP:[EMAIL PROTECTED]
> Gesendet am: Mittwoch, 6. August 2003 10:27
> An: H�bschen, Peter; Sapdb General List
> Betreff: Re: MS Access with SAPDB problem
>
> 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
