• Modifying a module in Access 2007

    I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2", acViewNormal,...

    Stewartie5 pointsBadges:
  • Importing Data GAL entries into Access 2007

    Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

    AGB25 pointsBadges:
  • PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables

    how to improve insert performance in insert into mis_fcr_all_txns_susp_temp (select * from mis_fcr_all_txns_combi a where exists (select acct_no from mis_fcr_all_txns_fraud3 b where a.acct_no = b.acct_no) and a.TXN_DATE BETWEEN (REPORT_DATE - 60) AND (REPORT_DATE - 30));

    031219805 pointsBadges:
  • MS access Program / module

    Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY...

    Imtiyaz725310 pointsBadges:
  • replication page

    how to stop the replication page from popping up in lotus notes where background replication is enabled

    Miscab15 pointsBadges:
  • Writing a specific query involving primary keys in SQL

    I need to write a query in SQL that will get the fifth-from-last record from my database when either a primary key is defined or no primary at all is defined. How would this query look?

    SQL Server Ask the Experts2,585 pointsBadges:
  • securing sql server database object

    I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

    Ipong40 pointsBadges:
  • Network Drop

    Hello, I am gowind to run a network drop using Cat 5E 350MHz CMR cable running from a guest house to the main house. The guest house has a Linksys router from which point i will run the Cat 5E around the outside of the house, drop down and burry in pvc pipe to main house, totaling roughly about 300...

    Thegeek5 pointsBadges:
  • Host Credentials

    whenever i use enterprise manager to perform backup or other functions on my laptops it usually requests for host credentials.whenever i give it my operating systems credentials it gives me an error message.what could be the problem?Nothing can be done with the enterprise manager without using the...

    Diamond105 pointsBadges:
  • Common User Interface SQL Serve Management Console

    Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?

    Jerry25 pointsBadges:
  • I need your input

    Howdy folks, I have the following set up: 2 Domain Controllers - Win2k3 Standard 1 member server with Exchange 2003 Standard 100 XP Pro workstations T1 connection Currently I use a sonicwall Pro 200 firewall, Symantec Corporate edition 10 AntiVirus, and Symanted Mail Security for Exchange....

    TheVyrys0 pointsBadges:
  • Time limit for use of Access application

    Dear Sir, I have created a access application. Now i want that user should be able to use it for 15 days only. After that the application should say that your trial period is expired and get closed. Eagerly waiting for your reply. Thanks, Sandip

    Ssandbhor10 pointsBadges:
  • Incremental Materialized View

    Can I create Materialized View in AS/400 iSeries, which I can refresh incrementally?

    Bhadresh25 pointsBadges:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • Access 2007 Report displaying the content of three different fields in one box?

    I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

    JustDave5 pointsBadges:
  • SQL Database Migration Process

    Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

    Absorbed5 pointsBadges:
  • Trigger statement

    sample trigger : create trigger trig_sample on table for insert,update as update table go now, the statement inside the trigger is to update the same table . will the trigger keeps on firing and thus cause and internal error??

    C114020 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • Need Help Importing Data

    Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and...

    Bluize20 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