A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...

I have an application that makes use of 2 different database say A and B. I am working with A but using some datas as views from database B. How can I establish the connection with two database using Bridges?

My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange...

I am auditing a enterprise data warehouse and am concerned at the level of access provided. I've found many users who have read, update, and delete rights to all working environments (testing, QA, Production)

Hello, I explain my problem. I have 3 databases (CTS1, CTS2 and CTST) in multimaster replication. CTS1 and CTST first run without problem. CTS1 is master site definition. I have added master site CTS2 without quiescing replication. Now I have 3 master sites running. I have the following problem : A...

Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form's background color based simply on whether the record is...

We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

I use an Access program to record student records. The program has built in queries, but when I try to start one the popup window is tiny; all you see is border, no text, no restore or exit buttons. I can't catch an edge with the mouse to enlarge it. Also, the program opens without the toolbars I...

I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a "Effective Date" column. Please keep in mind that I am not well versed in macros. Thanx for any help,

Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL...

we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not...

i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work through...

Hi!! Good Morning. I have a simple question for you today. I intend to have a penetration testing done for all of my 3 sites - My US Office, My India Office & My US Datacenter. Can you suggest any trustworthy site which can offer me a free reliable scan? Also, I would like to have you suggestion on...

How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

Hi there, I'm a complete Access noob, but I need to figure something out! Is it possible to put more than one code in one field? For example I need to answer 500 letters. Each letter has a code say 01-500. In each letter there are 3 questions that need to be answered, but half of the questions in...

To follow this tag...

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