By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,784 Members | 1,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,784 IT Pros & Developers. It's quick & easy.

MS Access to AS400 problem..

P: n/a
Hello,

I'm still trying to get this to work.
I'm using Access tabledefs to connect to AS400. I need to refresh the
existing links to different AS400 machines (same tablenames). I need a
DSN-less ODBC connection (not ADO OLE DB) to AS400 from Access. My function
is somehting like this:

Public function ConnectMe() as string

dim db as dao.database
dim sConnect as string
set db = currentdb
sConnect = "ODBC;Driver={Client Access ODBC Driver
(32-bit)};System=MyAS400;Uid=MyID;PWD=MyPassowrd"
db.tabledefs("table1").connect = sConnect
db.tabledefs("table1").RefreshLink

End Function

When I execute this I get the error:

Reserved error (-7778); there is no message for this error.

Any suggestions???

Thank you.

Matthew Wells
MW****@FirstByte.net


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You will need to drop and recreate the tabledefs. Don't forget to set
the SourceTableName. See my comments in the thread

http://groups-beta.google.com/group/...55f783e029651c

Bill E.
Hollywood, FL

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.