-
Decimal places rounding to whole number
In my Access 2003 form values with decimal places are rounding to whole number. I've set the property to fixed formal with 2 decimal places and the problem continues.
-
Changing privileges for already created MySQL user
For MySQL, how can I change the privileges for already created users (not new users)? My company is running an audit on our database and we noticed that some people have more access than they should. Thanks!
-
Connecting C++ to MS Access database
How can I connect C++ to my MS Access Database? By the way, my database is Payroll system so all I need to do is make it connect to C++ and C++ will be the search engine for the employee/s names, salaries, deductions, bonus and whatever the payroll should have. So can anybody answer this?
Last updated: -
Delete all tables in SQL Server database?
How to delete all tables of a database in SQL Server?
Last updated: -
How can I setup an Ubuntu server for sending emails in PHP
Can someone help me with setting up an Ubuntu server? I have to send emails in PHP using the mail() function. I already have Apache, PHP and MySQL in my server. I appreciate the help.
-
Error message when running code to load data from Access database
Value of '-1' is not valid for 'Value'. 'Value' should be between 'minimum' and 'maximum'. Parameter name: Value. I'm getting this message when I was running the code to load data from Access database.
Last updated: -
Bind more than one IP address in MySQL
In MySQL, would there happen to be a way to bind two or more IP addresses? I need to use more than one IP address and the 'bind-address' in my.cnf won't work. Thanks!
Last updated: -
How to give DSum function with multiple condition in Microsoft Access Form? Value need to sum from Form.
Last updated: -
Copy MySQL usernames and passwords from one server to another
Over the past week, I've been setting up a new MySQL server for my work and I have to give it the same set of usernames and passwords from the previous server. Can I do a dump from the previous server and load it to my new server? Or is there another way?
Last updated: -
Backup schema in SQL Server 2005
Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!
Last updated: -
How do we work with SQL and what does it help in DBMS?
Last updated: -
How To create an CSV file in Mainframe (from Object star database)?
I have to create some extract from Object star tables, in CSV format.Please let me know if any utility or programe can be used.
Last updated: -
Corrupted log file on Exchange still needs to be restored.
How would you recover Exchange server when the log file is corrupted?
Last updated: -
How to change column name in MySQL
I need to change column name in MySQL. What should be the command for writing it?
Last updated: -
Run PHP script in AS/400 batch
We have an application on our AS/400 where we are passing changes to data down to a MYSQL DB on a server. Using a purchased product we have issues when passing large amounts of data, Were get JAVA heap dumps. So I am replacing this with a PHP process. The RPG code writes SQL statements to a file...
Last updated: -
Difference between logical join file vs. view
What is the difference between a Logical Join file and a view in DB2/400?
Last updated: -
.MB files Pardox message blobs
Hello hello! Does anyone know how to open a paradox .mb file? I got a converter for the DB files which are all Access tables now but the MB files are yet another puzzle.
Last updated: -
Can’t repair MyoVision Access database
One of my clients has a 130MB Access MDB which contains thermo image scans from an application called MyoVision. Recently, the database became corrupt and MyoVision is offering no support to fix it. What I'd like to attempt is Repair the database as it seems to be corrupted. Create a new MDB file...
Last updated: -
Configure on availability group for DBs
Can I configure on Availability Group for few DBs, and then mirror with synchronous automatic failover in same SQL instance? Would that be possible?
-
There are 2 tables: Cust_table and order_table, column in table 1: cust_id, name, location , age, marital status(single, married, widowed) Column in table 2: Order id, Cust_id, order amount, month of purchase Questions: In a month how many times does a person place orders? Find the monthly expenses...