[microsoft:access] Forum Topics

When I try run my appliction on a client machine I keep getting the following error: Run-Time Error '20532 Cannot find database dll I know I need to install the 'database dll' on the clients machine ... but ... what is the database dll? I am using MS Access 2000 …

Hello I work in an accounts office where we have a filemaker pro database for all our contacts. We are having a new server and I'm wondering if the filemaker pro database would still operate with the new server. Would it still be compatible?

I need to calculate the difference between 2 Dates in Days according to the DayCount Rule 30/360 In Excel it is easy =Days360(StartDate, EndDate,1) 30/360 = every month = 30 days, the year =360 In MS-Access no problem as well, just in Filemaker I can not find a solution for …

I'm trying to import all data from an Access DB using Visual Basic 2005. I'm new to Access and so far I can only import one record at a time. Any help would be appreciated!! Here is the code I have so far (obviously to bring one record at a …

I have MS Office Pro on a work computer that we just tasked to a new job that requires MS Access. All of the other programs in MS Office open and work fine, but when I try to open Access (either by clicking directly on a file or by just …

I am currently trying to create a live search box that as I type it will start displaying results that match. Here is an example [URL="http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print"]http://www.w3schools.com/php/php_ajax_livesearch.asp?output=print[/URL] but it retrieves its data from an XML file, I need mine to retrieve from a column called FirstName within a table of an …

I Want To Search Date From .mdb Database file, Table Name is Purchase, and The Field is Purchase Date, its Type is DateTime and Formate is ShortDate in MS Access Database File, I Conceted it to Vb.net Form, and Tryed to Search Date, but it Returns Error. the Code to …

hi, any one here can helpe me, i'm search how i can make a connetion of data base with acces

dear all, Im new in C++ programming. Recently, im doing a login page using Microsoft Visual C++ 2010 Express and Microsoft Access as database. Im trying to connect ODBC to my system but there was a lot of error occur. Can somebody explain me what my problems... [B] This is …

i am using access db plz tell me how to insert data from database. m using visual studio 2010.

Hi Folks: The following is the complete coding for an application which I wrote to move data from sql 2000 to MS Access 2003. The coding looks fine to me but I am still getting an error. Could someone tell me what I am doing wrong. Thanks in advance Bob …

This is a logic question (or at least I think it is). What happens when the select term and group by term do not match? Why? The sample code is here: [CODE] SELECT [B]Name[/B], max(Age) FROM People GROUP BY [B]Name[/B][/CODE] So what happens if those two bolded field names do …

hi there, i am still facing the same problem with runtime error object canºt be found when trying to access ms access database remotely.i made the database in the wwwroot folder and give authority read write ,....the code is in the client side i am accessing a server that has …

Hi All, I need to run a report created in Access 2003 but I'm not sure how to go about that. If someone could point me in the right direction by telling me which reference(s) I need to add to my program that would be really helpful as well as …

[QUOTE=varunnanda;1173601]Thanks you very much, I am oblized.[/QUOTE] I'm very new to Grails, so hopefully this isn't blind leading blind! Below is the environment entries from my datasource.groovy dev works ok against memorydb prod works ok against MySQL running on a server with the noted IP address However, I can't get …

I have exported data from sql server to access but the views are exported as tables can you pls tell me how to convert sql server views to ms access 2003 queries please help...urgent

:unsure: I dont know y this happens...i try a lot of times but....anyways, the problem is that, the crystal report does not show the actual result when an sql query is being used to extract data, even from a single table...while it runs correcty in MS Access where i have …

im a beginner in visual basic 6.0 and ma teacher give me a project as below: evaluation of entrance examination system....so i hv fields std name, roll no and mark. according to the roll no i type and with criteria given(some cut off mark) the particular student information must pop …

Hi, i'm using .Net framework 1.0 & MS Access 2003 database. Using ODBC connection, I want to list all tables in ms access database in a listbox....Please help me.... very urgent...

I have created a database for a hotel booking & billing system, can't seem to stop from booking same room on sdame dates. Have indexed so that can't book in on the same day, but can still book the next day. Any clues?

Hello to all, Here i am doing a small project of a school timetabel development. i stuck at saving data from combobox to Ms-Access. I m using Adodc as data connector to vb and access. Please provide me coding for the same query. Thanks... Pooja Shah

myCommand.CommandText = "update Stutable set password as ('" & TextBox2.Text & "')"" where rollno = " & TextBox3.Text please can you tell me what is the error in the above statement iam using vb and access database

I"m new to this site so i"m not sure is this question has been answered before but i"ll ask it anyways. i have a simple small access database and i need to create a link between it and our website but i'm not sure how to go about it. what …

Hi i am using vb to make a hospital system which works with a access database i am having an issue with the updatign function to the database this time round instead of hard codding the connection i used the connection/data source wizard in microsoft visual studio 2008 and there …

hello can you please help me how do i put checkbox in my ms access..or how to code this in my program hoping for your positive responds...thank you in advance

Format of the connection string to access an ACCESS database in c# over network? I want to make a OleDbConnection in c# and connect it to an access database in another PC on my lan. This is an example of a connection string to connect to a database on my …

I AM USING MS ACCESS 2007 TO CONNECT TO A C# WINDOW APPLICATION BUT I GET AN ERROR SAYING THAT (An OLE DB Provider was not specified in the connection string. An example would be; 'Provider = SQLOLEDB;'). PLEASE ASSIST WHERE COULD I BE WRONG REGARDS

i want to know how to configure iis in order to access a remote microsoft access database in asp.net.permission how should it be,anonymous iis usrs,... any exact information pls thanks

Hi all, Did a site for a group I belong to. Now they want me to add a login page that would take people to a members only area. Need to be able to validate the users via a database. The only database I have available to me is Access …

I've created a game and want to record highscores through textboxes. I've thought using an Access database may be one idea but seems quite complicated at my level of programming. I'm looking for some ideas or an alternative to using access. If not then some way i could go about …

When using a small Access database, is it better to return the results of a query and search the result, or to try to filter the results in the query? I tried the latter first, like so: [CODE]<cfquery datasource="cpac" name="results"> SELECT Email FROM Subscribers WHERE Email='#FORM.Email#' </cfquery>[/CODE] and am puzzled …

Hi, I've got a input sheet where start and end dates are saved to a access database, I do have the access database dates field as Date/Time with a short date format. On my output page the start date's month and day are swapped but only if the actual day …

I want to write a complex piece of coding that will do several things: 1) It will clear the contents of a folder named "Cache". 2) It will open (if not already) Mozilla Thunderbird. 3) It will find the latest email that starts with a specific title. 4) It will …

