Question about Computers & Internet

1 Answer

Visual Basic Problum

How the Microsoft Jet Engine works with DAO.

Posted by on

Ad

1 Answer

Autocad 2006,1utocad 2007 very slow with 1 gb memmory.so pls say me that how speed increase in autocad 2006 and autocad 2007.

Posted on Mar 13, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

I have a database in mdb format that will not open. When I try to open the file I get an error: The Microsoft Access database engine stopped the process because you and another user are attempting to...


You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more: https://access.recoverytoolbox.com/

Dec 01, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

Quickverse 7.0 and vista


run msconfig and check if any Office programs
are running at startup uncheck them or delete the entry run from the registry ,and any Office programs that
are running during installation it exist

Dec 19, 2007 | Parsons QuickVerse 2005 Expanded Edition...

1 Answer

How do you hook the lcd projector to a portable dvd player?


The Dell 1100MP has SVideo and RCA input connections you can use, it all really depends on the type of video out connection that your portable DVD player has.

http://support.dell.com/support/edocs/acc/1100MP/eDoc/DAO/OM-DAO.pdf

Jun 03, 2011 | Dell 1100MP Multimedia Projector

1 Answer

I cannot load some programmes. I get an error 429 activex component message., Is there a free vista available to run over the top to fix any or all problems i might have on my system


cause : This issue can occur when DAO dynamic-link library (DLL) files are mismatched or when there are incorrect registry entries. This issue can also occur when there is a missing DAO design-time licensing key. This key is required by Microsoft Excel, but is not required by applications created with Visual Basic

Method 1 loadTOCNode(2, 'resolution');
  1. Click Start, and then click Run.
  2. In the Open box, type regsvr.exe.
  3. Re-register DAO350.dll.

    NOTE: You can obtain a copy of DAO350.dll at the following FTP address: ftp://ftp.microsoft.com/softlib/mslfiles/ To register DAO350.dll, follow these steps:

    1. Click Start, and then click Run.
    2. In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
    3. Click OK.
  4. Click Start, point to Settings, and then click Control Panel.
  5. Click Add/Remove Programs.
  6. Insert your Microsoft Office 97 CD, and then click Uninstall.
  7. Delete the DAO folder from the hard drive.
  8. Click Start, point to Settings, and then click Control Panel.
  9. Click Add/Remove Programs.
  10. Insert your Office 97 CD, and then click Install.
  11. Repeat steps 4 through 6 to uninstall Office 97.
  12. Click Start, and then click Run.
  13. In the Open box, type eraser97.exe. (This file is also available at ftp://ftp.microsoft.com/softlib/mslfiles/.)
  14. Repeat steps 4 through 6.
  15. Repeat steps 8 through 10 to reinstall Office 97.
Please Rate Solution!

Sep 08, 2009 | Computers & Internet

1 Answer

I am asked to close microsoft dod before I can install quick verse 7 How do I do this


Most likely you'd have to uninstal MS Office, as I think this is the program using Microsoft DAO. Restart the computer in Safe Mode, then Quickverse will instal ok.

Jul 15, 2009 | Parsons QuickVerse 7 Essentials (fe11044)...

1 Answer

Retrieving acess data which is password protected thru VB


You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.

2. For SQL database:
g_strADOConn = "Provider=SQLOLEDB;" & _
"Data Source=SERVER_NAME;" & _
"Initial Catalog=DATABASE_NAME;" & _
"User ID=mssql_userid;" & _
"Password=mssql_password;"

Apr 22, 2009 | Microsoft Visual Basic 6.0 for PC

3 Answers

Installing QV 7 produces warning MS DAO preventing installation.


I,too, have the problem of installing my Quickverse 7 on my computer with Vista. What do i do to stop the running of Microsoft DAO?

Apr 08, 2009 | Parsons QuickVerse 7 Essentials (fe11044)...

1 Answer

What is the compatible database for visual basic 6.0?


Microsoft Access uses the Jet Engine. In VB 6, you can create a data connection using ODBC or OLE DB. Here is an example of OLE DB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourAccessDB.mdb;User Id=;Password=;" Good luck

Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...

1 Answer

How to connect vb with ms access


se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

Feb 26, 2009 | Computers & Internet

1 Answer

Record number using DAO


currentPosition = recordsetName.AbsolutePosition +1

Jun 06, 2008 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

46 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...