[microsoft:access] Forum Topics

Hi friends..... anybody help me how to connect access database with vb.net.

hello, i am new in web developing , i want to develop a web sites in which when i will click a link or menu item i want to open a page , which will ask a question such as pls enter telephone no. to search , then it will …

Hello, i am new to this site, i hope you can help me. i am trying to fix a computer for some relatives, where one the the 5-6 svchost.exe is using 100ish % cpu power for no reason it seems. ive used process explorer to narrow it down to a …

I have created a simple online form using Access with ColdFusion using Dreamweaver. It works perfectly while my testing server is on my computer but when I upload it to the server it comes up with error message: [B]'Error Executing Database Query. [/B] [COLOR=black][Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] …

Here is my hjt log.... Logfile of HijackThis v1.99.1 Scan saved at 5:11:33 PM, on 10/25/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\spoolsv.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\Ati2evxx.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgcc.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgemc.exe C:\Program Files\Java\jre1.5.0_06\bin\jusched.exe C:\Program Files\LimeWire\LimeWire.exe C:\Program Files\Windows …

Hi All, I'm trying get access to a Firebird BLOB field. I have linked the input table using ODBC(FB 1.5). I have tried to extract the blob content various ways, so far unsuccessfully. Is there any way I could declare the BLOB_get, BLOB_open FBCLIENT.DLL functions in MSAccess code module? If …

