I have a VB2008 app that we recently converted from VB6. It uses an Access 2000 DB. After completely removing all ADO and replacing with ADO.NET, we seem to be having a frequent problem where some tables in the database are losing their primary key. This may be happening after we compact the database.
Currently we download the database from the customer, open it in Access and restore the primary key.
I have two questions:
1. Is there any way to determine what may be causing this to try to stop it?
2. Is there a way I can programmatically restore a primary key in a table so we don't need to download the demo?
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: