debasisdas

It is always bettter to open and close the connection in the application itself.

Please find the connection string [URL="http://www.connectionstrings.com/"]here[/URL].

please find related discussions [URL="http://bytes.com/forum/thread641548.html"]here[/URL] and [URL="http://bytes.com/forum/thread641546.html"]here[/URL].

the USER_...........views contains info about user data but SYS_............ and ALL_...... contains data of all other users also to which notrmal users may not have priviliges.

you can remove the titlebar itself just by changing the property.

Are you getting any error from the query. Are you sure related data exists in the tables ?

Kindly post your code that you are working on for reference of our experts.

What do you mean by [B]the focus may also be changed[/B] ?

Please find a related discussion [URL="http://bytes.com/forum/thread726143.html"]here[/URL] .

There is no difference in using access or oracle or mysql queries in VB. The process is all the same.

The synonym becomes invalid if the base table is dropped. You need to drop the synonym manually.

Kindly post the query that you are working on.

It is always recommended to register the component with windows and then use it in VB 6.0. Add the same from Project---->References and then use it.

If you create the database with same structure in oracle then you only need to change the Connection string for opening the connection in Vb. Rest all are remains the same and you can use the advantages of procedures & functions

What exactly you are trying to do ?

That simply means you are not using the correct version or oracle database. You are trying to execute some advance commands in the un-supported earlier versions.

I strongly believe there is no limit for the number of records in access database. Try to create index on the fields for faster data access.

What exactly youa re trying to do.

It is always better to go for .Net. It has a lot of advantages over age old VB 6.0. But if you still want to use VB 6.0 ,you can go for the same.

Both are easy provided that you have intrest.

Kindly post your code . What are you doing exactly and what are the problems that you are facing.

Add [B]Exit Sub[/B] before the error handler.

What is var_list1 you have declared var_list

You need to design the report in crystal report and call that from VB. You can pass the query to filter records at runtime.

You need to use convertion function. BTW which version of VB you are using ? Is it Vb 6.0

What exactly you are trying to do ?

Are you facing any problem with your code ?

Better to put the database in some FTP server and access that through the net using the Ip address with username and password for security.

Instead of using addnew ,you need to use Edit . In simple terms instead using Insert you need to Update the existing record.

You need to use some third party controls for the desired results.

You need to check if the data already exists in database using COUNT before inserting the same to database.

[QUOTE=nasir1149;572912]Can some one help me with the following. Any help will be appriciated. Platfprm : Visual Studio 2005, Visual Basic ........... .................. ........................ NK[/QUOTE] Please do not hijack others threads . Start a thread of your own instead for fresh discussions.

You mean to say ,you want to write to the same file in parallel from two different proceses ?

The code from [b]Shouvik[/b] will work fine. But i would recommend you to use use COUNT to findout existance of the username and password in the database. 1.Accept the username and password from user input. 2.In the database username field should be the primary/unique key to avaoid duplicate user name. …

The following code should work for you. Data1.RecordSource = "SELECT * FROM waqf where cardno LIKE "'%" & Trim(s) & "%'"

You have designed the browser yourself or using any other browser(like IE) component ?

Please check for the connection string [URL="http://www.connectionstrings.com/?carrier=access"]here[/URL]

Please do not start a thread for such kind of things.

You need to parse [b]sysdate+1+2/24+20/(24*60)[/b] to proper format before processing in database.

1. remove the begin end part 2.use INPUT BOX instead of PUT 3.accept the value from inputbox instead of GET. rest almost remains

frankly, i even could not get that to 2.

To read binary files use PUT and GET.

Is you application connected to oracle database ?

1.read the file 2.copy the content 3.convert to uppercase 4.then compare line by line with master file.

The lvbutton.ocx file might have got corrupted .

The code syntax is correct . it seems there is some logic error in your code. Run the code using brake points and check.

What is the data type you are using in Access . Try using decimal .

ASCENDING is default for DESCENDING you need to specify DESC after the field name.

Are you planning to do that using VB 6.0 ?

You need to enclose the quotes by enclosing quotes since it is a string.