Thanks to you guys at FmForums in the past I learnt so much that I didn

Thanks to you guys at FmForums in the past I learnt so much that I didn

Thanks to you guys at FmForums in the past I learnt so much that I didn

Hi, Alison. This will happen when there are multiple copies of the same file available to the user. One has no data in that field, the other has the data as expected. My first step would be to make sure there are no duplicates or clones of that particular file, either on the user's HD or on the network.

HTH,

Jerry

Hi, Alison. This will happen when there are multiple copies of the same file available to the user. One has no data in that field, the other has the data as expected. My first step would be to make sure there are no duplicates or clones of that particular file, either on the user's HD or on the network.

HTH,

Jerry

Hi, Alison. This will happen when there are multiple copies of the same file available to the user. One has no data in that field, the other has the data as expected. My first step would be to make sure there are no duplicates or clones of that particular file, either on the user's HD or on the network.

HTH,

Jerry

Hi Jerry. The user had no clones or copies - the backup script exports the data to a text file.

The file is set to multi-user as they occasionally network 2 laptops, but this time only one user was working on the file.

I'm still struggling here...

Hi Jerry. The user had no clones or copies - the backup script exports the data to a text file.

The file is set to multi-user as they occasionally network 2 laptops, but this time only one user was working on the file.

I'm still struggling here...

Hi Jerry. The user had no clones or copies - the backup script exports the data to a text file.

The file is set to multi-user as they occasionally network 2 laptops, but this time only one user was working on the file.

I'm still struggling here...

Can you verify that the other user (the one NOT working on the file at the time of the error) does not have a second copy?

Let's say User1 is the user who experienced the issue, and that he only experiences the issue when User2 is not working. This might indicate that User2 has a file which User1 is somehow accessing, and thus, when User2 is out if the office, the data in User2's local file cannot be accessed.

This is almost always the cause of the issue you're describing. But just in case it's not, some other thoughts:

populating the file with new data from an Excel spreadsheet supplied by the client

You say you do this, right? So it's not something that happens dynamically every time the user opens the file? Just making sure this is not causing the issue.

When they opened the Main file, and viewed the data as a list

Are you implying the issue does not occur when viewing as a form or table? This could be meaningful.

one particular field was blank

Is this a related field? If so, do other fields from the same relationship have the same issue?

Is this a calc field or a lookup?

Does the field have anything unique to it that might cause such behavior?

The second case was a number field, which is referenced by other (calculation) fields

And do the "downstream" calculations return the proper result?

Win XP SP1

Any issues caused by the OS should be more consistent, and not limited to only one field.

Filemaker 6.0v1

Try to get the user to upgrade to 6.0v4, which is the latest (i believe).

J

Can you verify that the other user (the one NOT working on the file at the time of the error) does not have a second copy?

Let's say User1 is the user who experienced the issue, and that he only experiences the issue when User2 is not working. This might indicate that User2 has a file which User1 is somehow accessing, and thus, when User2 is out if the office, the data in User2's local file cannot be accessed.

This is almost always the cause of the issue you're describing. But just in case it's not, some other thoughts:

populating the file with new data from an Excel spreadsheet supplied by the client

You say you do this, right? So it's not something that happens dynamically every time the user opens the file? Just making sure this is not causing the issue.

When they opened the Main file, and viewed the data as a list

Are you implying the issue does not occur when viewing as a form or table? This could be meaningful.

one particular field was blank

Is this a related field? If so, do other fields from the same relationship have the same issue?

Is this a calc field or a lookup?

Does the field have anything unique to it that might cause such behavior?

The second case was a number field, which is referenced by other (calculation) fields

And do the "downstream" calculations return the proper result?

Win XP SP1

Any issues caused by the OS should be more consistent, and not limited to only one field.

Filemaker 6.0v1

Try to get the user to upgrade to 6.0v4, which is the latest (i believe).

J

Can you verify that the other user (the one NOT working on the file at the time of the error) does not have a second copy?

Let's say User1 is the user who experienced the issue, and that he only experiences the issue when User2 is not working. This might indicate that User2 has a file which User1 is somehow accessing, and thus, when User2 is out if the office, the data in User2's local file cannot be accessed.

This is almost always the cause of the issue you're describing. But just in case it's not, some other thoughts:

populating the file with new data from an Excel spreadsheet supplied by the client

You say you do this, right? So it's not something that happens dynamically every time the user opens the file? Just making sure this is not causing the issue.

When they opened the Main file, and viewed the data as a list

Are you implying the issue does not occur when viewing as a form or table? This could be meaningful.

one particular field was blank

Is this a related field? If so, do other fields from the same relationship have the same issue?

Is this a calc field or a lookup?

Does the field have anything unique to it that might cause such behavior?

The second case was a number field, which is referenced by other (calculation) fields

And do the "downstream" calculations return the proper result?

Win XP SP1

Any issues caused by the OS should be more consistent, and not limited to only one field.

Filemaker 6.0v1

Try to get the user to upgrade to 6.0v4, which is the latest (i believe).

J

Happy 1000, Jerry!

Happy 1000, Jerry!

Happy 1000, Jerry!

Yeah

Yeah

Yeah

Thanks, Mike. Been a long time coming...

Thanks, Mike. Been a long time coming...

Thanks, Mike. Been a long time coming...

It's about ******* time! I could swear I've seen that mustache far more than a thousand times though.

Congrats!

It's about ******* time! I could swear I've seen that mustache far more than a thousand times though.

Congrats!

It's about ******* time! I could swear I've seen that mustache far more than a thousand times though.

Congrats!

the OS and the FM version are the only things that are different here

Just to confirm one more element: You are both using the files in multi-user environments? I initially got the feeling you (as a developer) were running them locally and not on the network.

