Hello.
I have an Access 2000 database that links to some Oracle tables. I want to share this database on a server, but when I do, anyone else who tries to access the table gets an error that they aren't connected. all the users have the rights to view the Oracle tables, so I am not sure as to what my next steps should be. I know I could go around to everyone's machine, install the ODBC driver, and then show them how to use the link table manager to connect, but this is not really a solution.
Any ideas?
Thanks.
I have an Access 2000 database that links to some Oracle tables. I want to share this database on a server, but when I do, anyone else who tries to access the table gets an error that they aren't connected. all the users have the rights to view the Oracle tables, so I am not sure as to what my next steps should be. I know I could go around to everyone's machine, install the ODBC driver, and then show them how to use the link table manager to connect, but this is not really a solution.
Any ideas?
Thanks.