|
View Poll Results: Ideas on Lost records in AccessDB frontend & SQLDB backend | |
Impossible
|     | 0 | 0% | |
Possible
|    | 0 | 0% |
I'm working with an application that has an MS Access front end linked to the SQL Server DB backend. During a period of one week, 32 records of a spefic event (and all related records to that event) disappeared from both DBs. The application uses an Access report db for users to query for specialized data. Security is to the Access DB is limited to 3 db admins (2 IT, I departmental), and 1dept manager. The app's audit log is supposed to track app activities, however, nothing is logged showing deletes for the missing records. The SQL Database is secured for one user, the IT DB admin.
We have a restored copy containing all of the missing records and are working to insert the mising records into the SQL DB.
There are no delete queries that have been run ** to my knowledge **. The application IT admins (myself and one other) have not deleted anything thru the Access DB. The SQL DB admin did not delete anything (no time, no inclination, besides not having the application knowledge for the precise removal of records) Our departmental admin doesn't have the query knowledge on delete queries. The department manager has minimal query knowledge and works through the application database analyzer for minimal changes to reports.
In my research, I found a few references to pc, systems crashes and network failure causing data loss in Access databases due to way Access retrieves data. This info is from a technical bulletin dated 4/2/02 and refers to a Microsoft article Q300216. According to the article, all tables involved in a form, report or query are copied across the network from the server to the pc. The tables are then processed and filtered to generate the recordset.
Additionally, if several users are using file read, write, and locking operations on the same shared file(s) accross the network, the file(s) can be left in an incomplete or a corrupted state. Two examples given were unexpected, abrupt client termination or a dropped network connection.
If Access DB has been corrupted, and is linked to the SQL database, could this be a possible answer to our problem. We plan on doing our own restore as we have both missing data and the qualified staff.
The vendor, not surprisingly, has claimed negligence on our part for the missing records, mainly due to the absence of corroborating audit trails. My purpose in posting this question is to validate our research and encourage (strongly!) that the vendor improve their product and prevent this from occurring again.
1  2737  MMcCarthy 14,534
Recognized Expert Moderator MVP
Have you traced all dependencies on these records for a possible cascade delete. That is a deletion of another record that shouldn't be related to these records but has a foreign key reference that Access has created a relationship for.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: matt bourke |
last post by:
Hi,
Can you please tell me what the advantage is of using an access backend with
a VB frontend OVER access as a frontend and backend.
M
|
by: Lee Rouse |
last post by:
Hello all,
This is going to be a rather lengthy "question".
I have an Access 2k database, separated front end/back end. Front end
copies are on about 30 workstations and used frequently during the
work day. The backend has a table called CLIENTS with approximately
6000 client records. Changes to data in the table are made via a
frontend db Form which has CLIENTS as its record source.
|
by: Manuel Lopez |
last post by:
I have a puzzling form timer problem that I didn't experience prior to
Access 2003 (though I'm not sure access 2003 is to blame).
Here's the situation: a computer has two access 2003 databases on it, a
frontend and a backend.
Case 1: If vba code on the frontend updates many rows (360,000) on the
backend, a form's timer event (from the frontend) will stop firing until the
user gives the form focus. (Note that the update itself always...
|
by: PC Datasheet |
last post by:
I have zero experience with using a SQL database for a backend and Access
for a frontend. I have some questions:
1. Does an SQL database have tables?
2. How does Access connect to the data in an SQL database? Linking,
importing, or ???
3. Earlier today there was a thread regarding DAO and ADO. In the thread it
was said that ADO is very useful when the backend is a SQL database. Could
someone explain that?
|
by: Gary |
last post by:
I have the backend database on a network drive. There are 3 employees that
access this backend database through their respective frontend databases
(located on their respective C drive).
One of these employees has a laptop.
Q1. The laptop provides a problem in that each time it is connected to the
network, he cannot access the backend. The database window still has the
linked tables. The only remedy is to simply deleted the linked tables...
| | |
by: gerbski |
last post by:
Hi all,
I am relatively new to ADO, but up to now I got things working the way
I wanted. But now I've run into somethng really annoying.
I am working in MS Access. I am using an Access frontend separately
from a backend. The tables from the backend database are linked in the
frontend database.
In the frontend there is a Form with a listbox in it. The listbox
rowsource is a query that selects all the records from a (linked)
|
by: odrap |
last post by:
I have a database written in MS Access 2.O that i'm intend to convert to MS ACCESS 2007.
The database is a multiuser application which consist of a application database as the frontend and a Data Database as the backend. In my MS Access 2.0 program the code is present to make the link between the data database on the backend and the application database on the frontend. Both computers are part of a local network. I know that MS Access 2007...
|
by: John Kirkpatrick |
last post by:
Hi all,
I am having difficulty displaying records on a frontend MS Access 2000 form using a MySQL backend. The following code works well with the Jet database engine but doesn't work properly using the MySQL backend database. All records are displayed on the form using the Jet, but only one record appears using MySQL. Perhaps it just needs some tweaking to work with MySQL. Any advice would be great. Thanks
Function HelpDesc(HelpFrm As...
|
by: Steve |
last post by:
I have zero experience with ODBC. If I have an Access frontend connected to
a SQL Database using ODBC, are the tables connected like a frontend/backend
Access database where the the tables you see in the frontend are only
"copies" of the tables in the backend? Or ar the tables "real" tables
connected to the SQL tables in some manner? If the latter, can an Access
table have more fields than the SQL table it is linked to?
The reason for my...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
