I have a split database. I am in the ongoing effort of correcting and standardizing my naming convention. Is there any way to change the name of a table inagent1of6
Adam- Get rid of the second reference to tblUpdateBE after the UPDATE keyword. But why are you setting a field equal to itself? That makes no sense. Johnjlviescas
The following query worked when the linked BE was in Access. After moving to SQL, I get a Run-time error 3073, must use updateable query. stSQL = "UPDATErunuphillracing
Please Note: New Members will have their posts moderated for a period of time so we can be sure you are a real member and not a spammer. Sorry for the inconvenience.
Please Note: We do not allow job postings or recruiting at this site. Doing so will only get you banned.
Whether you are seeking help in database design, user interface, complex MS Access VBA code, MS SQL Server, we can help.
Our membership includes several MS Access MVPs and questions are answered quickly and accurately! Our Archive contains many sample databases, Utilities, Add-ins, code samples and more.
Share your knowledge and it will come back to you ten-fold!
For more accurate answers, please indicate which software version you are using when asking a question.
- Microsoft Access
- Mar 28, 2002
- This is a restricted group.
- Attachments are not permitted.
- Members can hide email address.
- Listed in Yahoo Groups directory.
- Membership requires approval.
- Messages from new members require approval.
- All members can post messages.