Please forgive my stubbornness on this issue, it's just that any time i've ever seen this, the issue has been multiple files with the same name. Where are the files actually located? Are they on the primary user's laptop, or on a server? In either case, how are they shared? (You mentioned there are occasionally two users.)

Maybe others with more experience have other ideas. (Ender?)

the OS and the FM version are the only things that are different here

Just to confirm one more element: You are both using the files in multi-user environments? I initially got the feeling you (as a developer) were running them locally and not on the network.

Please forgive my stubbornness on this issue, it's just that any time i've ever seen this, the issue has been multiple files with the same name. Where are the files actually located? Are they on the primary user's laptop, or on a server? In either case, how are they shared? (You mentioned there are occasionally two users.)

Maybe others with more experience have other ideas. (Ender?)

the OS and the FM version are the only things that are different here

Just to confirm one more element: You are both using the files in multi-user environments? I initially got the feeling you (as a developer) were running them locally and not on the network.

Please forgive my stubbornness on this issue, it's just that any time i've ever seen this, the issue has been multiple files with the same name. Where are the files actually located? Are they on the primary user's laptop, or on a server? In either case, how are they shared? (You mentioned there are occasionally two users.)

Maybe others with more experience have other ideas. (Ender?)

OK, maybe it's time for a new photo! (JT, you've seen the mustache more than 1000 times because you repeatedly refer to my posts to learn everything you know about FileMaker, right? )

OK, maybe it's time for a new photo! (JT, you've seen the mustache more than 1000 times because you repeatedly refer to my posts to learn everything you know about FileMaker, right? )

OK, maybe it's time for a new photo! (JT, you've seen the mustache more than 1000 times because you repeatedly refer to my posts to learn everything you know about FileMaker, right? )

Oh, um, sure, that's it!

You should post a photo taken after you shaved that Snidely Whiplash off your lip, or at least one that didn't involve Photoshop.

Oh, um, sure, that's it!

You should post a photo taken after you shaved that Snidely Whiplash off your lip, or at least one that didn't involve Photoshop.

Oh, um, sure, that's it!

You should post a photo taken after you shaved that Snidely Whiplash off your lip, or at least one that didn't involve Photoshop.

Hi Jerry,

Sorry for the confusion. This stuff is small scale, so I developed it as a single-user solution. But occasionally the client needs to have 2 people sharing the files to get the project done in time. So when I send them their project, I set it to muti-user so that they can share the files over a LAN with the primary user as host and one guest.

In this case, thought the files were set for multi-user, there was only one person using them on his laptop. No guests, no servers.

Hi Jerry,

Sorry for the confusion. This stuff is small scale, so I developed it as a single-user solution. But occasionally the client needs to have 2 people sharing the files to get the project done in time. So when I send them their project, I set it to muti-user so that they can share the files over a LAN with the primary user as host and one guest.

In this case, thought the files were set for multi-user, there was only one person using them on his laptop. No guests, no servers.

Hi Jerry,

Sorry for the confusion. This stuff is small scale, so I developed it as a single-user solution. But occasionally the client needs to have 2 people sharing the files to get the project done in time. So when I send them their project, I set it to muti-user so that they can share the files over a LAN with the primary user as host and one guest.

In this case, thought the files were set for multi-user, there was only one person using them on his laptop. No guests, no servers.

Alison, it's hard to troubleshoot this type of problem third-hand, but it's possible there's corruption in file. FM5 and FM6 are cross compatible, so that's not the issue, though you and your client should make sure to update to the latest rev for your versions.

If this is a corruption issue, Importing to a backup clone may be sufficient to fix it, but an export to text then import of that is a good way to clean it up if there's latent corruption in the data itself.

Alison, it's hard to troubleshoot this type of problem third-hand, but it's possible there's corruption in file. FM5 and FM6 are cross compatible, so that's not the issue, though you and your client should make sure to update to the latest rev for your versions.

If this is a corruption issue, Importing to a backup clone may be sufficient to fix it, but an export to text then import of that is a good way to clean it up if there's latent corruption in the data itself.

Alison, it's hard to troubleshoot this type of problem third-hand, but it's possible there's corruption in file. FM5 and FM6 are cross compatible, so that's not the issue, though you and your client should make sure to update to the latest rev for your versions.

If this is a corruption issue, Importing to a backup clone may be sufficient to fix it, but an export to text then import of that is a good way to clean it up if there's latent corruption in the data itself.

So you are sending copies of the files around to people?

So you are sending copies of the files around to people?

So you are sending copies of the files around to people?

Yes, I send the client the files by email.

Yes, I send the client the files by email.

Yes, I send the client the files by email.

So how can you say there is only one copy of the file then, if you're posting file around the place by email?

There can only be ONE copy of the file anywhere on the network, otherwise it'll cause problems. Jerry picked it up in the second post in the thread.

That's what the problem is.

So how can you say there is only one copy of the file then, if you're posting file around the place by email?

There can only be ONE copy of the file anywhere on the network, otherwise it'll cause problems. Jerry picked it up in the second post in the thread.

That's what the problem is.

So how can you say there is only one copy of the file then, if you're posting file around the place by email?

There can only be ONE copy of the file anywhere on the network, otherwise it'll cause problems. Jerry picked it up in the second post in the thread.

That's what the problem is.

Sorry Vaughan, but I don't get your point. Client = business client. I email him zipped files that he upzips to his hard-drive. Most of the time he's working on a laptop which is not attached to a network. How can that be a problem?

Sorry Vaughan, but I don't get your point. Client = business client. I email him zipped files that he upzips to his hard-drive. Most of the time he's working on a laptop which is not attached to a network. How can that be a problem?