After experiencing the common problems with access and multiple users I have decided to look for a new solution. What I am trying to do is create a Teradata back end for my existing Access DB. I've gotten as far as creating a table modeled from the back end .mdb table it currently uses. Is there a relatively simple way to set up an odbc connection that will allow multiple users to use the front-end of the database to add/delete/manipulate the data on the Teradata server? I am a bit familiar with setting up a SQL pass through that simply appends data from the server, but I want it to be live.
Thanks for any help/advice you can give!