Go Premium for a chance to win a PS4. Enter to Win

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

This seemed to me a very easy thing to do at the beginning, but it got complicated and very challenging. I am pretty new to MS Access, so -after struggling for many days- I hope to find the solution here.

Say we have a simple table like this:

Student Table
Now, I need to track changes on this table on the record level and Log the changes in another table (Say Log table) like this:

Track/Log Table
Where track_type:

1 for add(insert)
2 for edit(update)
3 for delete

The changes(add/edit/delete) should be logged when the record on the Student Form is changed.

My Problem is that I am not able to generate the changes correctly.

My form has to refresh a lot which make excessive entries in the log table like this one:


bad logging example
As you can see, instead of one log for the insert, it takes two logs to insert a record.

I searched the net thoroughly, but I cannot find this kind of logging. I found information about logging on the field level, but this is not what I want. I know it may be better in most cases, but not for my case.

So, I will appreciate any guiding information/code.

a minimized database that focuses on the problem is posted Here and you can download it and see what I have tried and where I am stuck.

Notes:

1- Changes should be logged only when the user: - Move from the current record on the form. - Exit …
0
New feature and membership benefit!
LVL 11
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Thanks to Rick_2CA - https://gallery.technet.microsoft.com/office/Mailbox-Pre-Archive-347f9162/view/Discussions

I have been able to Modify this script to include: TotalDeleteditemSize and TotalDeleteditemCount

This outputs the below and works exactly how I want:

ItemsCount      
ArchiveItemsCount      
ItemsSizeBytes      
ArchiveItemsSizeBytes      
TotalDeletedItemSize            
DeletedItemCount


The part I am having trouble with, and where I would like a push in the right direction is how to obtain the ArchiveTotalDeleteditemSize & ArchiveTotalDeleteditemCount (The count and size of data that CAN be archived, same as what is output from "ArchiveItemsSizeBytes")

Below is the script, that I have manipulated to include the

TotalDeleteditemSize & TotalDeleteditemCount......

I have attempted to match what was already in the script, by copying the code, and changing the values (Via Powershell ISE), However, I just end up with nothing being returned or getting the identical results as the ArchiveItemsizebytes

Essentially I am after the Archivable size & Count for recoverable deleted items

Any assistance would be greatly appreciated!!!

If I have worded anything wrongly, or something does not make sense, please let me know, and I will be happy to clarify...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


# Exchange 2010 Mailbox PreArchive Statistics
# Purpose:  Query mailboxes for mail older than X days in order …
0
Hi everyone!
I've encountered a problem of combining different databases together in a single query. I'm searching for the way to get a desired result, but no success so far..". Possibly someone could point me to a right solution.

Description:
  1. There are 2 databases (DB): DB1 - Visual FoxPro database and DB2 - MS Access database
  2. Quering databases is organized with ADO
  3. In DB1 I have all the necessary information except a list of sold items. Sold Items list is located in DB2
  4. I need to query DB1 and list all the models, which have not been sold yet
  5. All the queries must be performed from inside Excel and returned to excel as well

A sample of simplified SQL query:
[VEHICLES] - Table from DB1 (Visual FoxPro)
[SOLD] - Table from DB2 (MS Access)
"	SELECT [VEHICLES].VEH_MODELS FROM [VEHICLES] " & _
"	LEFT JOIN [SOLD].VEH_MODELS FROM [SOLD] " & _
"		ON [SOLD].CODE=[VEHICLES].CODE " & _
"	WHERE [SOLD].VEH_MODELS IS NULL"

Open in new window

Problem: How can I make ADO understand which table is in each DB?

Initially ADODB Connection.string is set to use Visual FoxPro driver and DB1 location
(Example: ADOcon.ConnectionString="Provider=vfpoledb;Data Source=" & DB_Path & ";Collating Sequence=machine;")

Possibly anyone has faced such problems previously and could suggest smth?
P.S. Please don't ask why data is in separate databases =))
0
Hi,

Is there any way in SQL Server to know which SQL Select statements are not using indexes and running full table scans?

I am asking as I want to know which reports needs creation of new indexes .
0
I don't succeed  to connect mySql database from within my WebSite to  FDConnection component. Though I set all necessary fields given by the "info" button (in the  "Control Panel")  of my hosting server.  
it seems the hosting name given "mysql1051.servage.net" is not accepted by the component!
Please Help
0
I have been working on a SQL routine that pulls POs from a legacy application and inserts them into a modern ERP solution. In our data center the process pulls in all 20,000 POs in less than 20 minutes. We just tried to deploy this routine in the customer's environment and the process took over 10 hours. This routine deals with about 10 tables in two databases that are housed in the same instance of MS-SQL 2012. What tools can I run on both ends to identify what is causing the bottleneck on their system?
0
Hi,

I am trying to import these Apache logs into an SQL Database but am unable to do so.

When I run the code below I get the following Error:

Msg 4860, Level 16, State 1, Line 4
Cannot bulk load. The file "C:\LOGS\access.2017.11.16.log" does not exist or you don't have file access rights.

