I would like to know how to add new fields to a linked 1

[jazzz]

table.

Anyone that can lend me a hand on how to open the BE database locate the table and add the fields I would appreciate it. Just a little code to get me started would be great I can take it from there. I would use DAO since I know that will be installed on the target machines.

Life's a journey enjoy the ride...

jazzz

 

[straybullet]

You want to add fields to your backend tables "on the fly" so to speak?

or

You simply want to add some fields to a table?

Let them hate - so long as they fear... Lucius Accius

 

[jazzz]

I want to add fields to the backend on an existing table on the fly.

Life's a journey enjoy the ride...

jazzz

 

[straybullet]

May I ask why? The reason I ask is that in order to edit the structure of a table, you would need exclusive access to the backend file.

Let them hate - so long as they fear... Lucius Accius

 

[jazzz]

Yes you may...I created a custom mdw for this file and it resides on a computer an hour away. Since it contains patient data I cannot legally view the db. Therefore I need to add five fields to the BE Patient table either by code so the requested fields are there for my FE or have someone there follow my instructions to do it manually. However, I don’t believe there is anyone available that would be able to follow my instructions. Also I would need to email them the line they would need to open Access with my permissions and that would defeat the purpose of my custom mdw. If I drive down I can access it only after I sign a ton of forms for the client that states I won’t reveal any patient information.

Life's a journey enjoy the ride...

jazzz

 

[straybullet]

While I am not quite sure of how to go about it, if you have your local working copy (sans sensitive data) there must be a way of making the necessary changes on a copy of it, and then being setting up an automated way of copying their existing data into the new one, complete with a new FE file which would already be set to link to the new BE.

Let them hate - so long as they fear... Lucius Accius

 

[jazzz]

Staybullet, I have the project done and ready to go but the target machine is missing one reference that I need to apply the patch MSADOX.dll and I need permission from the IT department to get this installed but I won't hold my breath. I used ADO to make the connection and ADOX to add the fields and updates using my admin name and password to connect to the BE. I was just looking for another solution that didn't require ADOX.

Life's a journey enjoy the ride...

jazzz

 

[JerryKlmns]

Check out this ALTER TABLE ADD COLUMN T-SQL here

 

[jazzz]

Jerry one question because I did look at ALTER TABLE ADD COULUMN before I play with this maybe you can answer one question for me. If I am using a custom mdw and I make a connection to the BE via ADO can I then use the ALTER TABLE from that point? Thanks in advance.

Life's a journey enjoy the ride...

jazzz

 

[JerryKlmns]

Oh, yes!!

 

[jazzz]

Jerry that is the way I will go with this project. I was able to remove the ADOX reference and utilize the ALTER TABLE Command instead, thank you and thank all that helped me out on this thread.

If anyone would like to see the finished code email me or if you like I will post it here.

Life's a journey enjoy the ride...

jazzz