Posts by debasisdas

Any standard (non admin)user can't grant admin role to another user, only an admin can do that.

So you need to log in through any user which is an admin account to grant admin role.

Every user logs in into its own schema.

Did you log in through an admin account and tried to grant admin role to the user ?

It will be easy to do the same at database level.

The developer has used an evaluation version of a third party control. And since the evaluation period has expired, so you can't keep using that any more.

In which line you are executing the SQL statement ?

Nothing comes free in life.

If you are trying to do, that is illegal in country.

You need to connect VB to oracle and insert the data into oracle tables.

1. Select the distinct value from the column Car Manufacturers and display in the first List Box.
2. Select the value from the first List Box.
3. Pass this value to another SQL dynamically at run time.
4. Fetch the values from the SQL and populate the second List Box.

I think access is not backward compatible and so can't open .ACCDB file which is supported in the version 2007 onwards.

Crisis separated real men from pretenders.

As already suggested no need to install Access if it is used as database only. Having the .MDB file only is enough.

Which dbms ?

You need to store the last update time in a column and keep checking that using Event Scheduler

Lets see the code that is throwing the error.

You need to read this and this.

More information is required to answer your question .

Which report ?
What is the source of data ?
................ ?

You need to keep tracking all the records.

you need to handle the key ascii in Key press event

in what format data is stored ?

What is stored in the database ?

The path of the physical location of the picture file or the actual picture ?

Welcome aboard.

Welcome to Daniweb.

If using ADO then try this

conn.begintrans 'conn-----adodb connection object
conn.execute "delete from table_name"
conn.committtrans

1. referring and referenced table columns should be matching.

2. DEFAULT is not a constraint.

How you connect to database ?

If using ADO then try this

conn.begintrans  'conn-----adodb connection object
conn.execute "delete from table_name"
conn.committtrans

Welcome to Daniweb.

Welcome aboard.

What is not working ?
Are you getting any error ?

Check if your sub query returns any record.

Then you need to learn the language first.
Go and read books.

Welcome aboard.

try like this

select * from table_name where ( event_start between 13/8/11 and 15/9/11 )
and (event_end  between 13/8/11 and 15/9/11)

Using bfile is same as storing the path of the file in disc.

In this approach the problem is if the file is deleted or moved out of the specified oracle directory oracle will will be unable to retrieve the file and will throw an error.

please post your code here for reference.

Happy birthday.

Three years passed only in 2 pages:S

No one here is going to supply you with the code without any effort from your side.

You need to hire a professional develop to get it done your you, and you need to pay the professional.

That you need to decide depending on your usage and most importantly budget.

Ours is not a free code supply service.

You need to read books for all that.

you need to select start and end dates from the control
format it as per database format before using the values.
Use BETWEEN operator in database side for date range.

Please specify how are you connecting ? I am not sure what exactly you mean by The database is being detected but not the tables inside the database.

For a simple solution you have to create a shortcut to the Programs [your exe file] and drag & drop that shortcut into the Startup folder and reboot your system.
for example
C:\Documents and Settings\Das\Start Menu\Programs\Startup

Other methods here and here.

But i do not understand why you need to combine two SQL statements.

If you want to fetch records from both the tables then you need to join both the tables.

Without knowing the exact piece of code that you are executing, it is practically not possible to guess the reason of this exception.

You need to debug both your application and DB code that is being called form application.

You need to use GROUP BY clause in your SQL.

As suggested by smantscheff, you need not bother about STATUS column at all if you do not want to filter by that column and display all the records. So it really does not matter how many distinct values you have in that field.

300 columns and 3 million rows is not that huge as it sounds. Any standard RDBMS application would do that. To decide the database a lot would depend on how much you can spend on the DB and server(hardware).

What exactly you are trying to do , that raises this exception ?

You filter the dates from database by using BETWEEN operator. You need to format the dates into your database format before passing the same into the DB for processing.

Hi Avinash,

Welcome to Daniweb.

Welcome aboard.