Client has a bunch of Access databases and associated reports. He wants to make the reports available (live, not snapshots) via a secure extranet. He's willing to recreate the reports using a proprietary GUI if necessary, but ideally would like a solution that exports his reports "as is" to the web. Had a look at Caspio Bridge. It's p...
I want to gather some data from some tables of an Access Database, I've found some solutions online, but I haven't found ways to fill a datatable, or dataset, and get each single field properly. Is it easier for me to get whole tables then get just the info that i want, or should I make a lot of searches in the access DB getting just wh...
I'm a newbie at VBA and attempting to understand someone else's code. Set rstClone = Me.RecordsetClone rstClone.MoveFirst Why does the recordset have to be cloned? Why can't the code be Me.Recordset.MoveFirst? ...
I'm currently working on migrating an application from MS-Access to MS SQL Server. In the process, there are a few minor changes that I am making to the table layouts (I am splitting a few things up into more two tables), however, I would still like to keep all the data that is present in the database. What would be the best way to imp...
I made query that accepts two parameters. Now I want to use that query in the expressionbuilder for a textfield in a report. I want to pass the parameters in the expression. How do I do that? The code for the query in the expression is like [queryname]![returnfield]. ...
How can I add and retrieve images from Microsoft Access database and also retrieve them using C# WinForms? ...
I am trying to do the following but it does not work: SELECT TOP count(SELECT plot_details.[Design Code] FROM plot_details WHERE plot_details.[Design Code] = "ET2") CountOfET2.[CountOfPlot Number] bids.[Bid Amount], bids.[Design Code], bids.Username FROM bids ORDER BY bids.Username DESC; The query that provides the SELECT TOP value re...
I've recently made another question about connecting to MS-ACCESS database with .NET in C# or VB.NET. It worked just as intended with MDB, but with accdb it caused an exception in conn.Open(); which follows: Is there another way to do this? My original intention (like stated in the original question) is gathering some (actually, a ...
I have a database in .ACCDB format with some tables. I'm successfully loading it into an OleDbDataReader with the following code: string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;data source=C:\\marcelo.accdb"; OleDbConnection conn = new OleDbConnection(connectionString); string sql = "SELECT * FROM Clientes"; OleDbComma...
Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are. I specified those in the export file as a comma for a field delimiter and as the record delimiter. After I confirm this in word, I get...
Hey, I was wondering if it is possible to convert a wpf application to silverlight without days of work. Yes, i know there's a similar post, but dates from 2008, so outdated according to me because of the fast progress in silverlight. i have a wpf application that uses a 2003 access database (orders :)) and my client wants a silverlig...
Hi, I'm migration Access 2003 to 2007. There are a lot of linked table from Oracle. I create a ODBC point to Oracle instance, then in Access I link all table through ODBC. I use this code login, so the "Oracle ODBC Driver Connect" dialog box would not popup to ask password: strConnect = "ODBC;DATABASE=" & strFCPD & ";DSN=PBRIS;UID=...
I am developing a time sheets project, i am using mysql as database, i need to connect to MS access database and pull required data and sore it in mysql database. I have to do this automatically every 30 min. I was wondering if there is anyway i can do this using stored procedure or triggers. I am using java with spring,hibernate,and jsf...
where is query analyzer in Access Database?? please help me.. ...
Please help this would be my last problem in dealing with access database with vb.net if you could help me solve this. I'm trying to update ms access data using vb.net and here's my code: updateuserclass.vb Public Class UpdateUser Dim bankai As New Updater Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As S...
Hello, The software company I'm working for builds software for schools, and so our client machines are usually locked down in such a way it makes it pretty impossible for us to install anything on it. Our old system is primarily based on a (very large) MS Access project and so it gets around the access problems by just running from a...
What's wrong in here, I always get some nasty errors even if the same code that I used earlier works. But when I apply it to other form it gives me the error above. here's my code: Imports System.Data.OleDb Public Class Updater2 Public adminID As String Public adminName As String Public adminPass As String Private con A...
Hi guys, I've got a couple of colleagues who love Access and have lots of important business data in Access. I'm never going to persuade them to move the data to SharePoint 2010, nor am I going to have them move over to SharePoint. They're using Access, preferably even Access 2003, but I might persuade them to use 2007. This business d...
How secure is encryption in Access 2007? ...
For years, on 32-bit systems I have never had a problem. Why can't I use 64-bit Java ODBC driver with a Access database on Windows Server 2008? Is the ODBC driver on a 64-bit system written in 32-bit code or something? Here is the error I see, using a 64-bit JDK1.6.018 : java.sql.SQLException: [Microsoft][ODBC Driver Manager] The sp...