Search results
-
N
SQL query to ALTER TABLE ADD COLUMN in Access database
static's reply got me what I needed without using SSMS. I don't understand what you mean by FULL connection string but here's an example of an SSMS query that does work. UPDATE OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\xxxx0001\TEST.MDB')...[TABLE1] SET DEPTNAME = 'deptvalue'...- Neophyte2
- Post #5
- Forum: Modules & VBA
-
N
SQL query to ALTER TABLE ADD COLUMN in Access database
That's awesome - thank you very much. I'm not a programmer or developer so I didn't understand your reply at first but after googling currentdb.execute now I get it. Thanks again!- Neophyte2
- Post #3
- Forum: Modules & VBA
-
N
SQL query to ALTER TABLE ADD COLUMN in Access database
I need to add a column to a bunch of Access 97 databases. The databases all have the same name and identical structures but they're in different folders. If I open each MDB in Access 97 I can run a SQL query to add the column like this: ALTER TABLE table1 ADD COLUMN field5 text(50) However...- Neophyte2
- Thread
- Replies: 5
- Forum: Modules & VBA