• Capture SQL Server logged in db User name in Access 2007 Accdb

    I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

    Ppeterso15 pointsBadges:
  • Access 2007 on an Xserve Server

    Is this possible to take a MS Access Db and run it on the Xserve Server

    DarrylH5 pointsBadges:
  • Function to find greatest numeric value across different fields

    In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

    Kevling5 pointsBadges:
  • Lotus Approach and File Maker Advance Pro 10.0.3

    Can anyone help me on how to migrate or import/export or open Ms Excel using these softwares Lotus Approach 2000 and File Maker Advance Pro 10.0.3 please thanks

    Nilo15 pointsBadges:
  • Migrating C code db acess from sybase to sql server 2005 – newbie

    I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

    0949595 pointsBadges:
  • Cisco Access Control Lists – Recommended default template?

    Hey guys! I was hoping to find a default access control list template that you may use to block off, reserved addresses, known worms, viruses, vulnerabilities when you are setting up a new router? Trying to think of every possible threat is impossible but a good recommended starting point for...

    Tkrn10 pointsBadges:
  • Advance database menagement system

    How I secure my data

  • Multiple DELETE From Statements in Query Manager

    How do I enter more than one Delete from ...... where .. Statement from within Query Manager?

    Pb5410 pointsBadges:
  • AS/400 SQL BLOBS

    I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible?

    Newsqluser25 pointsBadges:
  • Access & iSeries AS400 Tbl and Query Issues Error Code 5001

    I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the...

    CompEng1,240 pointsBadges:
  • DB2 connection in VBscript

    I need to delete some records from a DB2 database on an AS400 using VBscript.

    Larksys5 pointsBadges:
  • We are runing V5R1 OS400, how do I write to CSV file

    We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

    Proy5 pointsBadges:
  • Why won’t my Access subform stay put?

    Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5" from the top. When I click a button, it becomes visible and 0" from the top. When I double click the button, the subform is supposed to go back to being invisible and 5" from the top. For some reason,...

    Dataempress115 pointsBadges:
  • Access Query – Repeating fields

    I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this

    Dash145 pointsBadges:
  • Modify MS Access using iSeries RPGLE

    I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

    wkozerski20 pointsBadges:
  • Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files

    Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...

    CompEng1,240 pointsBadges:
  • ACCESS 2007 and SQL Server 2005 Schema Updates

    We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

    NHSNick30 pointsBadges:
  • IBMDB2 runtime issues with HP 2730p laptop

    When displaying catalogue with IBM DB2 Runtime, a blank display appears.  It will not display the command windowl  This problem occurs only with the HP 2730p Tablet.

    Jmonroe700ing10 pointsBadges:
  • Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 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.

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