Strange problem going on on the backend database.

[rodvaN]

Hello..
I got a frontend and backend database, on the backend obviously i got all the data shared in a server.. Well the problemhre is that after been using the database for 1 week now it displays an error on a statistics that i put starting the program.. it says
"Mismatch of data in the criteria expression"
But I found the line of the data that its giving the error.. I checked it all and it seems to be ok compared with all the other cells..
Anyone know what could possibly cause this?
Anyone has been thorugh this?
Thanks in advance.

 

[georgedwilkinson]

More information would be great.

What rdbms are you using on the backend?

How do you know that the error is coming up? Where/when do you see it?

Why couldn't you share the results of your troubleshooting with us? Where's the "line" of data that "is giving the error"? How do you know? What do the "lines" of data look like that don't give the error? Why are you calling "it" a "cell"?

Check the links in my siggy.

 

[rodvaN]

Would you like me to upload the whole database?
Dont know what is failing on the backend database, it seems to be the data because it starts deconffiguring the frontend database, now it doenst wok on some querys and displaying subforms, what could be happening?
Let me upload in a FTP the 2 files and ill send it on private message OK?

More information would be great.

What rdbms are you using on the backend?

How do you know that the error is coming up? Where/when do you see it?

Why couldn't you share the results of your troubleshooting with us? Where's the "line" of data that "is giving the error"? How do you know? What do the "lines" of data look like that don't give the error? Why are you calling "it" a "cell"?

Check the links in my siggy.

 

[rodvaN]

just sent you the private message georgedwilkinson..
Thanks in advance..

 

[georgedwilkinson]

I received your PM which I have pasted below for the edification of the forum.

Hello there, I hope you can help me on this error, look the first error displaying its from the ID 919 from BASE Table in the buhorus_nova
You erase it and youll be able to see the statistics..
The same happned on the Inventory, If yyou go to "INVENTARIO" on the main menu then "STOCK: Busquedas" You wont be able to see the subform, but if you delete some data on the BASE now you can see it, dont know whats wrong because Ive checked the whole BASE table for errors and nothing, but I clean it some datas and the frontend works like a charm.
Please would be of really help this..
If you want I can pay you with free hosting!
Thanks in advance.
www.cerebro-digital.com/database.rar

First, I'm not able to open a RAR file. I looked at the possibility of downloading software to do that but the sites that have the software look shady and I prefer to keep my PC pristine.

Next, can you please use the forum rules and post the file according to How To Upload A Database To The Forum? That way, other people can share in the resolution, if we come up with one.

I perceive that English might not be your first language which might be why you are having problems plainly describing the problem. Reading your PM, the problem sounds like it has absolutely nothing to do with the problem you described in your OP, though there is not enough descriptive information here to provide an initial opinion. It just doesn't sound like it is related to the back-end breaking, which was the impression I got reading your first post.

Last, these forums are for the world to share. If you PM me, or anyone else, to get a "personalized" solution, you are depriving other people, now or in the future, of sharing the knowledge and maybe even trying out resolving the problem themselves. There is also a possibility that a person you PM will not answer. As a personal note, I prefer to discuss technical issues on the forums and like to reserve PMs for administrivia and banter with my forum friends.