Vitaliy4us

How to access database on remote computer?

3 posts in this topic

I have two equal databases. The first one is install on the local machine and the second one on the virtual machine. I have no problem while connecting the database on local machine

_AccessOpen(@ProgramFilesDir & "\MyFolder\DB\MyDB.mdb")

To access database on the virtual machine I share database folder and do the same

_AccessOpen("\\111.222.3.44\MyFolder\DB\MyDB.mdb")

But I receive an error "The requested action with this object has failed.:

$o_doc = $o_object.OpenDatabase($s_FilePath, $Options, $ReadOnly, $Connect)
$o_doc = $o_object.OpenDatabase($s_FilePath, $Options, $ReadOnly, $Connect)^ ERROR"

From another hand I can access text file from DB folder without any problem:

ShellExecute ("\\111.222.3.444\DB\TestFile.txt")

Share this post


Link to post
Share on other sites



Please, post your script so that we can see what you have tried. :)


Snips & Scripts


My Snips: graphCPUTemp ~ getENVvars
My Scripts: Short-Order Encrypter - message and file encryption V1.6.1 ~ AuPad - Notepad written entirely in AutoIt V1.9.4

Feel free to use any of my code for your own use.                                                                                                                                                           Forum FAQ

 

Share this post


Link to post
Share on other sites

For more detailed error information I suggest to add a COM error handler to your script.

Please check ObjEvent in the help file for an example.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now