Replace Table & Query & Report Name

[Bill]

Hi,

I have five people in different areas. I don't feel like to update the access on their machine. Is there a way for me to send email to five people and double click . It will delete the old names and insert new names in MS Access file. They have all the same access file.

Your help would be appreciated.

 

[Alick [MSFT]]

Hi Bill,

Do you mean you want to send an Access application to the clients, when the
clients run the application, it will rename the objects name in another
database file? If so, you may need to try ADOX object, it contains table
object, View object that we can use to refer to the name of the table,
query, report object. You may want to refer to the article below to get
start, especially "Data Definition Using ADOX" section.

Chapter 6: ActiveX Data Objects
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacchbk/ht
ml/acsybex_chap6.asp



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| From: "Bill" <[email protected]>
| Newsgroups: microsoft.public.access.tablesdbdesign
| Subject: Replace Table & Query & Report Name
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hi,
| I have five people in different areas. I don't feel like to update the
access on their machine. Is there a way for me to send email to five
people and double click . It will delete the old names and insert new
names in MS Access file. They have all the same access file.
| Your help would be appreciated.
|