ms-access

Chart on MS Access 2003 ADP report

What's the best method of displaying report data in a chart format in an Access 2003 ADP project? I know this can be done in normal MDBs but this seems to use a Jet Crosstab query behind the scenes and this is not available in the ADP. I've experimented with the Office 11 Chart control but this seems a bit hit and miss. ...

What are the maximum columns in an Access 2003 query?

What are the maximum allowed number of columns in a query in access 2003? ...

Creating Recordset in VBA wit SQL statement

I am trying to create a recordset in Access VBA that will show me all records in a table related to the current record of a form. My current code looks like this: Private Sub Form_Load() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("Select [ID], [Ln] From [Order Detail] Where ((([Order Detail].[ID]) = [Forms]![Order...

How to determine MS Access field size via OleDb

The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE statement is working fine. But I would ...

LINQ asp.net page against MS Access . .

I have a ASP.Net page using ADO to query MS access database and as a learning exercise i would like to incorporate LINQ. I have one simple table called Quotes. The fields are: QuoteID, QuoteDescription, QuoteAuthor, QuoteDate. I would like to run simple queries like, "Give me all quotes after 1995". How would i incorporate LINQ int...

Extracting Source Code from an MS Access DB

Hi, I have an Access DB that I would like to extract the source code from so I can put it into Source control. I have tried to extract the data using the Primary Interop Assemblies(PIA), but I am getting issues as it is not picking up all of the modules and forms. There are 140 Forms and Modules in the code(Don't ask, it's a legacy ...

Escaping ' in Access SQL

I'm trying to do a domain lookup in vba with something like this: DLookup("island", "villages", "village = '" & txtVillage & "'") This works fine until txtVillage is something like Dillon's Bay, when the apostrophe is taken to be a single quote, and I get a run-time error. I've written a trivial function that escapes single quotes - ...

How to get table names from access?

INORMATION_SCHEMA table does not exist in an access database :( ...

How to use sftp from within an MS Access database module?

I have a requirement to create a simple database in Access to collect some user data that will be loaded into another database for further reporting. There will be a module in the Access db that when invoked by the user (probably by clicking a button) will output a query to a delimited file. The user also needs a mechanism (for example...

MS Access query design hangs on connection to SQL Server

Microsoft Access is a slick way to access data in a MS SQL Server backend database, but I've always had problems accessing (so to speak) large tables of data, especially when trying to toggle between results and design mode in Access. Access gives me a number of nifty things, not the least of which is Crosstabs, but this hung connection...

MS-access reports - The search key was not found in any record - on save

Occasionally my MS Access reports: The search key was not found in any record After this happens the solution is to close Access, compact and repair the backend and then delete the record. What causes this and how can I avoid it? ...

LoadfromText gives error 2285 (Microsoft Office Access can't create the output file)

When importing forms in access using loadfromtext, I continually get a runtime error 2285. Searching the internet shows many people with the same problem, yet no solutions. Does anyone know what causes this bug? Edit: In addition a file called 'errors.txt' is created in the folder containing the database. Edit: Sort of solution: I neve...

ODBC x64 oracle problem

I have a workstation with Windows 2008 x64, MS Access 2007 and Oracle 11g x64 I use Access to connect to Oracle via ODBC. I am the administrator (in the administrator group) on the workstation. I run Access as administrator but when I want to make an ODBC call to Oracle it does not work. How do I do it: I start MS Access and creates a d...

VBA script for auto resizing of controls/subforms in MS Access 2003 forms?

Since Access 2003 doesn't have the control anchoring functionality as exists in 2007, I was wondering if anyone has or is aware of some VBA script, or a freeware control, that can give this functionality? ...

Using MS Access to return on-demand reports in a web server?

I have built a MS Access 2007 application that can create reports files in various formats (PDF, XLS, CSV, XML). I would like to allow the creation of these reports to be accessible from a web page where users would just click on a link and get a download of the report produced by my Access application. I would like to keep it simple an...

access to SQL copy

Hi Guys We have an Access DB which has a set of local tables and input forms etc. in which a user maintains their data. We also have a SQL DB with the same tables which is used to displays the data in a web search form. What is the best way to allow the user to udate his changes to the SQL db while keeping the working copy local so he...

Updating Access 2003 to 2007, potential issues?

Hi all, I've written an Access 2003 application to handle internal things at my company over the past couple years and we are talking about upgrading all of our computers to Office 2007 which means Access will be updated. Is this going to cause a problem for me? ...

How to refresh an access form

I am building an MS Access application in which all the forms are modal. However, after data change in a form, I want to refresh the parent form of this form with newer data. Is there any way to do it. To elaborate further : Consider there are two forms, Form A and Form B. Both are modal form. From Form A, I initiate Form B, and now For...

Microsoft Access query seen as a Function or View by Visual Studio 2005

I have a Microsoft Access database query that I'm trying to import into a Visual Studio 2005 dataset. When the query is formed using an NZ() function like this: SELECT NZ(tblComponentSpecs.nPurchaseCostQuantity, 0) AS Quantity FROM tblComponentSpecs; it appears under the Functions list in the Data Connection. However, when the query...

SQL Query - Using Order By in UNION

How can one programmatically sort a union query when pulling data from two tables? For example, SELECT table1.field1 FROM table1 ORDER BY table1.field1 UNION SELECT table2.field1 FROM table2 ORDER BY table2.field1 Throws an exception Note: this is be attempted on MS Access Jet database engine ...