Using DTS I'm dynamically creating an access database. After the file is created (which works at this point) I'm having the DTS package post it via HTTP to another site. (This HTTP is just how it has to be done -- part of the spec.) But when the package posts the file, the posted version comes out as a 0 byte file. The code to post the ...
I've worked with MySQL and MSSQL for some time and have used a variety of CASE and UML tools when designing some of my more complex projects. I was recently asked by a colleague if I could provide an Access database for his department. The application itself isn't too complicated, and Access actually looks like the ideal tool for the ta...
I have a table, call it TBL. It has two columns,call them A and B. Now in the query I require one column as A and other column should be a comma seprated list of all B's which are against A in TBL. e.g. TBL is like this 1 Alpha 2 Beta 1 Gamma 1 Delta Result of query should be 1 Alpha,Gamma,Delta 2 Beta This type of ...
I have started making a database and I have an 'ordered item' and a 'invoice' table. I would like to find out how I would add up the prices of the items that the customer picks. As well where abouts do you put this 'rule' on the database. ...
Hi I have a database with a table which is full of conditions and error messages for checking another database. I want to run a loop such that each of these conditions is checked against all the tables in the second database and generae a report which gives the errors. Is this possible in ms access. For example, querycrit table id...
We don't need multiuser. Just relational. Our app currently uses Access but Access isn't exactly zero-administration because it's prone to corruption. Is SQLite rock, rock solid, pure zero-administration? Or...is there a way to configure SQL Server as a desktop engine so that it is pure zero admin? Or...is there some othe...
I have an access database with 3 tables. People Gifts PeopleGifts Using VS 2008, what is the quickest way to get a page up and running which allows me to run queries against these tables and do basic inserts. I want to have comboboxs bound to fields in the table so a user can click on a person and click on a gift and they click "A...
I am new to Access. I have a table full of records. I want to write a function to check if any id is null or empty. If so, I want to update it with xxxxx. The check for id must be run through all tables in a database. Can anyone provide some sample code? ...
I have a Visual Studio 2008 solution with two projects (a Word-Template project and a VB.Net console application for testing). Both projects reference a database project which opens a connection to an MS-Access 2007 database file and have references to System.Data.OleDb. In the database project I have a function which retrieves a data ...
I have a database table that i want to allow my friends to update. What is the quickest way to have a asp.net page that is simply a form that maps to every field in the database and allows for add, deletes, and updates. I assume there should be an out of the box solution for this without having to code up each control, etc . . ...
HI i have database with many tables. In the first table i have a field called status. table 1 idno name status 111 hjghf yes 225 hjgjj no 345 hgj yes other tables could have same idno with different fields. I want to check the status for each id no and if it is yes then for that id number in all ta...
I want to compare two ms-access .mdb files to check that the data they contain is same in both. Is there any tool or library exists for this type of comparison? ...
HI, I am trying to write a query in vba and to save its result in a report. I am a beginner. this is what i have tried can somebody correct me Dim cn As New ADODB.Connection, rs As New ADODB.Recordset Dim sql As String Set cn = CurrentProject.Connection sql = "Select * from table1 where empno is 0" rs.Open sql, cn While Not rs.EOF...
I would like to change the "Row Source" values in an Access table through code. This way I can filter what a user can choose in a column's combo box. ...
Is there any coding standard published by microsoft for vba applications? ...
I have two databases, one is an MS Access file, the other is a SQL Server database. I need to create a SELECT command that filters data from the SQL Server database based on the data in the Access database. What is the best way to accomplish this with ADO.NET? Can I pull the required data from each database into two new tables. Put thes...
How can I generate a report in access with the data from a recordset (instead of a query or table). I have updates to the recordset that also must be shown in the report. ...
Hello I have a problem, and was hoping I could rely on some of the experience here for advice and a push in the right direction. I have an MS Access file made by propietary software. I only want to take half the columns from this table, and import into new(not yet setup)mysql database. I have no idea how to do this or what the best way...
Hi, i connecting to a access database with php and adodb. Strings with characters like ® are saved in the database as ® . What can i do to store it correctly? ...
Hi Is it possible via code to programmatically (from .NET for example via SQL query) to ask an Access database if it is corrupt or have tables with corrupt rows in it? //Andy ...