Create a program that uses a DB to be shared

[Nando88]

I found out the problem.

Its the driver, since I have office 2016 x64 and labview 2017 x32.

Now I have to find the link for the jet or ace driver, but if you could kindly provide one of these drivers, I would really appreciate it.

Thanks.

[Nando88]

I fixed the driver problem by installing x64 2010 driver for windows and 2007 driver for labview 2017 x32, and I am able to connect succesfully onwindows with the udl and on labview, if I give full path, but I am unable to write to db with labview.

[Nando88]

Labview uses the jet driver already, and it connects to db just fine, when using absolute path, but when trying to use relative path, it just doesn't write to db. I still haven't tried to write to db with absolute path, and still nothing.

Can someone please help me?

Thanks.

[Nando88]

The reason jet doesn't work, is because I don't have the driver on my laptop, but accdb, I have 2007 driver for labview and x64 2010 driver for my laptop and still nothing.

Any help to get the jer driver and to be able to write to do will be greatly appreciated.

Thanks in advance.

[Minions]

Are you currently able to write to the DB through Access?  If you do not have write capabilities, then this is an IT function and not an NI issue.  ACCESS is a live program and will update data without the need to save different from most other Microsoft tools.

[Nando88]

I followed the instructions here:

https://www.youtube.com/watch?v=ffU3pWmADIE

and gave myself write access.

But now I am getting an error on open db.

I will attach a screenshot of my code and the error.

Any help will be greatly appreciated.

Thanks.

[Minions]

Did you set up the ODBC.ini properly?  This is where it determines which drivers to use on a particular DB.

[Nando88]

It gives me an error on testing connection.

[Nando88]

I got rid of the error and have read and write access, but I am still unable to write to do.

What might be the problem?

I only get error when I reopen the udl and test connection.

[Nando88]

I am now sending my project, so someone can help me fix an insert error.

I found 2 errors 1 was column names nam matching and the other is not all columns are connected, so column number mismatch.

I will send a new video as soon as possible and when you extract the zip, do it inside a folder, cause there are many files.

https://drive.google.com/file/d/1hXQz99dau30qp9kAA-zPUwvCLbbs4Unb/view?usp=drivesdk