I'm trying to make an Access 2000 database with links to tables on a Pervasive 2000i server. The database is transfered from an old 6.15 database. So I believe that it's using the transactional engine.
I've got the directories set up in the Pervasive control center, and set up as DSNs for each directory/database.
I managed to get the Access database to attach the tables I want and I can get my results that I want. The trouble is that I would like to have multiple users accessing this database. On my workstations I set up ODBC the same as my development PC, but when I try to use the database in Access, I can't connect to the tables.
Please Help!!! I'm a newbie/rookie/andwhateverelseyouwanttocallme when it comes to databases, much less Access and Pervasive, but I'm trying to do whatever it takes.
Any recommended books to help me learn would be much appreciated.
I've got the directories set up in the Pervasive control center, and set up as DSNs for each directory/database.
I managed to get the Access database to attach the tables I want and I can get my results that I want. The trouble is that I would like to have multiple users accessing this database. On my workstations I set up ODBC the same as my development PC, but when I try to use the database in Access, I can't connect to the tables.
Please Help!!! I'm a newbie/rookie/andwhateverelseyouwanttocallme when it comes to databases, much less Access and Pervasive, but I'm trying to do whatever it takes.
Any recommended books to help me learn would be much appreciated.