Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Databases

55K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi

I  found the business account ledger Access template database in Access 2016.
It works on single entry accounting.
Would it be easy to modify it to use double entry accounting?
If not is there a similar Access template for double entry accounting?

Thanks
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hello,

For security reasons, users must query a replica database that is updated by an intermediate replica.
We must ensure performance and that requests do not impact replication. How to proceed ?

Thank you

Regards
0
Wel I cannot  export the following  big table and the expdp log is as follow:

;;
Export: Release 12.1.0.1.0 - Production on Tue Jan 16 10:46:02 2018

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_04":  "/******** AS SYSDBA" directory=EXPRMAN dumpfile=dmpSGCIPROD160118.dmp logfile=dmpSGCIPROD160118.log TABLES=SGCEIPROD.GININFORMES CLUSTER=N
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 58.30 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
ORA-31693: Table data object "SGCEIPROD"."GININFORMES" failed to load/unload and is being skipped due to error:
ORA-02354: …
0
So the new version of MS Access doesn't have "command button wizard"  
How do I save the new data then clear the field for the next entry?  
I can do one but not both
0
I want to import the directory without set the import location , because i have many directory to import.

$log_directory = '/xampp/htdocs/mydoc';

$results_array = array();

if (is_dir($log_directory))
{
        if ($handle = opendir($log_directory))
        {
                //Notice the parentheses I added:
                while(($file = readdir($handle)) !== FALSE)
                {
                        $results_array[] = $file;
                }
                closedir($handle);
        }
}

//Output findings
foreach($results_array as $value)
{
    echo $value . '<br />';
}

Open in new window


$log_directory = '/xampp/htdocs/mydoc';
I dont wanna set path like this .. izit posible or not ? because i lazy set again and again to import different directory
0
Hello,
I want to show database text in my website but this text is a XML file structure. The browser shows this text as part of html.
How I can show this string as real text? So also <> nodes will shown as text?
0
Community -

I'm working on a simple database that will be presented used internally to perform a simple filter operation on the entire recordset based on selections made from two combo boxes. I've got the first part figured out, but I'm drawing a blank on the filtering component. I'm looking for the most efficient way to achieve this.

The workflow should go as follows:

 - User selects an industry from the Industry combo box (this filters the second box)
 - User selects sub-industry from Sub-Industry combo box

At this point - a subform/query should return the results that correspond to the selection made in the combo boxes from the table breachArticleInfo.

As always - I appreciate the time!
0
PLEASE DELETE
0
When I try to import data from an Excel file into an Access database using the below code I do get a table "test" created okay but it only has a single empty column in it with a field name F1 assigned to it.  I couldn't get all the defined fields from the Excel file with data into test table to reside in Access file.

Private Sub Command0_Click()
Dim Filepath As String
Filepath = "C:\Users\ErdenR\Desktop\Local Data Warehouse\Exports\OCEAN\201801_OCEAN_MTD.xlsb"

DoCmd.TransferSpreadsheet acImport, , "test", Filepath, True

End Sub

Can any expert help with that issue please?
0
I've been thinking to migrate my erp(java currently) from rdbms(firebird currently) to nosql (mongoDB likely) and i trying to antecipate some issues. I'm trying to make a "failproof" inventory control which never let a qty's item be smaller than 0. Offcourse i still get "ACID bias" which i need to left in order to complete this task. The goal is update inventory qty of all order's items when approve the order. For that, 2 problems can occur which currently are resolved with a trigger.

1.problem: order gets 2 items (ball = qty 2 and chair = qty 1) and there is no enough qty in inventory (ball = qty 1 and chair = qty 0) to complete the order. Once i trigger the command do complete the order, a loop is executed to decrease qty in inventory and fails on the second item cause there is no enough qty. Consequently rollback operation is trigged and everybody go home happy.

2.problem: in one word, concurrency. suppose there is no trigger controling this operation but only "selects and if". User 1 query inventory qtys, see enough qty (ball = 2, chair = 1) e system allow complete the order. While the transaction is running user 2 query same invetory qtys but because first transaction is not complete yet second query see "old" qty (ball = 2, chair = 1) e system also lets complete order. Consequently, 1 qty of chair is descreased twice, but shold be descreased only once and fail on the second. Result: i got negative qty.

I saw some workarrounds with inventory reservation but i …
0
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

How to fix this .. can upload the directory but all the csv file content i upload was the same file  ..
Actually there are 30 files , but one file uploaded 30 times.
Here are my code for upload part .. upload.php
<?php
include 'config.php';

if(isset($_POST['btn-upload']))
{    
  $log_directory = '/xampp/htdocs/mydoc';
  $results_array = array();

        if ($handle = opendir($log_directory))
        {
                while(($file = readdir($handle)) !== FALSE)
                {
                    if ($file != "." && $file != "..") {
                        $results_array[] = $file;
                    }
                }
                closedir($handle);
        }

  //Output findings
  foreach($results_array as $value)
{
 $csvMimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain');
    if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'],$csvMimes)){
        if(is_uploaded_file($_FILES['file']['tmp_name'])){
            
            //open uploaded csv file with read only mode
            $csvFile = fopen($_FILES['file']['tmp_name'], 'r');
            
            //skip first line
            fgetcsv($csvFile);
            
            //parse data from csv file line by line
            while(($line = fgetcsv($csvFile)) !== FALSE){
       

Open in new window

0
I have got an Oracle 11 backup . But it is more than 10 .bck files ( ranging from 9gb to 2 MB .   There is no script. But I have a Oracle database created for a different purpose. How do I raise the oracle backup there ?
0
HSSFSheet sheet = wb.getSheetAt(0);
            HSSFRow row;
            for(int i=1; i<=sheet.getLastRowNum(); i++){
                row =  sheet.getRow(i);
                int id = (int) row.getCell(0).getNumericCellValue();
                String name = row.getCell(1).getStringCellValue();
                String address = row.getCell(2).getStringCellValue();
                String sql = "INSERT INTO test VALUES('"+id+"','"+name+"','"+address+"')";
                pstm = (PreparedStatement) con.prepareStatement(sql);
                pstm.execute();
                System.out.println("Import rows "+i);
            }
i got error in declarating id, name and address
0
I tried to run command from raised command prompt:  icacls “F:\system volume information” /grant Administrators:F
I get a Invalid parameter "Volume" error
Due to a corrupted DFSR database I need to delete the DFSR folder in the system volume information folder.  I already removed the replication groups and even removed DFS role service from the file services role.
Any help would be appreciated.

Steve
0
Oracle Corp has a bunch of really good training videos.  I'm trying to find where these exist, and specifically interested in a "Upgrade from Oracle RAC database 11g to 12c".  Can anyone help me locate video from Oracle Corp?  I know there are a lot utube videos from an array of sources out there, but I am specifically looking for video from Oracle.
0
I've installed oracle database 10g express edition on windows 10 & 32bit operating system. But I can't proceed after that. There's shown nothing.
0
We have 2 servers running exchange 2013 which are in a DAG setup.
For the past week or so, every once in a while the active server will fail the dbs over to the passive node. I don't see anything in the event viewer to indicate what the issue maybe. Not sure if it is a network issue or what but once I see it has failed over, I just fail it back and then it is good again for some time.
Any suggestions on what I can check for this issue?
Thanks
0
I have a user that has a 2010 Access database that when he double clicks the database from the folder location or a shortcut on the desktop it opens just fine. If he adds that file or shortcut to his quick launch toolbar in Win 7 pro it opens the Access program and he has to select the database instead of opening the database?
0
Dear Experts,

I need to select all records that contain a string in all tables of the database.
I find quite a few entries on the internet and also in EE, but none "works" for me.

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production.
How can we I get started on that?

Thanks for your help.
W.
0
[eBook] Windows Nano Server
LVL 1
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Trying to build a report but I am running into several issues. The first should be simple: I need to label the total field for a group of items. The group name is in the database, as an entry of 0 for a section. I have attached an example of how the database table is laid out. Basically, in the group footer with the subtotals I want to pull a record for the description where the section entry is a 0.

The second issue is more complex: I want to show previous years sales data and compare it with current year. the date selection in the report has a start date and an end date. This field is set up YYMM, like 1711 for November 2017. The record is stored as a character type though, which makes subtracting a digit difficult. I already have the report built to show current year data for whatever date range is entered, an example is attached
GroupDB.PNG
SaleReport.PNG
0
I am putting together a report for our production facility to show when lines are ready to run and whether another process is also ready to run. Attached is the sample report I am trying to duplicate using SSRS (rto.png). However, when I run the report in SSRS, the lines are not continuous across the report as shown in capture.png.

The report will run once weekly for the previous seven days from GETDATE()-8 6am through GETDATE()-1 6am.

The data points the report is based upon are both either 0 or 1. There is only a data entry point if the value changes. So the way I have set up the stored procedure is to find the first data point AFTER 6am on the first date and then set the value at exactly 6am to the opposite of that. I have done this for READY and RUNNING. When the data point changes, there is an entry in the database.

I want the lines to continue across and print until the value changes.

I have manipulated the final values for READY by adding .1 to the value so they can both appear on the same chart and not be right on top of each other. The READY will show on top in the chart because this process is supposed to be READY if the line is RUNNING. The RUNNING line should always be underneath the READY line. The processes are both either on or off. I'm also including a chart showing the data this is currently pulling.

How can I get the lines to continue at their current value until that value changes?
rto.PNG
Capture.PNG
data.png
0
I want to be able to reassign a record from one master to another.

For example.  I have a piece of equipment with an ID of 250.  And I have 4 other pieces of equipment that are associated to the equipment with ID 250.  (One to many relationship)  I want to move one of the four pieces from ID 250 to ID 251  How do I go about doing that?

What i have envisioned is a drill down with a list of the equipment and button that says move.  

Thanks
John
0
We currently have a DPM server with version 4.2.1553.0 installed. We are trying to install rollup 12 version 4.2.1589.0. When attempting the install, initially we had problems with services not stopping during install and it would return 'Microsoft System Center 2012 R2 Data Protection Manager Update - KB3209592'. It would then rollback however we seem to get round this by allowing permissions to the C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\agents\RA\4.2.1553.0. After adding these permissions the services could then be stopped and started successfully by the installation.

We have now hit another error during the install when the install is on the stage 'executing sql strings', when reviewing the log file the following error appears

MSI (s) (44:D4) [10:01:12:505]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
MSI (s) (44:D4) [10:01:12:573]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (44:B0) [10:01:12:575]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIFAE4.tmp, Entrypoint: ExecuteSqlStrings
MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:151]: Transforming table …
0
I need help with my ASP.NET MVC application hosted on iis. The application loses connection to MYSQL database after sometime and requires me to restart mysql service then it continues to connect.
0
I am building an Access 2016 database with two different tables. The first table has a list of patients and doctors, procedures and cost, etc. The doctors on the list are represented by a number instead of their name. Say "1," or "35."

I have another table that has what is essentially a key for that information. In the first column I have those numbers and in the second column I have the names of the doctors to which each number represents. So Column one says "1" and Column 2 says "Dr Jones, MD."

In Microsoft Access, how do I force the database to display the names instead of the doctor using the second table? RIght now the query comes up with the field for doctor and shows the numbers. I need the database to say "Oh, the doctor field is listed as 1 so therefore it is actually Dr Jones," and display that. I'm sure it has something to do with dependencies or relationships but I'm not sure what to do. I can provide an example, if necessary.
0

Databases

55K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.