Sesame does have a read only ODBC driver, meaning that you can use Access to read Sesame information, but not to add or alter it.

If you describe what you need to do in more detail, we can probably offer better suggestions.

As Erica noted, you can create an ODBC connection to Sesame and then have Access use the ODBC connection as its data source.  Make a query in Access that reads the ODBC data source.  And use that Query as a source for making other queries for forms and reports.

Can only read info from Sesame,
Changes made to the data in Access will not be changed in Sesame.

These instructions are from memory, no access to Sesame right now.

Be sure you have the latest ODBC from Sesame.
Extract the files from the ODBC Zip file, and install using setup.exe.  You can create the ODBC connections here or proceed as shown next.

On XP PRO, using SesameSeasons as a sample .....
Start/Control Panel/Administrative Tools/Data Sources ODBC
Tab for User DSN / Add opens a window to Create a New Data Source
Select Sesame ODBC. Finish opens a window for Setup
Data Source = User Friendly Intelligent Name for Data Source (Sesame2SeasonsTest)
Database = Full path to Sesame database. (C:\Sesame2\Data\Samples\SesameSeasons.db)
Host  = Name of computer where database resides  (Computer Name)
Port = Port where database can be accessed (Use defaults 20000:20001)

Save results.
Create a new ODBC for each Sesame FileName.db that you want to use as a source
---------------------------------
Start Sesame Server with the same connection information as defined above with the Host and Port information.
This is critical.  You must be running a server to make the connection happen.
---------------------------------
Now, in Access, open your database, then proceed:
File/Get External Data/Link Tables/
Window opens, Change File Type at bottom of window to ODBC.
Window opens, use Tab for Machine Data Source
Select the Sesame ODBC that you want to use.

Now select the database "tables" that you want to use. These will be the Sesame databases.  You can select them all.  Now you can make your queries from these tables.  You will see that these have a different icon from your normal tables.  You may have problems with sub tables, you will get an error message saying that the  table is not valid.

I use a naming convention in Sesame where my databases are named tblName and the forms are named frmName.  This makes it good when using an ODBC link to  Access so my "tables" have the same naming convention that I use in Access or any other databases that I am working with.  I also name my FIELDS with a prefix like str, dat, tim, num, etc. to show the data type that is coming into the Access application.  I do not include the prefix on the ELEMENT names.

Once the ODBC connection has been defined it can be used as a datasource in any other application that uses data sources, like Access, Word, Open Office, FoxPro, Excel, etc.

You can find the latest files here (you will need to log in): http://www.lantica.com/Support/downloads.html

But, it appears that you may have the latest driver for version 1.x, it is named Sesame_v1.0.2_ODBC.zip

Thank you, if I am running the correct version of ODBC do you have any suggestions why Access can not populate any tables from Sesame the list is blank.  I am running both the Sesame client and the Sesame server on the same computer.  Do I need to run the Sesame server on a different computer?  I will double check my sever setting to the ODBC settings put it appears to be fine the Sesame client is working. There is a long pause when I link up Access to Sesame and a window appears with options to add tables but the window is blank. 

Bob Hansen,

Thank you for the offer to link up but I am no longer at my office just following up at home. But yes I do get a window to add tables but the window is blank.
The ODBC  connection Database= (C:\Sesame\Data\Orders.db), Host= warehouse

I am running XP and Access 2000.  I have a program called TracerPlus that is connected to an Access database via ODBC.  The program installed the connection for me.  How can I add screenshots to this post?  I know how to add a screenshot to word just hit the print screen button open word use Ctrl V to past the picture.  I am unable to use the same process on this post.

Thanks

RAC