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
