Corruption of Back End

marian

Hi

I have a split db where the BE is on an MS SQL Server and the FE on 8
local Win2K workstations.

The BE db is corrupting with alarming frequency giving an error about
an unrecognisable database format. The .ldb file is locked and can't be
deleted. Repair works but takes a long time and everyone has to be out
of the db for that time. This is causing difficulties as it is
happening so often.

Any ideas why the BE might be corrupting - no pattern that I can
establish to the occurrences in terms of development, usage etc. The BE
contains tables and some linked SQL tables - there are no forms,
queries, reports, modules, macros etc.

It is c.80mb in size.

Many thanks
Marian

Nov 13 '05 #1

Subscribe Post Reply

1155

Sharktyyfa

<ma****@compsols.fsbusiness.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi

I have a split db where the BE is on an MS SQL Server and the FE on 8
local Win2K workstations.

The BE db is corrupting with alarming frequency giving an error about
an unrecognisable database format. The .ldb file is locked and can't be
deleted. Repair works but takes a long time and everyone has to be out
of the db for that time. This is causing difficulties as it is
happening so often.

Any ideas why the BE might be corrupting - no pattern that I can
establish to the occurrences in terms of development, usage etc. The BE
contains tables and some linked SQL tables - there are no forms,
queries, reports, modules, macros etc.

It is c.80mb in size.

http://allenbrowne.com/ser-25.html
--
Sharktyyfa

Nov 13 '05 #2

Sharktyyfa

<ma****@compsols.fsbusiness.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi

I have a split db where the BE is on an MS SQL Server and the FE on 8
local Win2K workstations.

The BE db is corrupting with alarming frequency giving an error about
an unrecognisable database format. The .ldb file is locked and can't be
deleted. Repair works but takes a long time and everyone has to be out
of the db for that time. This is causing difficulties as it is
happening so often.

Any ideas why the BE might be corrupting - no pattern that I can
establish to the occurrences in terms of development, usage etc. The BE
contains tables and some linked SQL tables - there are no forms,
queries, reports, modules, macros etc.

It is c.80mb in size.

http://allenbrowne.com/ser-25.html
--
Sharktyyfa

Nov 13 '05 #3

by: Mark C. | last post by:

The company I work for has been running Access 2000 on a Windows NT server with Opportunistic Locking turned off on the server without issue for almost a year. We have just switched to a Windows...

Microsoft Access / VBA

DAO and database corruption

by: Mike | last post by:

I have done a lot of research on DAO and database corruption and have not yet found any solid information for my problem. I use DAO extensively in my Access 97 databases (back-end on network,...

Microsoft Access / VBA

Access 2000: Is this corruption or not?

by: Doug Vogel | last post by:

Hi All - I have a client for whom I developed an Access 2000 database. The database is split into 2 files - front-end (forms, queries, reports), and back-end (tables). An .mde file has been...

Microsoft Access / VBA

Access DB "on it's way" to corruption

by: Matthew | last post by:

Hello Access gurus, I'm helping out a friend who's a small business owner. The software he uses to run his shop uses an Access backend. We recently had some huge headaches w/DB corruption. We...

Microsoft Access / VBA

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...

Microsoft Access / VBA

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics