Replies

Naturally I was looking for a commonality in the deletions. The only commonality I could detect was that about half the amount of records in the tables were deleted: the bottom half.
No commanality in dates. It affected also two totally different tables at different times.

Were the records in any other tables deleted?
No, it occurred twice, each time only one table and about the bottom half of the records.

Is there any commonality from instance to instance?
No, first time in the afternoon, second time in the morning. Several persons were connected to the db each time. No specific actions before the loss of data.

And I’m sorry, but putting the frontend and backend together to solve a performance issue is never a good solution! You generally end up creating more problems than you solve. There are ways to solve all performance issues.
I know! I am working on that and I know a lot if solutions to that. They only take some time to implement. Frontend and backand will be separated again! But that is not the issue here!

The loss of data is the issue here and a bigger problem than the separation of frontend and backend or the performance!

Thanks for trying to help!

Are you using some of the new field types that it introduces?
No, I only use the good old well known field types.

Also are you doing anything with cascading deletes in your referential integrity settings?
No, all deletes are done by code. In the code the correct referential order is ensured. Referential integrity is implemented in the database in case someone is trying to update data directly. Looking at the type of users for this application that is not likely to happen.

Also have you seen it again in the last few days?
No, but last time there was a period of two weeks between loosing the data. Both times data was deleted in a different table. About half the records of the tables affected were gone although referential integrity applied to the tables should have prevented that ……

(My apologies for not responding sooner – I spent 3 days driving across part of the US and back… .)
Hey, no problem, it is a forum not a telephone call…. I am glad you are thinking about this problem.

Bart

Splitting the database is not the problem here. I am working on that!

The problem is the loss of data in the tables!
The format of the database is accdb.
It used to be mdb, I converted it to accdb and added more functionality.

– I haven’t heard of this problem, and I have no idea what causes it, but I’d turn off Compact on Close for the moment.
I already did turn of Compact on Close last friday (was already one of mine suspects too). Last time there was one and half week between loosing the data in the tables (one table the first time, a different table the second time).

– And you should still split the database into a frontend and backend!
I know! I had seperated those (I normally do that) but the application performance became too slow. I am still trying to find the cause of that. Putting the data and the logic together solved the performance problem for now.
Application is located at a file server from where it is started by the users.
At least twice a day a backup is taken (for the moment).

Thanks for the quick reply
Bart

(Edited by HansV to make URL clickable – see Help 19)

OK, I took a look at the editors.
They all are HTML editors, not ASP editors.
KompoZer looks great for HTML editing, it even refuses to open ASP pages (so does NVU)I
Note Tab lite does not add much to the notepad++ editor I am using (besides a lot of help).

I found another editor HAPedit that is more suitable for ASP editing (http://hapedit.free.fr[/url%5D)

If anyone has a better suggestion, please feel free!

Bart

Thank you all!
I will take a look at it tonight.

Thanks!

Google Calendar seems to do the job.

I downloaded and executed WinsockxpFix.exe.
This solved the problem.

Thanks for all the replies.

I just found out that this computer also cannot ping its own IP address.

No hardware or software changes made prior to the problem.

I connected the computer to a completely different network. The problem also exists there.
Ik can ping from the computer with the network problem other computers but I can not ping the computer with the problem

From the computer with the problem I can ping 127.0.0.1 and 212.79.247.24.
I can also ping the router from that computer. I can not load the setup page from the router.

I replaced the network card, no effect.
I removed all firewalls on all computers, switched off the Windows firewall on all computers, switched off the virusscanner on all computers (unplugged the modem for safety reasons during this test), no effect.

Next step is moving the computer to another network (I will do that tonight) en see what happens.

Any tips are still welcom.

Switching off firewall and virus scanner is no solution to the problem, after killing them the problem still exists.
Different router port and new network cable also do not have any effect.

No, I do not want to have any user actions, it is running in an SQL Server 2000 DTS batch proces.
I am trying to put it into a VB script now.
The script has to open the Excelsheet, to save one of the sheets as a csv file and close excel again.
It doesn’t work yet……

No, I do not want to have any user actions, it is running in an SQL Server 2000 DTS batch proces.
I am trying to put it into a VB script now.
The script has to open the Excelsheet, to save one of the sheets as a csv file and close excel again.
It doesn’t work yet……