Q=>I am wondering what happens when i copy a folder H:\A to C:\A (with all the files) and open delphi from the C:\A folder and why the connectionstring still points to H:\A\D\BkpRules.mdb; and i get an error.
bayu imbang A=> use this : ConnectionString ='Provider=Microsoft.Jet.OLEDB.4.0;Password=""'+';User ID=Admin;'+'Data Source='+ExtractFilePath+'\'+(Application.exename)+'BkpRules.mdb;'+... Roger C. Morgan II A=> The connection string would be stored in the datamodule .dfm file. I always add the code below to my data module create method to redirect the connection through the Data Link. Connection.Close; Connection.ConnectionString := 'FILE NAME=LinkFile.udl'; Connection.Open; Comment=> thank you roger and bayu, both options work and I have now different ways to implement it. furthermore i learned that i can use: ConnectionString Provider=Microsoft.Jet.OLEDB.4.0;Password=""'+';User ID=Admin;'+'Data Source= .\data\BkpRules.mdb;' + ..... where the folder with the exe file is the parent of the folder .\data however i have to delete the connectionstring definition in the object inspector connectionstring property from the adoconnection before i copy the folder with the program to another location. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
