[microsoft:access] Forum Topics

Hello, I am having issue connecting my Access database to my PHP site via ODBC. Here is what I am doing: <?php $dbName = "F:\Data\Web\_Home\TickSys\TickSys.accdb"; if (!file_exists($dbName)) { die("Could not find database file."); } print "Found DB File."; $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=$dbName; Uid=; Pwd=;"); ?> …

Hello All, I am working on an Access 2010 application. I would like to click on a command button and open a Adobe PDF document. The code for the On-Click event is: Set shell = CreateObject("WScript.Shell") shell.Run """C:\Program Files (x86)\Adobe\Reader 11.0\Reader\acrord32.exe"" SourceFile" When the Shell.Run line executes, Acrobat returns an …

I have a button which make it add data to accees database,but i want to another button which will make export data from access to excel. here is my button : try { string cmdText = "Insert INTO data(Name,Mail) Values(?,?)"; db_conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Alpozkanm\\Documents\\Visual Studio 2012\\WebSites\\IntegratedSubscribeSystem\\veri.accdb;Persist Security Info=False;"); OleDbCommand …

i am developing a project in c++ and i need database to save details.i googled but so far have bot come across a good tutorial for c++ database . most of the articles i have found are obsolete. please suggest what are APIs for database in c++?

how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ?

hi guys. so i have created a windows software app where it is a database driven application. i use ms access as back end db my problem now is i want to connect different computers which there is a server that holds the ms acces 2007 db and the application …

I am working on a project to create a front end in vb 2010 for an access database. It is adding the records in vb but not saving them in the database; this is the code i have so far: `Inline Code Example Here`Public Class Form2 Private Sub Button1_Click(ByVal sender …

Hello everyone, Can someone please tell me to how to connect MS-Access database using C. Are there any drivers or libraries that I would have to download? Please specify in detail. Regards, Rubeea

I have a table with the following fields: client, project number, project manager, project manager email I have a form with text fields for each field of the table and I want to have a query run when the user presses a button on the form. How to i make …

I have my outlook mailboxes in this structure mailbox1 -Inbox Mailbox2 -Inbox Current script is able to access Inbox of mailbox1 as it is my main mail box where as mailbox2 has been added into my profile. I want to be able to access Inbox of Mailbox2 import win32com.client import …

Hi Everyone, Wanted to share a bit on this subject as I've had to recently make some of these changes. Along my way I found a few sites that basically suggested moving all mailboxes off the database, dismount, delete and create a new database. Simple enough, however I didn't want …

Hi guys, I was wondering if it was possible to create a temporary table. I have a bunch of records to be added to the database.But before doing that i wanted to first put these records on a temporary table,same struture as the main table of course then after that …

Hi, I have a machine with Windows XP installed on it with the remote access enabled. Is it possible to access /log into it and control the PC from another machine with Fedora 8 on it? Thanks in advance...

Hi everyone , I am doing a log in& registration form. And i am using a adodb connection. can someone pls tell me what is wrong with my code on the rst.open part, and what should i replace. Im trying to call the password from ms access and suddenly there …

Dear all, I have a challenge here of understanding the page masks as used in this code; <? $access_level_map['loader'] = 1; $access_level_map['support'] = 3; $access_level_map['admin'] = 7; $access_level_map['superadmin'] = 15; define("LOAD_PAGE_MASK",1); define("SUPPORT_PAGE_MASK",2); define("ADMIN_PAGE_MASK",4); define("SUPER_ADMIN_PAGE_MASK",8); $pageMaskMap['add_employee.php'] = SUPPORT_PAGE_MASK; $pageMaskMap['awpdc.php'] = SUPPORT_PAGE_MASK; $pageMaskMap['awpdc_blocked.php'] = SUPPORT_PAGE_MASK; $pageMaskMap['awpdc_unblocked.php'] = SUPPORT_PAGE_MASK; ?> What I know …

Hi, I have problem going through database (im using microsoft access) tables with BindingNavigator. Basicly I want to have BindingNavigator which goues through database tables (not the table rows) in DataGridView. For example if i press next button on BindingNavigator, I want to see next table in the database. I …

I want access data randomly and i have write the code when i click the button then data is displayed but i want when i again click the button then the next row data is displayed. could you please tell i am stuck here past 15 days.please And when click …

can you make a c++ program and link it to a microsoft access database?

i have worked on standalone projects on vb but dont know how to debug server & client side database application whose front end is vb.net & back end is ms access. do i have to install vb.net on the server to debug the software or is there any other way …

The scenario was there should be any or multiple TextBox that is not empty and display it on the DataGridView. I think my SQL is incorrect. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Command1 As New OleDbCommand Dim i2 As Integer Dim sql1 As …

i connect my access to vb2010 using adodb. but i cant display the datas in my listview. can someone help me to solve my problem. i would really appreaciate any help. what i need is to get the column per column datas.. like how it is shown in the access. …

Why I can't update data in my database MSAccess? though, it's already working, but no changes. Pls help me... Here's my code for Update I have 10 Fields in my table Personaldata try { Records f1 = new Records(); BlockNo = textBox1.ToString(); LotNo = textBox2.ToString(); Numberofoccupants = textBox3.ToString(); Firstname = …

hi good day, i am having a problem about my program (VB 6.0) i want to save data from my program to the access database (mS Access 2003) the problem is that when i try to run the program, and click the button, theres an error about insert into syntax …

I'm having trouble connecting to a database file on another PC. In this case, my PC is the client. Using: 1. Windows 7 32-bit on both PC's. * Same Workgroup * Connection verified using cmd (PING) * Connected using hub (straight through) * Workgroup status: Joined 2. MS Access 2007 …

Im having difficulties in making a connection with my database. Can someone help me to resolve my problem. It says "Unrecognized database file format". I am using vb2010 ultimate and ms acess2013. :(

hello everyone. I am doing a program with c# DatabaseMicrosoftAcces And I got error Overflow. It points out in ExecuteQuery(); pls help me. Here's my code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace sad { public partial class …

Can someone help me in my source code... my problem is, i need to check if there is an existing record on my current database(ms access 2007) here is my connection that i've place on module Public con As ADODB.Connection Public rs As ADODB.Recordset Public Sub connection() con = New …

How can I insert splitted texts to my ms access database? I can't seem to find the logic in it. :( Please help me. Here are my codes: This is where i split the texts that are inputted in textBox1, textBox2, and textBox3 string items = textBox2.Text; string[] splittedText1 = …

I've got this error: **Additional information: Data type mismatch in criteria expression.** I don't know why.. I want to use split text in a textbox and insert the splitted texts to ms access. Here is my code: string[] splittedText1 = textBox2.Text.Split(' '); string[] splittedText2 = textBox1.Text.Split(' '); string[] splittedText3 = …

Hello, can somenone help me solve this problem? i try this code to insert my data into microssoft access 2013 database but when i insert, a new row is created with no data, someone can help me? this is my code for my save button, only date can insert. acsconn.Open() …

hey..my name is marluke.. i want to know the code of Save, Edit and Delete using visual basic 6 and the database is Ms Access does any body wants to help me? please i really want to know and learn visual basic.. thanks for helping LuKeZ

hi, can somebody help me? i am using visual basic 6.0 with microsoft access 2003 database i have a form that view the data from the database through the listview my problem is it says Compile Error: Method or data member not found heres my code Private Sub Form_Load() Dim …

Hi everyone, I am quite new to vb.net. Recently, I've been learning about Oledb commands and it's ability to save records in a form to a database. So, I started a project and now I am stuck. Here's the scenario: The form comprises of several comboboxes, a listview box and …

how do i link an ms access database to an htnl page 'syntax on how to go about it'

I have been using Maximizer for over 15 years. Not happy with direction company has taken, and would like to convert files to Access. Can this be done, and will it convert defined fields, documents, etc? How is the bes way to proceed?

Hi guys, I would need to create a form where by it will be using within a department for reading and writing of data into database. N in our department we do not have any internet access at all, from what i know we need to have a web server …

I'm newbie to C# so please bear with me for that issue and just to make the issue clear i'm gonna start from the very beginning of the My code What i wanted to do @ the beginning that i wanted to populate my comboBox from MS ACCESS database but …

This the error I am getting when I install VB application which is developed in VS 2010 with Access 2010 as backend error: ACEW OLEDB 12.0 not REGISTERED on local machine This appears to be faced by many people. I faced it first time when I installed similar project in …

Hi, I have some deals with this. I can't make this run. It says that "Microsoft.ACE.OLEDB 12.0 is not registered on the local machine". I tried with diferent providers, but still not running. I tried installing the Access Database Engine Driver, and the application seems that don't want to run. …

I am trying to convert access2.0 database to access2010. 2 days trying to recode this to run in access 2010 but no success. Global Const CONNECT_SQL = "ODBC;DSN=PCGINV;DATABASE=pcginv;UID=;PWD=" Global gqdfTemp As QueryDef Global grecSQL As Recordset Sub GetSQL(strSQL As String) On Error GoTo Err_GetSQL Dim db As Database Set db …

Hello, can anyone provide me with some sample code? VBA access. I need an insert into statement where form.control.value = some_column and another.form.control.combobox.value = some_column can anyone help? thanks

I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim …

Hello, I am attempting to make a section in my application where a user can enter their own code which will be executed at runtime. I have looked up how to compile and run Visual Basic code while the program is running (Below). Dim VBP As New VBCodeProvider Dim CVB …

Hi Dw I'm creating a registration page and log in page. I'm just planing on saving the data that the client will supply on the registration page and the log in page retrieve data which consist of password and username from the database to verify if the user is registered …

Hello, I need to start using databases with c++. I know in VB or VBA is simple and easy to find tutorials. I've done a lot of database apps in VBA and VB. I couldn't find help for c++, only for vc++. I use Code::Blocks and mingw. If anyone knows …

Friends I met with a problem...Please help I have a table 'Tran' in Access Database which has several fields of which one is 'Date' I added several records through programm on different dates.Everything OK. All the records appeared in a chronological way ie.Earlier to Later order . Later I deleted …

Friends...A small problem I have a combobox in which I want to add list from a field from a ACCESS databas Table.It works well My code is here ACRS.Open "SELECT * FROM Salary1", CN, adOpenStatic, adLockOptimistic Sfm = ACRS!Month Do Until ACRS.EOF CmbSfm.AddItem ACRS!Month ACRS.MoveNext Loop My problem is , …

Hi, I am working on a project. The project is running perfectly with no run-time errors on the development console. But when it was installed and executed on the test pc, I came across an error **(-2147217900 : The database engine could not lock table 'tablename' because it is already …

Hello friends..please help me I have two identical Tables in my Database (Access) Table 1.Salup , Table 2.Salup1 . All the fields are identical My problem is:- I want to copy/append 1. All the records 2. selected Records agreeing certain criteria(eg."Sex=Male") From Table 1 to Table 2. through VB6 code.I …

i am creating a software for using acceess database but not configuratuion please help me