Ashank4vba
Programmer
Hello,
I'm trying to create a table/ use the corresponding table if it exists already in a 'sybase database' from my access application.
There is a user DSN already created in my computer which uses a 'Sybase ASE ODBC driver'. I have a couple of linked tables in my access database which use this DSN and work fine.
But when I try to 'link tables' from my access database, choose ODBC databases and select the above DSN, it prompts me with a 'Logon to Sybase' window and asks for a LoginID and password which I do not have. For this same reason, I am not able to 'test connect' from this DSN. At the same time, I dont know how the other linked tables in my database work.
Please help me out.
Thanks a lot.
-cheers
Ashank
I'm trying to create a table/ use the corresponding table if it exists already in a 'sybase database' from my access application.
There is a user DSN already created in my computer which uses a 'Sybase ASE ODBC driver'. I have a couple of linked tables in my access database which use this DSN and work fine.
But when I try to 'link tables' from my access database, choose ODBC databases and select the above DSN, it prompts me with a 'Logon to Sybase' window and asks for a LoginID and password which I do not have. For this same reason, I am not able to 'test connect' from this DSN. At the same time, I dont know how the other linked tables in my database work.
Please help me out.
Thanks a lot.
-cheers
Ashank