Recent content by veerachai

MSysAccessObjects locked on Tables backup to other DB I found reason of locked already. Access normally have hidden table called SYSTEM Objects (can see by go to Tools > Option > View and mark "System Objects" to unleash it), that not allowed to be deleted or replace. Once we try to...

Finally I found correct coding Private Sub Command33_Click() On Error GoTo Err_Command33_Click Dim BUpath As String Dim obj As AccessObject, dbs As Object, PRname As String BUpath = Application.CurrentProject.Path & "\Ritcha BU.mdb" MsgBox "Program will start Back up Tables at " & BUpath Set...

I would like to transfer all existing tables (only table, to save space) on my present database to another database for back up, by let program check and type out all table names by there own, no need for me to type one by one under fixed name. Can someone help give me code Best Rgds VJ

Backup all tables to other DB I try to back up all my tables to another DB with below code, it's work for for some certain number of tables only. After a while "transfer object method" was locked and won't unlocked further. Then coming out the below message Code: Dim BUpath As String Dim...

"OLE Server isn't registered" error msg on open Pivot Form I try this solution already,but it still error. Isn't it just for Data Access Page only How about on Pivot Form Open Pls help if someone know how to solve Thks Veerachai

Hello, I have a form with a pivot table. It used to work until recently. Now when I try to open the form, I get the message "The OLE Server isn't registered. To register OLE server, reinstall it". I tried to reinstall and repair MS Office but it did not work. Any suggestions please?