Search results

Yes i now understand this distinction.

It does work with Access!! But interestingly NOT with Visual Studio. So our findings are MyOLEdb .net flavour OLE DB DRIVER for Visual Studio Express, doesn't work with Access http://sourceforge.net/projects/myoledb/ Cherry City Software ADO OLEDB PROVIDER. Works with Access VBA...

I found the driver that works with the string you quoted above. I had the wrong one installed. You can even reference it with VBA EDitor->Tools->References, so you know its going to work. Its third party though, not Oracle made. http://cherrycitysoftware.com/ccs/providers/ProvMySQL.aspx

Thanks. I tried this already and it did work. I got this connector installed. I had been curious however to find a non-odbc method, using ado and ole db.. as i stated in my original post. It seems that Access and VBA, using ADO objects wont connect to mysql database using oledb. VB and Visual...

Got the same error with the connection string you gave me: Public Sub DBConn() Dim adConn As New ADODB.Connection Dim myConnectionString As String myConnectionString = "Provider=MySQL Provider; Data Source=127.0.0.1; User ID =root;Password=whatever; Initial Catalog=njpn2;"...

Can you help further please: Here's my code in Access VBA: Public Sub DBConn() Dim adConn As New ADODB.Connection Dim myConnectionString As String myConnectionString = "Provider=MySQLProv;DataSource=njpn2;UserId=root;Password=whatever;" adConn.ConnectionString = myConnectionString...

Thanks, that's worth a read... Isn't Access a .NET platform?

This uses ODBC though. I would prefer to not use dsn and linking. Thank you anyway

Connecting to external data sources is a new thing i'm learning so bear with me pls. MYSQL is a natural choice for me over SQL Server as i have been using it a lot with php and i'm used to MYSQL workbench and phpmyadmin etc etc.. I loved the way that php had native support for mysql rather...

Thank you very much. That looks like it'll do the job SGT

Hello All, I've got a string variable with a value that could be typically "ABCD|123|R" The string needs to be split into its three parts, the pipe symbol being the separator. Then the middle numeric string must be converted back to a long Forgetting the string to long conversion for moment...

Thanks to both of you. I would tick the thanks button - if i could find it!

I've got a tabular form called PEOPLE LIST which is data sourced by a query. Records in this form get updated elsewhere and i had a piece of code embedded in the updating form which went: [Forms]![PEOPLE LIST].Requery All went well and life was happy. The changes made were reflected in the...

Yes.. i think by the time the form-load event of the form in question is executed the popup value has been set, so its too late. I will set the value before the call with an external refererance to the form. Thanks for your reply

In a module that gets executed upon app start. The module just contains a sub called Init_globals that initializes a whole bunch of them. Init_globals is called from the form-load of the main menu form of the app.

On my app I have an Options form with an option group that says 'Docked' or 'Moveable'. This is so my users can control the look of certain forms. The value of the option group is Docked =1, Moveable = 2. This value is then passed to a global variable . ******************************** Private...

Oh good, an MVP says i did it correctly! Thanks a lot, friend :)

I have created a medium sized Access app, and I want the database on a server for the advantages that gives, and retain the Access front end. For me MYSQL is the natural choice as i have used it before. SQL server i don't really know. I have MYSQL server/Phpmyadmin and the Mysql odbc drivers at...

Yes, I have two subs with the same name. It's always the simple things isnt it. Thanks to all for the quick replies !

I should have mentioned : the original macro was for the On current event for the form.