How to connect "Database" with Turbo C++?
I want to connect "Microsoft Access" with "Turbo C++". How can I do that? ...
ms-access
How to add zeros in front of a text field in an access table.
Hi, I have an access table with a text field. It has alpha numeric values. But i want all values to be minimum 3 digit. so i want to add zeroes in front of all single or two digit values . 5 must become 005 89 must become 089 how do i write a query to update all values in the table. thanks tksy ...
How to Use Variables in Access SQL Queries
Hi I'm working on a project which requires I use a large number of columns in my Access SQL queries. A typical query contains several fields such as the one below: SELECT ([Score1]+[Score2]+[Score3])*.5 AS [Scores], [Subject] FROM [ScoresTable] WHERE ([Score1]+[Score2]+[Score3])*.5 > 500 Is there any way to assign the value of ([Score...
Update value from a select statement
Hi there, I'm using an Access over Oracle database system (Basically using Access for the forms and getting into the tables using ADO code) and am trying to update a field in the product table with the value of the same named field in a load table. The code I am using is: .CommandText = "UPDATE " & strSchema & ".TBL_CAPITAL_MGMT_PRODUC...
Web-based equivalent of OpenOffice.org Base or Microsoft Access?
Hi, I've currently been using Base/MS Access to create forms etc. that interface with a backend database, to save me writing a backend in PHP. Downside is that it only runs on the desktop. Is anyone aware of any web-based equivalent? Edit: Should have done more research, I need it to interact with MySQL, not an Access DB. ...
solution needed - 2 users running a program
Hi guys, So I've developed this Access 2007 application with about 2 forms, a lot of VBA code and a bunch of tables. Now the business wants to run this off a network drive (call it G:\ for example). My current solution (which I've already implemented is have a table similar to: __________________ |Setting | Value | =================...
How to specify dynamically the 'To:' field into a SendObject within a Macro in MS Access 2003?
Hello, I'm using a form where I have one control/textbox which get populated from a query. I also have a button which launches a Macro, sending an email with an attached file. My problem is that I want to set the value of the "To:" field within the SendObject with the value which is in the textbox in my form. See enclosed the screensh...
Disconnect All Open Connections to MS Access Database
I need to perform a Compact and Repair operation on an Access database. In order to do that, all open connections to the database need to be closed. Unfortunately there are open connections that I can't always necessarily trace down and close properly. Is there a way to disconnect all open connections through code? ...
Access not allowing users to delete rows
I've got a problem with being able to delete rows of data in a form (for example, if I need to delete a row that I just duplicated, I can't do it). Here's a little bit about my database. I have three different habitats (forest, wetland, grassland) and each habitat has its own data entry form for entering a list of the species encounter...
Help deploying C# application connected to an Access database
I made a small application that connects to an Access database (a .mdb file). Do other users who want to use my application also need to have Microsoft Access installed? If this is the case, are there ways to get around this requirement through the user installing some free package? I've researched this for a while and can't seem to get...
How do I make a stored procedure in MS Access?
How do I make a stored procedure in MS Access? ...
Which affects Access Database performance more: Thousands of tables or Millions of records?
We're using an Access Database as the back-end to our software product. The program has been alpha/beta tested at a company for about 2 years now and we've noted that one of our tables has been filled with over a hundred thousand records in that time. This is probably not an example of the heaviest usage that our product will endure, an...
The operation on the OLE object failed The OLE server may not be registered. To register the OLE Server, reinstall it.
Hi, I am using MSAccess 2003 for my application. When I am trying to access PDF ActiveX control, an error message is displaying as follows The operation on the OLE object failed. The OLE server may not be registered. To register the OLE Server, reinstall it. I tried reinstalling MSOffice, but that did not work. Can anyone help me ...
MS Access 2007 Converting forms into sub form - "form not found" issue
So I recently have been trying to incorporate more sub forms to make the UI more friendly. So I have a pre developed form that runs some VB, so for examples sake lets just say that it runs SQL statement, returns the recordset, and fills text boxes with the data (because this is sort of an interactive dashboard concept: dim db as databas...
Ms-Access: any need to have a low size for variable-length text fields
In an Ms-Access MDB, will it save disk space to limit the size of variable-length text fields? eg. If I have a variable-length Text field of size 20 and all the actual values of the field are under 10 characters, am I wasting space? Would it be better to set the size of the field to 10, or does it not make any difference? ...
Getting Excel Data Into Access
Hi I have to get the data in an Excel sheet into a Access database. The datastructures of the Excel sheet and the Access database are very different, so a lot of reformatting/restructuring has to be done. So I like to use VBA to import the data. I know that I can open the sheet in an Excel instance from VBA, then reading, converting and...
OLEDB connection to Access not working; "Data source name not found and no default driver specified"
I am trying to retreive data from the Access Database from my ASP.Net application. It works when I access one table for an ExecuteScalar. but in the following code I get this error; Data source name not found and no default driver specified private static string GetConnectionString() { string importFolder = HttpContext.Current.Serv...
Access DB table refresh
I have an Access DB that is linked to Sage X3 Sales Order table. I get the information form the source but cannot seem to have it refresh when I go back in it. I have hit refresh, I have tried and apend Query etc.. but can not get the table to bring in latest information. What am I doing wrong? I have used Access before and I am rusty....
OLEdbcommand.Prepare error
I am getting an error: OleDbCommand.Prepare method requires all parameters to have an explicitly set type. on the last line of the code below. I have seen things saying you have to set the datatype of each parameter but how can i do that when it being generated by the command builder? I have seen people say they dont like using autoge...
How to change Access form listbox query
I have a listbox with this query: SELECT [350PressProduction].ID, [350PressProduction].ContinuationOfID, [350PressProduction].RunDate, [350PressProduction].ProdLength, [350PressProduction].ProdWeight FROM 350PressProduction WHERE ((([350PressProduction].RunDate)=#4/15/2010#)); How do I change that query so the date in the WHERE claus...