edit/add table/field names in access

[clientuser]

i have been messing around with making changes to an access db and came across this line:

object.DoCmd.OpenTable(USEROPT,acViewDesign,acAdd)

i have dimmed my object as well as set it and it works great, but i do not understand the line above.

what i have is:

- a vb app that uses an access backend that will be distributed to a lot of users

- if any updates are done to the application/db, i want to be able to let the user run an update. i have the application part down that retrieves the update from the web, but im stuck on how to add new field names or maybe change existing ones etc...

 

[Droops]

Hi,

try running a keyword search in this forum with search text "ADOX Catalog".

You should get something to start on.

Hoping this helps.

Droops.