Can I I Import all Files without checking for a date? 


(1 row affected)

Open in new window

     
/*****This is the share location of the log file in a variable*****/
DECLARE @FileLocation varchar(max)
SET @FileLocation = 'C:\LOGS\'

/*****This is the name of the start the file name in a variable********/
DECLARE @FileName varchar(max)
SET @FileName = 'access.'

/********This is the extention of the log file in a variable*******/
DECLARE @FileEXT varchar(4)
SET @FileEXT = '.log'

/*************This gets todays date in a variable*************/
Declare @date varchar(max)
set @date = (SELECT convert(varchar, getdate()-4, 102))

/********This puts all of the file share and info in one variable name************/
DECLARE @FilePath varchar(max)
Set @FilePath = @FileLocation + @FileName + @Date + @FileEXT

/*********** This is the SQL to insert and its written into a variable and executed************/
DECLARE @SQL nvarchar(max)

SET @SQL = N' use Downloads 
		   BULK 
		   INSERT BulkInsert 
		   FROM "' + @FilePath + 
		   '" WITH 
		   ( 
		   FIELDTERMINATOR = '','', 
		   ROWTERMINATOR = ''\n'')'
EXEC  sp_executesql @SQL


END

Open in new window

0
I have table in database "customer"
and this columns:
id, name, father_name, surname, adress
I want, in select box will be name (father_name) surname, and when I select that I want to autopopulate text input filed "adress". So, I need help with showing value in input field "adress". I use this to make drop down select box:

$link = dbConnect();
$query ="SELECT * FROM customer";
$result = mysqli_query($link,$query);

<select name="customer" >
    <?php while ($line = mysqli_fetch_array($result, MYSQL_ASSOC)): ?>
   <option value="<?php echo $line['ime'];?>" "><?php echo $line['ime'];?> <?php echo $line['surname'];?></option>  
   <?php endwhile; ?>
    </select>

Please help me with this, I try this from this link:
http://jsfiddle.net/d3htjbup/ but not success.
I put javascript in this tags: <script></script>

Thank you
0
The solution that Will gave me to auto start our Leads database so that employees won't have to do a File:OpenRemote, takes a long time after we upgraded from FM15 to 16.  I even recreated the database and created the table, fields, layout, and script from scratch and didn't save time.  The problem is that it takes so long to open (15 seconds?) that people click again and that hangs up FM.  It then never opens.
Start-FMNew.JPG
Start_Script.JPG
0
I have a database server that is about 4 years old.  we have a bunch of users that point their applications to this server.

the name of the server is    Alpha

We want to upgrade the sql server version from 2012 to 2016.   I think i would like to create a new server and do a clean install of sql server instead of doing an in-place upgrade.

So the new server would be bravo......  (if we do not do an in-place upgrade)
isn't it true that if i get the permissions right on bravo and restore all the databases on bravo.  that i could thereotically change the name of Alpha to lets say Alpha1 and then rename Bravo to Alpha that the users would not need any configuration changes.

Can someone please verify or send me to a document that outlines the best way to do this.
0
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Mailbox PropertiesI had my exchange server2010/SBS2011 crashed and had to perform Repair to be able to mount the mailbox database and I noticed Mailbox Index state "Failed".
How do I change "Content index state" to Healthy?

Thanks.
0
Hi All,
I am building an API in PHP which will take an email address and then turn it into a hash and then store that in a database.

However, the email address is called by other peoples servers using an API. Whats the best way too securely transfer the email address?

Sufficient to have the api use SSL?
0
Dear Experts,

MS SQL 2014 Enterprise

I am assisting my client to run the SQL replication.

However, there was a database that is configured to use DB restore with norecovery and restore with a differential backp.

I later accidentally ran the snapshot agent and now it keeps displaying "the replication agent has not logged a progress message in 10 minutes".

How can I set it back to "Never started"?
0
I have a parent form of movie volumes ("frmVolumes", home-recorded VCR movies), and one volume can have multiple programs (shown in "fsubPrograms", individual movies or TV shows).  Those link with no problem.  When the frmVolumes displays, the appropriate programs display in fsubPrograms, based on frmVolume's recordsource's primary key, which is a hidden field on frmVolumes.

However, I can't get another level of subform (fsubActors) to display appropriate actors based on the highlighted program's recordsource's primary key, which is a hidden field on fsubPrograms.  It looks like all actors are loading.

I think my problem lies in the order in which Access loads forms.  Rather than use form properties for link master and child fields, I am using SQL strings in the Form_Current event.  This is a new technique for me, but I have it working and understand it for one main form and one subform.  In my experience, the subform's recordsource is retrieved before the main form's recordsource.

Linking the subform to another yet a further subform seems to be the problem.  Another version of this database that does use form properties for linking does work properly, and I get the correct actors.  I have also tested the query to verify that it only brings back the actors I want.

Here are my queries, just for a validation.  Can someone explain what I need to do so that the three recordsources are loaded in the correct order?  Am I missing a Requery/Refresh/Repaint?

