For about 12 years, we've had a FileMaker database import external data from a .mdb (Access) database that has data that is downloaded from some equipment. The process has survived several computer upgrades (Windows XP and Windows 7) and FileMaker version upgrades (created in 7 and currently running in 16). It broke when we moved into the Windows 10 environment. The script is set up to retrieve the data from the .mdb file and it says it can't access the file. So when I dive into the script and try to specify the ODBC connection it now asks for a username and password. We've never had a user name or password tied to either the .mdb file, the ODBC connection, or the FileMaker file. But no matter what we try, we can't get past this step. Is this a bug? What am I missing here?
Thanks in advance.
Apologies in advance if this is a vague question, or if it's been extensively documented, but I could do with some basic advice on moving filemaker tables to SQL. In terms of database development, I have only really known FileMaker.
We have a 60 table, 25 user FileMaker database which takes care of most if not all of the company's operations.
There is now talk of allowing other platforms (such as PowerApps/PowerBI) access to the data. One such reason is other people are interested in making apps/applets that serve specific functions. This would be simple if the data were held on a SQL database.
So if all the FileMaker tables were to be moved to SQL, what sort of a task is that in terms of keeping the existing FileMaker gui functioning?
Or. is there a simpler way to grant other platforms access to filemaker tables?
And of course, what are the downsides?
Looking for someone to help setup a simple connection to a sql database on cpanel for our Ranch to connect to cattle listings on our website.. I'll be using fmp12 server or content for now just establishing a connection via fmp12 client on windows 7 pro machines.
Specifically I am having trouble establishing a DSN connection from any of my machines and have opened ports / given access in cpanel to my static IP.
I have also updated MS ODBC drivers on one of the machines to see if that made a difference. It may be something quick for an expert with experience or it might end up being a gremlin.
I have set up some test databases for troubleshooting purposes and willing to do alot of the legwork if i'm able but also willing to pay someone for their expertise as well.
By Scott Pon
Using MS Access 2010. Filemaker 13 Pro, Filemaker 13 Server.
I have a MS Access database that that I programmed to do a lot of calculations and creates data. Now I want that data saved in a Filemaker database. I was able to create ODBC connection to the Filemaker database. I am able to view the Filemaker tables/data in MS Access.
At 8AM daily I want the Access database to do the calculations, and then insert the data to Filemaker . However every time I try this, the Filemaker Login Screen comes up. And I would have to manually enter the username and password.
Is there any way to bypass the log on screen?
Thanks in advance.
On windows 7 (VMware on OSX), using FMP17 and Microsoft Access 2016
Trying to do a ODBC import and selecting the datasource, I get asked for Username and password, even if the Access DB is not password protected.
The data sources are correct (tested from Livecode) and should be working without user name and password.
On the properties of the ODBC pane setup the path seems correct (not pointing to 32): %windir%\SysWOW64\odbcad32.exe
What am I missing?