Multi-member files are unique to the AS/400. They are not supported by SQL and applications like Access cannot use them. When you connect a multi-member file to Access or any other ODBC application, you can only use the first member. There is no way to change this or override it. If you are designing a new database for use with ODBC, you should avoid members. If you need to use multi-member files from an existing database, the only thing you can do is build separate logical files over each member and use these.