[B][B][B]Re: shortcuts and programs dont work.[/B][/B][/B] Newbie, Please be gentle. I Have the same problem [B][Moderator's note: Post split from [URL="http://www.daniweb.com/techtalkforums/post168055.html#post168055"]this thread[/URL]][/B] here's my log Logfile of HijackThis v1.99.1 Scan saved at 4:39:39 PM, on 10/20/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: …

Hi - I need some advice on how to force web controls to update. I have built a custom header and footer as two separate web controls, and have added them to the Toolbox. I can then drag and drop them onto any aspx web page. All has been going …

Hi ,I work with vb.net 2005 . I want to know if I want to connet to data base with Ms Access which data source i can use (ODBC or OLEDB) I write the following code in form load event (by OLEDB) : [COLOR=#0000ff]Dim[/COLOR] conn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDb.OleDbConnection([COLOR=#800000]"Jet OLEDB:Global Partial …

I'm new to Access to excuse me if this is a dumb question.... I am trying to set up a table of estimates. my boss wants the numbering to be A1-101, A1-102, etc. how can i set it to do this automatically? thanks anyone, everyone

The following SQL results in an "invalid procedure call" message. SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1 where (((ViewtimeHCPick1WRes1.X)>2)); SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1; works fine. ViewtimeHCPick1WRes1 is a query. X is a calculated field that results in a number of format x.y or x. Any suggestions as to why the where clause is …

Hi, I'm trying to use a Do Loop to look at 2 seperate tables. It needs to check the value in one field on the first table. If it finds a "T" it should look to a field in the other table and count down 3 rows. Then it needs …

am trying to delete a record but I have this message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ProductID = , 1567'. /salem/pages/fresh_food/TMP3rfr35u5pa.ASP, line 74 I looked at the meaning but so far I can't see that …

First of all i'm a newbie so bear with me... I have created a form in which people submit a phonebumebr to a database, curently if they put a space in there it throws up an error. I have been told that : Never insert unsanitized data into your database. …

Dear Guys, I developed one application using Microsoft Access2003, I use to MDB file, one is time_db.mdb and time.mdb and link these two databases. I put my time_db.mdb in the shared folder [URL="file://\\avss-srv"]\\avss-srv[/URL] and install the time.mdb in the client pc. The time.mdb is reading the database from time_db.mdb. When …

hello everybody; [COLOR="Red"]this is my code [/COLOR] [CODE]<% Dim sqlstring dim objConn set objConn = server.CreateObject("ADODB.Connection") 'objConn.ConnectionString ="DSN=ostad.dsn" objConn.open("ostad") sqlstring = "SELECT * FROM ostad" If Request.Form("TypeSearch") = "lname" Then sqlstring = sqlstring & " WHERE lname LIKE '%"& Request.Form("DaInBox") & "%'" End If If Request.Form("TypeSearch") = "skill" Then sqlstring …

Hello, I am very new to ASP and have been taught by one of my colleagues that I could leverage Dreamweaver (i have version 8) to create ASPx pages that collaborate with Microsoft Access -- to implement a webpage that displays, as I would like to call it, news snippets …

I have this thing in my registry thats very hard to remove and is called jkkhi.dll. it looks like a BHO... Also, i dont no if it has anything to do with the fact that i get a message right after every time i log on to windows XP...it says …

How do we go about doing a query under SQL server? And can i actually use the form in access to link to the tables on SQL server? Please advise. Thanks.

Actually i want to retrieve the Microsoft Access Database from the Internet Server using web services in Vb.net application, so how to write a web service for that. i don't know anything about web services, anybody can help me about that

Hey all, I decided to do a Google search to find a good forum to meet others in the IT world, so here I am. I'm pretty much a forum newbie, although I've been an on/off lurker on other forums around the net: dvdtalk, anandtech, arstechnica, fatwallet... Anyway, I'm 29 …

I have a web application that works fine on the web but not on my local server copy. the connection string on the web is cn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database/TaskMan_MSAccess.mdb") When i run a copy locally, it reads the access database but does not allow to update the data. …

Hi Everyone, I just wanted to know if it's possible to create a chart in a report based on multiple queries. Thank you for your time

i have done project in vb with access . i wish to create setup files for my project.how can i create a complete package including exe and all supporting DLL files

Here is my HijackThis log. I'm trying to follow the different instructions that you give, but i'm just so lost. I don't know anything about computers!! Please i really need your help. Thanks in advance. Logfile of HijackThis v1.99.1 Scan saved at 16:07:45, on 2006-09-26 Platform: Windows XP SP1 (WinNT …

am trying to delete a record but I have this message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ProductID = , 1567'. /salem/pages/fresh_food/TMP3rfr35u5pa.ASP, line 74 I looked at the meaning but so far I can't see that …

I have an Access DB with 2 tables: tbldirectory and tblPracticeAreas. I have a search page (practice-search.html) where the user can pick an attorney practice area from a drop down list. Upon choosing the practice area the user is taken to an ASP page (practice-search-results.asp)that displays a list of attorney …

how to connect vb.net with ms assess

Hey All, I have created the following code in my data base. It works correctly except that the email it creates is in the rich text format. I want it to be in plain text format. The default settings in outlook are set to plain text, but my code seems …

Hi I have a difficulty in insertion data. I wrote my html code (a form in it) and jsp code to get the form data and insert it to database. I don't get any error message but it doesn't insert data to database. My code is below. Where am I …

Hi I have used this code in an Access form to get a field to blink: Private Sub Form_Timer() With Me.[Credit Remaining] .ForeColor = (IIf(.ForeColor = vbRed, vbGreen, vbRed)) End With End Sub Can anyone tell me how to get this to work only on an entry that is less …

Is there any way to use the sendobject command to send a report as a pdf attachment rather than an rtf attachment. I am able to use the print object command and get this to work if I make the acrobat distiller the default printer. This way forces me to …

I have a subform on an Access form and in some cases default (or auto fill-in) fields in the subform from values in the main form. I don't want to default the values unless the user tabs to the field in the subform. What I've found is that if I …

Hi to all...Hope everyone is grand.I am currently working on a project that is supposed to connect to a .mdb(access) file and than bring out the project names in to the first listbox (listbox1) than when you click one of the elements in listbox1 you would get the selected projects …

I have an existing website and now wish to add an event registration database to it. Existing records don't need to be retrived or displayed - purely just appending new records to a database. I would prefer to use MS Access which I know, but need a few pointers as …

Hey there! Wondering if I might get some help. I have been asked to add some things into a database that we have. I have inserted a subform in a main form, with the correct links, etc. Data will be entered into both the main form and the subform. I …

hi every one , i need a help i am using vb 6.0 and wanna to connect with access db using odbc and can't find the way or code i will be thanx if any one help me in case( [EMAIL="e_twal@yahoo.com"]e_twal@yahoo.com[/EMAIL])

Hi Expert, I just wanna some help here. I have tried to connect my applications's database (Microsoft Access) using ODBC...but I can't get connected with the database. Actually the system I develop needs to be networked so, I try to run as a shared database (suppose to be)...but I can't …

Hi, I have created a asp.net application.when i try to execute the application, I am getting this error. Access to the path "c:\windows\microsoft.net\framework\v1.1.4322\Temporary ASP.NET Files\webApplication1\5163874c\83859bc7" is denied. While searching the net,i found this solution. To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and …

I've created 2 tables in Access and have created a form for each table in VB5. Each autonumber field is the primary key of it's table. When the first form comes up the autonumber field has a value but when I go to the second form the field is left …

I have inherited an Access 2000 database that has a text box where you click on a file path that is already entered there and it is suppose to bring up a Word or Adobe file. Sometimes the file will open and other times Adobe will open and the document …

In my program I want to add records to the database and then reference them by a unique identifier such as a user id. Even if the user name is the same as another, The would be different IDs so I could pull data on the correct one. So my …

anyone there?

Hi... Could somebody please offer me some advice here. I cannot access the Internet in IE although running the Diagnose Connection Problems confirms a connection and I can access with Opera and FireFox. I have set Automatically detect settings but still receive error. Here is my HJ log: ------------------------------------------------------------ Logfile …

Very stormy weather here. Hit blue screen which disappeared in crash so fast I couldn't read it. Programs are freezing, followed by flurries of Requests to Report but task manager unresponsive to shut down. Checked properties in some of the dll entries in my registry that showed two different formats …

Hey, I need to implement a database using MS Access. I am currently using a java platform and I dont know how to access the information stored in the database. I have used MySQL database in previous programs but it gave me some problems when loading the application. Can anyone …

Hey, I need to implement a database using MS Access. I am currently using a java platform and I dont know how to access the information stored in the database. I have used MySQL database in previous programs but it gave me some problems when loading the application. Can anyone …

[B]Hey friends, [/B] [B] I have started vendor management prj in vb.net. So I want to know about the connectivity. I am using Microsoft Access as backend. Which type of connectivit I should prefer; OLEDB, ODBC or other... Please help.[/B]

Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example: id Time Code Price Res …

:cry:troubleshooting : database is read only. line32 or microsoft jet 4.0 trouble. Http 500.100 PLease advise:( <% dim dbname dim conntemp, cnpath, sqltemp, rstemp dim user user = request.form("Username") dbname="member.mdb" set conntemp=server.createobject("adodb.connection") cnpath="DBQ=" & server.mappath(dbname) conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath sqltemp="select * from userlist" Set rstemp = …