I am trying to move entire columns between two tables.
The first attempt:
dbsInWater.Execute _
"UPDATE StreamerTable SET StreamerTable.Weights = (SELECT Weights FROM StreamerVars)"
gives me a run-time error 3073
'Operation must use an updatable query'
Second attempt:
Dim ASet As...
I have just moved to Access 2003. I am designing a database as a single user.
All the problems described below occur when I run code from a module.
Problem 1:
Opening the database by double clicking the file in Explorer works fine until I start my code. It stops on the ‘Set dbs =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.