marija

Apparently, there is a problem with some drivers installed by dell on windows 2000 machines. I am creating a widely-distributed run-time CD, so will not have control over my users. The suggestions I've seen has been to turn off the audio program or uninstall sound driver...etc. I noticed that the tech article says that 5.5 has the problems, too. Is this true? I saw a post on here that says 5.5 fixed the prob... Also, would I need to upgrade the developer software? Thanks much for your input!

Okay my FileMaker friends--I'm willing to listen to the anti-repeating fields answers I will get, but I must ask this question. Is there a way to import repeating fields from a text file? The file contains two fields: member_number and designation. I may have more than one designation for a member. The twist, and why I don't want to use related files if at all possible, is that I'm creating a run-time CD. It's taking forever for FM to open all the related files, just to display one field from each file. I have 5 or so different files that I would like to experiment with making repeating fields and see if that speeds up opening the files. Also, I'm thinking it would be a total pain to try to combine all the files into one related file, but may be able to do that as a last resort. BTW, I'm using FMP5 Any input would be helpful, including any other ideas about how to speed up opening of related files... THANKS! [ December 12, 2001: Message edited by: mr ]

Yes, I guess telling you why might inspire some other options! Sorry. I'm creating a run-time CD. I determined that images should not be imported, but referenced because they make the db huge and make the forms load very slowly (I have images as my backgrounds in some cases). The images, of course, are kept on the CD. When I did the references, the db size decreased and it ran quickly. This CD is cross-platform. Mac side works fine. I am concerned about when a user's CD drive is set to a different letter, the images do not display. I referenced the images to the E drive, just because that's what my development machine is set to. One person suggested that I have multiple copies of the database on the CD, each referencing a different CD-drive, and at least I'll hit the most common configurations. I would prefer not to have to do this... I WELCOME any suggestions!!! Thanks.

Anybody ever come across a solution for this?

Hmm. I wonder if you could do a "Find" in a script that runs when the user opens the database. You can use the groups/users to set up passwords. When a user logs in under a certain group, you can use the Status(CurrentGroups) function in a script to determine the user, then run a find based on that. You can restrict layouts using the built-in security functions. You would just have to make it so the user can't activate the "Show All Records" command, which I don't know how to do offhand, but wouldn't say it can't be done! Hope this helps.

If you are trying to pass privileges from one db to another, you don't need the global password field. You just need to create the same users/passwords in the contents db (using built-in feature). Then if a user logs into one database, their user id and password is automatically used for any databases that the original one might call. Does that make sense?

Thanks--this worked wonderfully!

Oops, I think I'm just elaborating on what jfmcel is saying... But I know for sure you can actually IMPORT the file this way thru applescript.

You can batch import (not reference only) files into filemaker using an applescript that calls a fm script to import. Of course, since you can only refer to one file in the fm script, the applescript must go through a process of copying and renaming the files. For example, say you have a folder of images: Create a script in FM to import say, "dummy.jpg". You then have applescript cycle through the original folder, delete the old "dummy" file, copy the next pic in the cycle to another location, and rename it dummy. Keep looping through til end of images.

I hear ya. To understand better, what are your reasons for not wanting to have all of the large images as individual records (rather than a global)?

Can anyone tell me if there is a function in FM or plug-in to get the drive letter of the CD-ROM drive in windows? thank you!

You may want to try using the "Modify Last Find" command.

Well, here's what I did and it seems to be working well. First of all, I used Troi's excellent File Plug-in to import references to the images, BUT I imported them through windows. I just thought, on a lark, to import through windows and see how Mac handles them. So far, so good! I just imported the reference on windows and Mac handles them well. As for the path, and the need to burn everything to a CD, I wrote the images only to a CD, being careful to name the path exactly the same as it will be on the final CD. When I wrote the final CD, I used the same path and included my run-time files. And so it works.

I tried out the Troi File plug-in, using the TrFile-ReferenceToClip command. My understanding is that this should only store a reference to the file; however, my database size did not get any smaller from when I had the pics imported. After my system crashed when trying to save a compressed version, I tried cloning & importing. The file size still did not get smaller. Am I using the right command? Is there a line of code I need to put in the script to make it reference instead of import? Or do I need a different plug-in?

Hello: I am putting a run-time db on a CD. I want to have references to pics and include the images on the CD. I need some suggestions on how to place the images with the CD's path. Is there some place that stores the path info that I can get out and change? Currently, I am using an applescript to import the references, and I don't want to import the actual pics into the db. Here's what I tried: I created a CD that has the same path as what the image path would be on the final cd. Then when I made the run-time app, I included the images from the CD as the same path on the new CD. This seemed to make the Mac play nice, but not the PC version. Any suggestions? Thanks in advance!!

Hello: I have a runtime database that is view only. It will be written to CD-ROM. My concern is that users who have FM Pro on their machine can open up a .USR file, show all records and export these records to create their own direct mailing or whatever. Is there any way to prevent a user from opening runtime files directly in FM Pro? Any comments would be most helpful. Thanks!

Do I have to have the file open in FileMaker when I create the data source? I do have it open when I'm trying to CONNECT to the data source.

Hello FM Gurus: I have set up an ODBC Data Source for FM. I am connecting to the Data Source using ASP. I'm getting the error: "[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Database not open." when I try to connect. This is actually more promising than previous errors! I do have the database open in FM Pro, though. So my first question is--when I create the Data Source, it doesn't ask me the location of the file to use. Do I put the file in a certain folder? How does it know what file to use? #2 Any ideas why I'm getting this error? I'll paste my code if it'll help. Any info would be great. Thanks!!

Hello my FM experts! I'm creating a cross-platform runtime solution. I thought initially that I could have one file that is cross-platform. So far, I haven't found a way to do that, and the developer book is no help. So, I bound my files on windows, then on mac. Now I have two nice runtime apps, one for pc & one for mac. They run fine UNTIL I write them to a CD-ROM. Maybe I'm just doing something wrong there. The PC version runs wonderfully! The Mac doesn't recognize my mac version (after it's on the CD) and errors out when I open it, saying it doesn't recognize the file. I added ".fp5" to my mac runtime. I wrote the disc with Adaptec Toast, ISO 9660 format. I want to only have one disc for both versions. Pleez help me!!