launch access

[vlitim]

I want to be able to open up a specific file in access after clicking a cmdbutton. Can you do it using unc as network drives may be mapped differently.

cheers Tim

 

[woyler]

Yes, You can (and should) always code using //SERVER

 

[vlitim]

my next question then would be .........how??

 

[woyler]

Use this connection string

Driver={Microsoft Access Driver (*.mdb)}
;Dbq=\\SERVERNAME\FolderShare\MyData.mdb;Uid=Admin;Pwd=;

 

[woyler]

Using ADO;
Use this connection string

Dim cnConnection as ADODB.Connection

Set cnConnection = CreateObject("ADODB.Connection&quot

cnConnection.OPen "Driver={Microsoft Access Driver (*.mdb)}
;Dbq=\\SERVERNAME\FolderShare\MyData.mdb;Uid=Admin;Pwd=;"

 

[vlitim]

I don't seem to get any response from this. no errors and nothing loaded??

 

[woyler]

How are you making your connection now?

 

[vlitim]

just using what you posted!

 

[vlitim]

What I actually want is to launch Access or any other application, ie word etc!?!?

 

[woyler]

If you want to launch an app, use Shell