Search the Community
Showing results for tags 'MS Access'.
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 w
Longtime FM Pro user, and it's still my go-to app builder whenever I have a choice. But now I've got to put together an Access-based solution at work. Might make sense to ask these questions in an Access forum, but so far, nobody there knows FileMaker, so... A couple things I could use some help on from anyone who has used both platforms a good bit. In FM, when I want to process imported data bit but not weight the solution down w/too many calc fields, I use an auto-enter calc that adjusts the data during import. So, what's the nearest equivalent to an auto-enter calculation in MS Acc
I'm at a loss, or maybe I overt-thinked this or missed the obvious answer. I have a Filemaker 13 Database on a Filemaker Server. I also have some additional data in MS Access. A user has requested to show some MS access data on to the FM database. So I created a ODBC connection. and connected it to my test access db. Attempt #1: I created a test FM file. I started with "Import Records"-> "ODBC Data Source". I selected my Data Source. It asks for Username / PW. I get to "SQL Query Builder". BUT: when I select the table, the Columns' box does not fill in. I checked the