Need help with network path....

[cplmckenzie]

I have an Access Application which opens an Excel Workbook and performs an operation to open and run a
worksheet.

It works fine on the local machine, but fails over the network with Access VBA.
But the same code for the network path works fine when ran directly from Excel VBA.

This is the network path used in both apps.

MySheetPath = "\\GunSlinger764\Development\DST\jtraylor\PackList\ _packing-list-log-newtest2.xls".

Is there something special I need to do in Access to get this path to work.
Any and All help is appreciated.

The error Access gives is..
run-time error '432'
Filename or class name not found during Automation operation.

I have checked from both Access and Excel and the file does exist on that path for machine GunSlinger764.



Thanks

cplmckenzie

[June7]

That looks like UNC pathing. If GunSlinger764 is the network server name then pathing should work. Don't know why Excel and Access would behave differently. Want provide Access code for analysis?

[cplmckenzie]

Thanks June7,

I will zip the access db and the excel workbook, with a text file of where the networkpath is used so it can be changed for testing and upload.

Thx

cplmckenzie

[cplmckenzie]

June7,

I have attached the files for testing.

See the text file forummsg2 for explaination.

Thx.

cplmckenzie

[June7]

Why are you using Excel to produce print documents instead of using Access reports? Eliminating interaction with Excel should make this issue go away.

Trying to test. Compile error "Sub or Function not defined" on:

Erase DWG() ' clear array memory

What are the dimensions of this array?

[cplmckenzie]

June7,

You are right, but this work is for a business concern in California and all their apps and data have been stored and ran with Excel since Office 2003.

We have managed to get them up to Office 2010, but the people in charge of these decisions are reluctant to move the process over to Access.

This , what I am doing is just a prototype to show the benefits that can be gained for making the move from Excel to Access.

Hence, that piece of code that you are refering to is actually from one of the other functions I coded for them last year, It is the same that will be required in this
sub.

So to run for your test purposes, you can remark them out with no problem.

Thanks again,

cplmckenzie

[June7]

I put Excel file on network server. I tested Access file on both local and server locations. The Access VBA has no problem opening the Excel.

So there is something about your server. Could there be some permission issues?

[cplmckenzie]

June7,

Thanks. so the access app on the local machine opened the server based excel file, which is the way it should run.

Any suggestions on the error msg '432' that is in the text file I sent.

I will test this with all permissions enabled and work backwards.

Any other suggestions you can give me.

cplmckenzie

[cplmckenzie]

June7,

Thanks very much. It is working now across the network both on local -> Server and Server-> Server.

I needed to set set trust locations, enable macros and set reference to excel object library.

cplmckenzie