• Creating an Access 2007 query with results similiar to a Crosstab query

    I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each...

    mjp126215 pointsBadges:
  • Placing fields on specific page in Access form

    I have a Client Form which includes three separate pages. I am trying to add 2 new fields. I have added the fields to the Client table but when I add them to the form, they show up on all three pages of the form. How do I "anchor" the fields to one particular page?

    lfenlon5 pointsBadges:
  • HIPAA Compliant Architecture

    Hi,I am developing a Medical Billing Software and should be HIPAA complaint. My current architecture is using seperate database for each tenant. But I need to change it to a Multi tenant architecture. So Is there any problem for HIPAA with Multi tenant architecture ? Is it possible to get any...

    rinshad555 pointsBadges:
  • Operating Console

    Hi I have operations console running on a laptop which is directly connected to my I-Series. All runs okay until the laptop powers down(for variety of reasons), when i power it on again it will not connect to the I-Series without doing an IPL of the I-Series. I get the message "Connecting Console"...

    Hazermark0 pointsBadges:
  • How to know that the access list is working

    What command can I use to show that the access control list (ACL) is working?

    NetworkingATE1,545 pointsBadges:
  • Available space in a MYSQL database

    I need to find how much space I have available in a MYSQL database. I think the best way to do so is via SHOW TABLE STATUS LIKE 'table_name' When I do that, I get the following: Name | Rows | Avg. Row Length | Data_Length | Index Length ---------- ---- --------------- ----------- ------------...

    ITKE344,850 pointsBadges:
  • Use of LOB Pointer within specific entry data of QjoRetrieveJournalEntries

    Hello, I want to read data using the LOB pointer retrieves in journal entry. I see the pointer in the layout of the LOB columns but when I convert the 16 bytes into pointer variable (16 bytes holding a pointer to the LOB data according to documentation), the converted pointer is null and unusable....

    gincap5 pointsBadges:
  • Should I use MEDIUMBLOB to store large files in MySQL database?

    I need to store user uploaded files to our database (and I can't use a file system). The files are all different types and I'm running into a problem deciding if I should use "MEDIUMBLOB" to store these as binary data. And this problem arises from the files having various file sizes. I understand I...

    ITKE344,850 pointsBadges:
  • How can I store large hashes in MySQL?

    I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose. I know I could split them up using eight...

    ITKE344,850 pointsBadges:
  • Creating a report in Access 2007

    I have a table in an Access 2007 database that contains the following fields: Emp. Name, Date Worked, a Yes/No field showing Paperwork received and a Yes/No field showing Paperwork Returned. I am trying to create a report that will be run for a selected month that has each day of the month as a...

    mjp126215 pointsBadges:
  • What’s the posting limit for client-side storage?

    Does anyone know if the posting limits for client-side storage are still correct? I've seen that for LocalStorage, the sizes are 5MB SQLite storage and another 5MB is expandable by a user's request. Also, are these storage schemes exclusive? I mean is this limit an aggregate of all client-side...

    ITKE344,850 pointsBadges:
  • MySQL: What’s the downside of storing images in the database?

    I'm looking at using MySQL for my database so I need some opinions on the disadvantages of storing images inside of it. Is it not as efficient as storing images on a server? Does it take longer for the images to download vs. disk storage? Thanks for all the input!

    ITKE344,850 pointsBadges:
  • Active Directory restore problem

    Dear All, I have a machine1 on which the Operating System is Microsoft Windows Server 2003 Enterprise Edition (Service Pack 2). This is the Domain Controller on which Microsoft Exchange 2003 is installed. I want to perform backup of this machine1 using VSS (application specific writers for AD and...

    Dkk70 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE344,850 pointsBadges:
  • What factors are there for MySQL database size estimation?

    We have an application database (which includes a table for users). Here's the setup: 1Kbyte of data per user that's based on counting fields * typelength and about 100 things of the same size that belongs to a user (about 0.5 Kbyte). This leads to around 51 Kbytes of data per user. Now, we're...

    ITKE344,850 pointsBadges:
  • How to search for Access 2003 record using VB6

    How can I search for the last updated record in my Access 2003 database from VB 6, the code I'm using only returns the first record on the database. On Error GoTo err: Dim sql As String Set con = New ADODB.Connection con.CursorLocation = adUseClient con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data...

    Josemw10 pointsBadges:
  • Create a form/subform in Access 2007 that displays multiple records to be updated.

    I have an Access 2007 database that has 2 tables: 1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at. 2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork...

    mjp126215 pointsBadges:
  • Can I use a Linksys print server as a bridge or access point?

    Can I use a Linksys print server as a bridge or access point?  I want to use it to connect a VoIP phone.

    4jbshere5 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 pointsBadges:
  • What’s the best option for storing graphs in persistent storage?

    I'm wondering what would be the best way for me to store my graphs in persistent storage (for analysis, search, clustering, etc.). I'm considering NEO4J but I'm looking what other options are available to me. Would Cassandra or MySQL work for me? Thanks for the help.

    ITKE344,850 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following