Access mdb file - cant get list of tables or views with db.tables() list

[GoranSimunic]

Here is widget.h

#ifndef WIDGET_H
#define WIDGET_H
 
#include <QWidget>
#include <QtSql/QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QStringList>
 
namespace Ui {
class Widget;
}
 
class Widget : public QWidget
{
    Q_OBJECT
 
public:
    explicit Widget(QWidget *parent = 0);
    ~Widget();
 
public:
    QString vrijeme;
    QString vrijemeKraj;
    QSqlDatabase db;
    QSqlQuery sqlTrazi;
    QStringList list;
 
 
    bool conOpen(){
 
        QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
 
               db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=D:/Programi/SynSetup/Synesis/Pupilla.mdb");
 
        if(!db.open())
        {
 
            //qDebug() << "Database Error" << db.lastError(); //<< db.lastError().text();
 
            return false;
 
        }
 
        else
 
        {
            return true;
        }
 
    }
 
 
 
    void closeConnection(){
        db.close();
    }
 
private:
    Ui::Widget *ui;
};
 
#endif // WIDGET_H

#ifndef WIDGET_H
#define WIDGET_H

#include <QWidget>
#include <QtSql/QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QStringList>

namespace Ui {
class Widget;
}

class Widget : public QWidget
{
    Q_OBJECT

public:
    explicit Widget(QWidget *parent = 0);
    ~Widget();

public:
    QString vrijeme;
    QString vrijemeKraj;
    QSqlDatabase db;
    QSqlQuery sqlTrazi;
    QStringList list;


    bool conOpen(){

        QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");

               db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=D:/Programi/SynSetup/Synesis/Pupilla.mdb");

        if(!db.open())
        {

            //qDebug() << "Database Error" << db.lastError(); //<< db.lastError().text();

            return false;

        }

        else

        {
            return true;
        }

    }



    void closeConnection(){
        db.close();
    }

private:
    Ui::Widget *ui;
};

#endif // WIDGET_H

To copy to clipboard, switch view to plain text mode