Hi all, I am creating a simple C# CMS system using a Microsoft Access database This is my connection string in the web.config file <add name="VirtualCMSConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|ASPNetDB.mdb" providerName="System.Data.OleDB"/> I have used the "Access Provider" mo...
Hi I am new to Access and i am in the process of creating a database for some of our users. I have designed a form where the user name, first and last name etc are inputted. Some of these users work for more than one department which means I need some type of listbox control that allows them to select more than one department when they ...
I have multiple combo and option boxes whose visibility is set true or false depending on user selection of other parent option boxes. I am using the AfterUpdate() function for the parent option boxes. This method has been working fine. However when I set the values of the option boxes in VBA code (Me.MyOptionBox = 1), there is no "...
Hi, I am looking for some good tutorials on building complex forms in Access. In particular, how to get one ComboBox to populate with values based on the selection in another ComboBox. Cheers! ...
Say I have a form on which a number of buttons exist. Everything works as it should when the buttons are clicked. How do I go about assigning keyboard shortcuts to my buttons so that Alt+A runs the action of Button A, Alt+B runs the action of button B etc. seems like this would be trivial to do but I've not been able to see where I can ...
I understand the maximum number of fields in a MS-Access form is 255. Is there any way to get around this limitation? I am working with a mental health survey form that has approximately 400 fields. I would like to create 1 data entry form to allow the mental health interviewer to enter all the responses on the one form. I plan to us...
I have a spreadsheet that I am converting to an Access DB. I have a column of typed out customer names that I want to replace with the appropriate customer number from our accounting system. I have created a table with the customer info, and a query that shows what ID needs to be inserted into the source data. What I'm looking for is:...
I use an Access database used just as back end. I use some Memo Fields. I have learnt that Memo Fields are subject to cause database corruption because they are stored in a separate data page; the record only holds a pointer to the data page where the actual data is stored. Most of the time I just need from 100 to 1000 chars or so, so ...
I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program. The Microsoft Access database comes from a third-party; I am only reading the data. I have generally been having success in extracting the data I need, but I recently noticed some discrepancies. I have boiled it down to ...
At work we have Windows Server 2003. In my access database, I need to link to the user / group data so that it can populate a drop-down list and can thus be associated with database records. Does anyone know how to do this? Thanks, Chris ...
I have a table that contains, among other things, about 30 columns of boolean flags that denote particular attributes. I'd like to return them, sorted by frequency, as a recordset along with their column names, like so: Attribute Count attrib9 43 attrib13 27 attrib19 21 etc. My efforts thus far can achieve something...
I'm trying to trim extraneous white space at the end of a memo field in MS Access. I've tried doing it a number of ways: 1) an update query with the field being updated to Trim([fieldname]). For some reason, that doesn't do anything. The whitespace is still there. 2) an update using a Macro function in which the field contents are p...
Short version of question: How can I author custom controls for MS Access 2003 without resorting to VB6 ? Long Version: I have been spoiled with the pleasure of writing C# WinForms apps for the past 6 years and now I have to modify an Access 2003 application. Yes, it will eventually be rewritten as a Dot Net app, but for now, it mu...
Hi guys, i have a mdb access which is password protected but that can be easily cracked by a free tool found in google within like 1second. Besides paying for some expensive tools, is there a good way in how to protect a ms access databse file? I'm thinking of encrypting it then via a dll to decrypt it, get some data, and pass it to a th...
I'm using ADO to save data to an MS Access database. It was taking quite a while to save the data to file (about 7 seconds - which is too long for our purposes). I looked at the number of SQL queries being run, and it's about 4200; although there isn't a whole heap of data. The database connection seems to be the bottleneck. Do you know...
Each time I have to copy a query from MSAccess from a control's [record source] property and paste in notepad to align it just so I can read it. I once used Ctrl+R to replace commas with newline characters but now forgot what the newline character is. Have you used this before, if so how can I get the newline character? Better yet, i...
I use Partition function lot for Report in MS Access 2003. I need equivalent of this function for MS SQL. Here is link about Partition function http://office.microsoft.com/en-us/access/HA012288921033.aspx (registration required) Thanks ...
Hello, I am currently working on a VB.NET desktop application that uses .mdb (Access) database files on the backend. The .mdb files are opened and edited in the VB.NET app. Once editing is completed, the users will need to import the data into our SQL Server database. This is an easy task, until you try to introduce the dynamic filepat...
I am having trouble automating Access 2007 from .Net, either VB or C#. All I want to do is call a subroutine in an Access module from .Net. Ultimately, I have to make it work in VB, but I've been trying both with the same results. Below is the code in my VB test form. It results in the error: System.Runtime.InteropServices.COMExceptio...
Hi, I'm trying to use to different methods of connecting to a database to edit data, the declaration below is working: Dim rsConn As ADODB.Connection rsConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ & Application.StartupPath & "\VFMS_DB.mdb;" _ & "Jet OLEDB:System Database=Security.mdw", "Ads", "1234") but now I want t...