I need a help with my program and my database in access
Hello Guys
I am having problem with a application that uses as database access, my program works with 4 databases and one of them has some linked table from another database. I have to change the name of the folder where the databases are kept. After doing this, I had a problem to open my linked tables in access. Access complains that the path is wrong.
How could I fix this? The database were in my c:\carsystem\database and now they were placed in the server, the path that I uses to access the databases is \\10.10.1.2\carsystem\data
I made an example of system using a small access database so that you could see the problem that I am facing. You can download it from this link www.infosoftlanguages.com/arquivos/AccessTest.zip
After installing it in c:\ change the folder name database to database2, don't forget to change the path in the event beforeconnection of adoconnection to database2, open the queries, you will see the problem.
my question is:
is there any way to pass the path of my folder so that the access doesn't keep a fix path?
thankls
I am having problem with a application that uses as database access, my program works with 4 databases and one of them has some linked table from another database. I have to change the name of the folder where the databases are kept. After doing this, I had a problem to open my linked tables in access. Access complains that the path is wrong.
How could I fix this? The database were in my c:\carsystem\database and now they were placed in the server, the path that I uses to access the databases is \\10.10.1.2\carsystem\data
I made an example of system using a small access database so that you could see the problem that I am facing. You can download it from this link www.infosoftlanguages.com/arquivos/AccessTest.zip
After installing it in c:\ change the folder name database to database2, don't forget to change the path in the event beforeconnection of adoconnection to database2, open the queries, you will see the problem.
my question is:
is there any way to pass the path of my folder so that the access doesn't keep a fix path?
thankls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
rfwoolf
There is a tutorial on delphi and INI files at about.com and elsewhere on the net
ASKER
rfwoolf: you didn't understand my problem,
this I know to do perfect . The problem is the linked table inside of base1 , please download de example I assembled in Delphi 7 and do what I am telling, you will see the problem
this I know to do perfect . The problem is the linked table inside of base1 , please download de example I assembled in Delphi 7 and do what I am telling, you will see the problem
Oh I see. So this doesn't really have anything to do with Delphi? This sounds more like an Access problem. You have 2 databases in Access and the 1 database is linked to the other. When the path/location of the 2nd database changes, the 1st databaes can't find it?
I'm not sure about that one. In that case you should add your question to the MS Access zone
I'm not sure about that one. In that case you should add your question to the MS Access zone
To update your linked tables I think you need to open access then go to the tools menu, add-ins, linked table manager. Here you should be able to update where your linked tables get their information from.
Hope this is what you are looking for Hidrau.
Hope this is what you are looking for Hidrau.
ASKER
Yeah, this is my problem
I wonder if there any command that I could fix it or if someone has already passed by this problem.
I am trying to find the solution :( and not yet
I wonder if there any command that I could fix it or if someone has already passed by this problem.
I am trying to find the solution :( and not yet
ASKER
mikelittlewood: do you know if there is any command that I could do throgh my system running in a adoquery?
ASKER
Everybody here knows how could I run this function in access through delphi?
http://www.mvps.org/access/tables/tbl0009.htm
This will reflesh all linked tables
http://www.mvps.org/access/tables/tbl0009.htm
This will reflesh all linked tables
ASKER
It wasn't what I was looking for, but that answer gave me another ideia