[AccessD] MySQL db on Arvixe linux server

[Stuart McLachlan]

I've changed the subject back to the appropriate one.

If it's on a shared hosting account, you almost certainly will not be able to access it from 
Access.

The best I've ever managed in that situation is to export the data locally at one end as plain 
text, compress it, upload/download it via FTP , uncompress and then import at the other end.  
It's a lot of work.


Still, it's worth contacting the hosting provider and checking whether you can have remote 
access.

-- 
Stuart

On 7 Oct 2015 at 22:11, doug wrote:

> Jim,
> 
> I am guessing not. The db is on a shared hosting account. 
> 
> -------- Original message --------
> From: Jim Lawrence <accessd at shaw.ca> 
> Date:10/07/2015  9:41 PM  (GMT-08:00) 
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Stored Procedure
> as Rowsource for Chart 
> 
> Hi David:
> 
> Here is an overly simplified Youtube vid of connecting MS Access to a
> MySQL DB: https://www.youtube.com/watch?v=F06hvR6ksh4
> 
> Here is a link to some comprehensive lists of database to database
> connection string: http://www.connectionstrings.com and
> http://www.dofactory.com/reference/connection-strings and
> http://www.carlprothman.net/Default.aspx?tabid=90
> 
> Aside: If you use the standard method of generating an ODBC connect,
> the file created can be stripped down to a basic string by changing
> the file's extension to ".txt" and using the resultant connection text
> string directly within your Access connection module.
> 
> Do you have direct root access to the MySQL DB that you will be using?
> 
> 
> HTH
> Jim 
>