Jump to content
Vitaliy4us

How to access database on remote computer?

Recommended Posts

Vitaliy4us

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
MikahS

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
water

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 (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
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

×