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

I am trying to run a copy on my computer but I am still having the same problem.  I am enclousing some screenshots maybe this might help.  http://i292.photobucket.com/albums/mm16/racolunga/SesameServer.jpg,http://i292.photobucket.com/albums/mm16/racolunga/SesameODBC.jpg,http://i292.photobucket.com/albums/mm16/racolunga/SelectDataSource.jpg ,and http://i292.photobucket.com/albums/mm16/racolunga/NoTables.jpg.  I cannot figure it out.  Are you sure Access 2000 can create tables from Sesame.  Thank you for the tip on Photobucket.   I hope you get the screenshots.

Thanks Ray,

You have solved my problem I am now able to get sesame tables into Access.  I notice that I am unable to open my Sesame client app with Access open.  My office has a server that can runs six clients I assume that Sesame identifies Access as a client.  Will I be able to run five Sesame clients and Access at the same time and if so do I need to load Access first and then load up the Sesame clients?

Glad to hear you got the ODBC working.

You can also imbed those images into the forum vs, just a link.

Here is the first of your links, surrounded with the "img" tags and centered.

Thank you all this is a great forum and very helpful.

The ODBC path and the Sesame Server path must be identical.

Does your startup for Sesame Server have the same path using Drive G?

Or have you tried using UNC in the ODBC definition vs. Drive G?

The path to the Sesame server is C:\Sesame\Program\sesame.exe -server ntserver:20020:20021 and on this same computer, the database is on the G drive.  My question to you is on the ODBC path, how do I include both the path to the server and the path to the database.  In the ODBC data source I was using Database = G:\Sesame\Data\Orders2.db and Host = ntsever and Port = 20020:20021 but does not work.
The UNC name is \\ntserver\g so should I use under Database = \\ntserver\g\Sesame\Data\Orders2.db.
Thanks

Hello!

Wie are running the Sesame server on a stand-alone server that is running Windows NT Server 2003
I have the latest Sesame ODBC files and use Crystal Reports to access on Sesame databases.
It works extremely well. But when I try to access on the Form "invoice" (the other Forms in the same Application are OK!)
i get the following message:
Database-Connector - Error: "2203:[lantica, Inc.][Sesame ODBC Driver] out of range [Datenbankanbietercode: 1011]"

please what does this message?

Thank you for any support.

Hello Amor,

Do you have Microsoft Excel or Word installed on the same computer?
If you do, could you let me know what version it is?

I am going to have you use Excel to also test the ODBC connection to Sesame.

-Ray

In Excel 2007
Start a New Workbook
Click the Data Tab
Click From Other Sources
From the Drop Down, Click "From Microsoft Query"
Choose the same ODBC link that you were choosing from Crystal Reports

Can Microsoft Query show the fields from the Invoice Database?

-Ray