When I changed the path in the xml file my .mdb throws error ?

[titli]

Hi All,

I get a .txt file from a Samba drive EE\e1\e1 and , feed it to my access application.
ALso a separate shared database is used , which is in another drive say DD\d1\d2
O/p to be kept in OO\o1\o2

Now the application is being moved to a new drive MM
I just changed the path of o/p data to to kept in and the shared database path.

Get an error message as could not find APPLI inside MM\APPLI\Production\filename

The input text file should not be searched at this location at all.I should be searched in teh samba drive.

On clicking debug get this error :

DoCmd.TransferDatabase acExport, "Microsoft Access", sDatabaseName, acTable, "MSysIMEXSpecs", "MSysIMEXSpecs"

This line comes after these lines:------

sDbName = configvariable("stagingpath") & sPartFileName & Format$(dCOB, "YYYYMMDD") & "_raw.mdb"
    sFileName = configvariable("inputfilepath") & "Appli_" & sPartFileName & "_" & Format$(dCOB, "DDMMYYYY") & ".txt"
 
    If Dir(sDbName) <> "" Then Kill sDbName
    accApplication.NewCurrentDatabase sDatabaseName
    accApplication.CloseCurrentDatabase
 
 

I need to change the paths and make the application work in new drives.

Please help ...Write about every possible thing that might have gone wrong.I will test it and see.



2) Another problem :::::::

In another applications xml i just found paths , but not in tags liek <config><staging path></stagingpath></config>

Whe the application runs the paths can be seen , in debug mode , but in xml making changes , how does someone proceed ?



Thanks
Titli

[Stewart Ross]

Hi. TransferDatabase is failing because it cannot find the path to the database that has been specified. From the limited information available in the code fragment you post you need to look at what 'stagingpath' is referring to within function configvariable in line:

sDbName = configvariable("stagingpath") & sPartFileName & Format$(dCOB, "YYYYMMDD") & "_raw.mdb"

Perhaps there is a table somewhere within your application which stores config information such as the DB path?

Beyond that I think you are going to have to spend time tracing function configvariable with the debugger to find out how the original application was set up.

On the second part of your question, there is little we can do to help you with low-level detail such as how to change xml tags with path information in them. This is something you will have to do yourself once you understand the way the paths are structured.

-Stewart

[titli]

Hi Stewart ,

thanks for your response.Yes my staging path was incomplete.I was just getting the file name as sDbname.Whereas in previous place from where i was running teh application showed teh full statging path.Will investigate more.Because in xml file i didn't even chnage the staging path.


Thanks !!!
Titli