Stack Overflow
Stack Overflow

Questions tagged [compact-database]

70 questions
1
vote
1 answer

Re Share File on Network

I currently use the VB6 CompactDatabase method to compact a .mdb (Access DB) file and have searched high and low for a way to reapply the Share Permissions on Original DB using VB6. The CompactDatabase code: Set jro =…
FLOG51
  • 43
  • 1
  • 6
0
votes
3 answers

Why does compacting a Access 2000 db changes the order of records in a table?

As the question says. The table has no primary key defined. Other tables in the database do not change after compacting, and have as well no primary key defined.
razvan
0
votes
2 answers

What causes "Could not load database compaction library" and how can I fix it?

In a compact framework .NET 3.5 application running on Windows Mobile 5 we are seeing the following error message being logged: Could not load database compaction library. Operation has been aborted. at…
Richard Lucas
  • 630
  • 1
  • 4
  • 15
0
votes
0 answers

Microsoft Access Database Error - Bookmark Error

Last night my desktop crashed and my Access database shut down abruptly. Now when I try to open it I get these, "Invalid Bookmark error", and won't open. I tried to compact and repair but when I select the database it won't accept it. Does anyone…
Jorge Varela
  • 1
0
votes
0 answers

Can I prevent disk filling up by changing a Mongodb collection from TTL to Capped?

I have a MongoDB 4.4 server (single node, no replicas) for storing IoT-style data. Data is written to several collections every few seconds by my NodeJS app. Documents are not updated/modified, and reads are less common than writes. I have TTL…
John
  • 6,701
  • 3
  • 34
  • 56
0
votes
1 answer

I get the error: file or assembly system system.data.sqlserverce not found

Picture error from my device On emulator it work but on my device it dosen't work. I copy build file to my device and run. It right? file copy My device Infomation CE OS 5.2.29370 .NET CF version 3.5.14269.0 Propreties DB I correct…
Taq Atom
  • 3
  • 2
0
votes
0 answers

Compact databases using OpsManager

We are managing our mongodb clusters using Ops Manager. Is it possible to compact databases by using Ops Manager to avoid manual process? Thanks
cosmos-1905-14
  • 783
  • 2
  • 12
  • 23
0
votes
1 answer

Compacting Microsoft Access Database without using DAO

I use the CDatabase class to open a ACCDB Access database. The driver is: _T("Microsoft Access Driver (*.mdb, *.accdb)"). I can open and use the database OK (have done so for many years): if (DatabaseExist(m_strMDBPath)) { // AJT v10.5.0 Take…
Andrew Truckle
  • 17,769
  • 16
  • 66
  • 164
0
votes
1 answer

MS Access 365 error - compact and repair error

I am suddenly receiving the below error message when attempting to compact and repair my access databases. Clicking ok on the error message results in original .accdb file being deleted and an .mdb being saved out. When entering the database I'm not…
MGilbert
  • 21
  • 2
0
votes
0 answers

compact mongodb collection in background

I always run the compact command on mongodb and it disturb the performance of the DB , do you know if adding Background : true will work ? I'm asking before testing it . db.runCommand({compact:'OPC_PLANT_DATA'}, {'background' : true})
AbdelAziz ESSAADI
  • 21
  • 7
0
votes
1 answer

compact list object in a tidy dataframe R

I have a list object (results) and am trying to compact it in a tidy data frame. But I am not sure how to achieve that. [[varying from 1to 3nsim][[varying from 1 to 9]][[varying from 1to 3]][[varying from 1to 3]] I have such nested list and I want…
Ibrahima
  • 11
  • 3
0
votes
2 answers

Compact and repair Access DataBase in run time using C# without Access installed

I write a program that should run on a lot of machines I did not installed Access in the machines But I have an access database using on them When I write and delete data from this Access databases its size grow up so every few days I have to…
hedbisker
  • 179
  • 1
  • 1
  • 15
0
votes
2 answers

Connect to SQL Compact 4.0 with ADO connection

Using the SQL Compact version 4.0 from Microsoft SQL Server Compact 4.0, I've created a new compact database on E:\tmp\EmbSQL.sdf with SQL Studio. Trying to connect from Excel Macro: Set conn = CreateObject("ADODB.Connection") strCnxn =…
Ronald
  • 1
  • 1
0
votes
1 answer

swicth combobox to textbox

I have add a options form to my application. There is 2 radio buttons and when the options form is closing that form saves the data to database user is selected witch one of these radio buttons. And I have another form is writing some data to…
Sefa
  • 8,865
  • 10
  • 51
  • 82
0
votes
1 answer

How to connect tables on Sql Compact?

I have 2 table database; Firt table's columns; ClubID(Primary key, auto-increment enabled), ClubName Second table's columns; ShowID(Primary key, auto-increment enabled), ShowDate, ClubID User is selecting Club's name on the form, when user selected…
Sefa
  • 8,865
  • 10
  • 51
  • 82
1 2
3
4 5