Am using Access2000. Can anyone help me on the following regarding table links?
while quitting a database Is it possible to check whether any linked tables exists in the database and if so delete the links?
I am using the toolbar "Linktables" on a form. If the user wants to link, then he clicks a command button on the form which executes "%(Fl)" to link the tables. Is it possible to remove this "linktables" toolbar from the form and then link by pressing the same command button? I am not providing any other Menus or toolbar for the database. My problem is if the user sees the "linktables" toolbar and cliks it without clicking the command button, then some of the codes to be executed after linking will fail. Otherwise is it possible to make the "linktables" toolbar visible only when the command button is pressed?
Any help for the above will be appreciated.
Regards,
Charley
while quitting a database Is it possible to check whether any linked tables exists in the database and if so delete the links?
I am using the toolbar "Linktables" on a form. If the user wants to link, then he clicks a command button on the form which executes "%(Fl)" to link the tables. Is it possible to remove this "linktables" toolbar from the form and then link by pressing the same command button? I am not providing any other Menus or toolbar for the database. My problem is if the user sees the "linktables" toolbar and cliks it without clicking the command button, then some of the codes to be executed after linking will fail. Otherwise is it possible to make the "linktables" toolbar visible only when the command button is pressed?
Any help for the above will be appreciated.
Regards,
Charley