Hi All, I have cut this down to a simple example. The access file has a table called rooms which contains a description field of type memo I want to load this into a dbmemo (delphi 7) I run this by a button onclick event [code] procedure TForm1.Button1Click(Sender: TObject); begin …

Hey all I currently am having trouble utilizing the oledbcommand method named parameter because I do not know how to use it properly :( Here is my class: [CODE]namespace CalendarApplicationLibrary { public class MeetingEntryDA { private const string CONNECTION_STRING = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Entry\entry.accdb;Persist Security Info=False;"; public void WriteDataToFile(MeetingEntry currentEntry) { OleDbConnection …

Hi, I would like to know how to put a small access database online and make it password protected. When accessed I would like the people concerned to be able to edit it and add information. Please can you tell me how and if this can be done. thanks richard

hi, i have Ms Access database having three fields ID username password and i want to make form that update them, my table name is studentLoginData [CODE] MessageBox.Show("the password is matched"); String conString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Documents and Settings\\Wasif\\My Documents\\studentLogin.mdb"; SqlConnection objConn = new SqlConnection(conString); try { objConn.Open(); } …

i am writing an application on my pc to insert record on a microsoft access database on another pc that has static ip address remotely.i can ping the remote address of the pc that i want to access without problems.the access database is in the folder c:\inetpub\wwwroot\db.mdb. i have the …

i write following code to update database but every time i got update syntax error is anyone help me to .. [CODE]MessageBox.Show("the password is matched"); String conString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Documents and Settings\\Wasif\\My Documents\\studentLogin.mdb"; OleDbConnection empConnection = new OleDbConnection(conString); String insertStatment = "UPDATE StudentLoginData Set ID='" + this.txt_id.Text + …

Hi, I'd appreciate if the experts here can recommend me a reliable and technical competent web hoster. My website is written in JSP and my database is Msaccess. A lot of web hoster is using Mysql. But, when I managed to create the MySQL database, I do not know how …

I'm using an access database to save plain textboxes. I've made a connection with the database. Now i need to find the code to add the textboxes to my database. I've tried to add with the bindingnavigator but it won't work... please help...

Could any one help me? :sad: I am a beginner in Visual basic. I recenly was testing one of the applications I developed and have a problem to run it. The application basicly is a database that I can add/remove/update...etc records and it uses a microsoft access database to connect …

I have been given a report that is generated by running the following query from a macro ( slightly edited to simplify )and I have not had a great deal of experience with Access. The report is grouped by Data.Type and sorted be Data.Date [ICODE][COLOR="Green"] SELECT DISTINCTROW Data.Type, Data.Date, Data.Code, …

The following is the complete coding for moving data from sql to access, I get an error saying that Microsoft JET Database Engine missing (;) at the end of sql statement!!!! Could you tell me what I am doing wrong? Imports System.Data.OleDb Imports System.Data.SqlClient Public Class frmMain Inherits System.Windows.Forms.Form Private …

hi every one, i make a application in C# visual studio that store username and passwords or students now i want to make a login form in c#. it is window form based application (GUI) not Cmd base:- my main objective is that first my application check that whether username …

Hi, I have the following code in my form. I would like to retrieve data from the MS Access database to ListView1. What will be the code? [CODE]Public Class frmContacts Dim inc As Integer Dim MaxRows As Integer Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da …

Ok so I'm a casual VB6 programmer and now I'm VBA for Access. In VBA I am trying to determine if whether an option button has been pressed. I used the 'Option1.Value' procedure yet it throws a 'You entered and expression that has no value' error. Here's my code: [CODE]Dim …

i want to know if i can access a microsoft access database remotely,if i have dynamic ip address but if i register in dyndns that gives me a domain name by updating my dynamic ip address each time i connect to internet.pls give me a sample only how can i …

hello all, I need assistance on MS Access 2007 database with C#, I have a form with many textboxes.. and i need to store these userfilled data to my database! and after that I need to see detail of any perticular item form database!!! please say how to do this...

I am working on updating a database where some measurements are stored as text. The updates I'm making are to let the engineers that use it convert their measurements into different units. Long story short, the numbers must be kept as text for a couple reasons that I won't go …