0
I have this password-protected .mdb database. There is a table I need to copy into a different non-protected mdb database. I need to perform this task using Borland Delphi 7 ADO components. help?
0
I'm interested in creating a Joomla extension for sending out user account activation emails. I need to know about the activation token.

The activation token appears to be hex code. The token generated when I registered my test account was 1c99b9e50f765fe8e25e2d6f8d328e78

Where does this code come from? Is it saved anywhere to the database, and/or is it created based upon info submitted by the user - or something else?

I need to know this so that I can generate it myself.

Thanks for any help!

Regards,
Jon
0
My app(Done with Delphi) uses a local MySql database in home netWork Environment. Several users can access my database  at the same time from within my home NetWork.
I wish be able to transfer my database to my WebSite so my database will be accessed from users from everywhere.
I have a website powered my Servage.net and have what I need to access my domain.
Please I need step by step directives in order  to transfer my database to my website. I am actually use MySql WorkBench!
Thanks in Advance
0
For handling business card information (Entering New, Editing, Deleting) I am creating small database in Access. 2010
Thinking about tables, fields and relationships (database schema) I am wondering should I create
One or more tables.
Option with several tables:
tblClient(Client_ID,Client_FName,Client_LName,Client_Title,Client_Position,Client_Picture,Bussiness_Name)
tblAddress(Adrress_ID, Adress_1, Address_2,City, Province_State, Country,
tblContact(Contact_ID,Business _Phone_Num,Business_Fax_Num, Cell_Phone_Num ,E_mail, Web_Site)

tblClient_Address(Client_ID,Address_ID)
tblClient_Contact(Client_ID,Contact_ID)

Or should I put all fields in one table?
Is the table structure ok should I add some more fileds(Entry_Date,Last_Time_Updated…?) and what is good approach?
0
I restored a SQL database on a new 2016 server (SQL standard 2016).  Database seems to run however something seems wrong.  The database is for a CRM program called "office tools".  I have attached screen shots.

I believe I should see the SQL instance in Sql Server Configuration Manager however it does not appear.
SQLa.JPG
SQLb.JPG
SQLc.JPG
0
NEW Veeam Backup for Microsoft Office 365 1.5
LVL 1
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

why we need junction table for many to many.

i am not clear on that concept. can you please elaborate with example tables with data?
i am going through below link but not completely clear
https://www.youtube.com/watch?v=P_nhBKs25DQ
please advise
0
I have a checklist of Items that I use will all my clients each quarter.  I want to design an access database to keep track of the check lists after each visit.

Need some thoughts on how to set up the tables - here is what I have so far:

- my check list has SECTIONS on top - under sections are CATEGORIES - under categories are QUESTIONS (y/n or NA answers & note area)

An Example would be:  SECTION = Firewall    then CATEGORIES = Installation    then QUESTION = Firmware updated?

There are 2 parts I need help with:

1) Need tables that store the Template Check list.  Then I can have a form that I can assign a client to the template and then turn on or off parts of the template if it doesn't apply to them.  I would save the modified template so I have a modified Checklist per each client.

2) I bring up that modified check list by client and have a form to answer the questions + have a comment section - then save the checklist by date after each visit.

Not sure where to start here - any advice would be greatly appreciated.

Thanks,
0
i got this msg when preview the report(cystal report 8.5) after i change the server n database SQL server 2012 express
0
I have this method that gets the connection string. I first have a method that builds the connection string. Then I open the connection and finally I try to execute a SQL stored procedure against this connection. As soon as I try to execute the sp I get the message "Connection property has not been initialized" What am I missing and how do I correct this?

        public static SqlConnection GetConnection(string ConnectionString)
        {
            /* Create and open a connection to the SQL Server */
            /* Return open connection object */
            SqlConnection SQLConn = new SqlConnection();

            string loginType = Properties.Settings.Default.SQLLogintype.ToUpper();

            try
            {
                if (loginType == "WINDOWS")
                {
                    SQLConn.ConnectionString = ConnectionStringWindows(ConnectionString);
                    SQLConn.Open();
                }
                if(loginType == "SQL")
                {
                    SQLConn.ConnectionString = ConnectionStringSQL(ConnectionString);
                    SQLConn.Open();
                }

                return SQLConn;
            }
            catch (Exception ex)
            {
                Log.Write("Failed to get SQL connection to the database " + Controller.Instance.Model.SQLDatabase + ": " + ex.Message);
                Log.Write(SQLConn.ConnectionString);
                throw ex;
            }

        }
0
Is it possible to modify a DataGridView and for columns that correspond to multiple values in a database table ... provide the values in a combo box control so the end user can select which value they want at runtime?  Along with this I am also wanting a way to update the datasource so that the selections are preserved in the DataGridView until they are committed to the database.

Looking for some great examples for doing this.

C# Windows Form application, not web.
0
I have a SQL 2012 Server with a 16GB database and the log file is almost 37GB.  I thought my nightly backups would truncate the old logs and maintain a reasonable sized log.  How can I reduce the size of it and manage it better?
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.