cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Metin_Tueluemen
Metin_Tueluemen
Level III

Table Update from Access Database do not work with jmp 16

Created: Sep 29, 2022 05:41 AM  |  Last Modified: Jun 10, 2023 4:54 PM (557 views)

In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables.

 

Current Data Table() << Update From Database(
	"DSN=Test;DBQ=filelink\filelink\file.mdb",
	"SELECT * FROM [file]"
)
0 Kudos
1 REPLY 1
Craige_Hales
Super User Craige_Hales
Super User

Re: Table Update from Access Database do not work with jmp 16

Sep 30, 2022 11:14 AM (535 views)  |  Posted in reply to message from Metin_Tueluemen 09-29-2022
Check the log. What happens when it doesn't work?
Did you switch from 32 bit to 64 bit JMP? Might be a driver mismatch if so.
Tech support can definitely help, link at bottom of page.
Craige
0 Kudos