simple program (pref. portable) to update (insert new column) in an access table?

[Jen]

Hello,

I have searched but not been able to find a simple program that would be
able to edit an access table on a computer without access installed. Any
suggestions?

Jen

 

[David W. Fenton]

I have searched but not been able to find a simple program that
would be able to edit an access table on a computer without access
installed. Any suggestions?

Why don't you explain what you're trying to accomplish and why the
Access runtime would not be sufficient.

 

[Jen]

?> Why don't you explain what you're trying to accomplish and why the

Access runtime would not be sufficient.

I want to open the backend database and insert new columns in a table.

 

[David-W-Fenton]

?> Why don't you explain what you're trying to accomplish and why
the

I want to open the backend database and insert new columns in a
table.

Ah, so you don't want to edit just data, but the structure.

I'm afraid that unless you do some fancy programming, only Access
itself can do that, unless you're OK with writing SQL DDL
statements.

 

[Tony Toews]

?> Why don't you explain what you're trying to accomplish and why the

I want to open the backend database and insert new columns in a table.

You can use the following page as a starting point however if you
aren't familiar to VBA code this can be rather daunting as I would
suggest an intermediate to advanced expertise in VBA.

See the TempTables.MDB page at my website which illustrates how to use
a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/