When I open a DB I copied over from an XPS15 (WIN7) into an XPS12 (WIN 7 or WIN10) laptop, I get s security warning. I have to select ENABLE CONTENT to be able to run my main FORM against my table and its one to many relationships (or even open a table). Is there a way to turn off that security warning and everything associated with security checking?
Why is ACCESS running any security surveillance?
The XPS15 platform and my 55KB dbase (ACC2007) runs lightning fast and I never saw this security warning for since the initial days 12 + years.
So why is it that if I have an XPS12 with ACC2007 all of a sudden I see this ENABLE CONTENT stuff?
Even after I enable the content, could this "Security Survellance" be slowing down the I/O between the form and the table and all the one-to-many tables?
I ask these questions because for some reason, this "application" I have been using for a dozen years with zero problems, all of a sudden, runs very slow on this new XPS12 platform. THE XPS12 has enough RAM and hardware so that I don't believe memory is the problem.
I also notice that on the XPS15, the maintable uses autonumber long integer as the primary key, however INDEXED=NO and when I right click on that field called "ID" it is not possible toggle "PRIMARY KEY", ditto if I click on the DESIGN menu. Yet when I copy the DB onto the XPS12, I am forced to ENABLE CONTENT, and when I open that main table, the "ID" field is already toggled to PRIMARY KEY, INDEX= YES(no duplicates) is mysteriously defaulted (still autonumber longinteger). While true, that is how the ID field functions and I don't have any objection to the setting, it seems odd that the ACC2007 "environment" on the XPS12 looks and feels different. And so I wonder if the performance speed difference is somehow linked to some background security surveillance that is checking each I/O from the table to the form?
The degradation in speed to populate the form each time I move from field to field on the form is bad enough (3 to 7 seconds from field to field) that I am putting myself through all kinds of efforts to cut the DB size down to 33KB and figure out some sort of ARCHIVE "System" and learn about APPEND and SET and all kinds of programming concepts I have almost no experience with. So if my performance issue is really the security, then if I could eliminate that, maybe I don't need to figure out all this other complicated ARCHIVAL approach.
It just doesn't make sense to me that a DB application works great on WIN 7 [8 RAM] on one laptop and gets dog slow on another equivalent device.
Any insight out there?