ID is not an index in this table is Access error 3800 and indicates likely corruption, almost certainly in one of your system tables.
Did you try importing all objects (except system tables) into a new blank database?
isladogs
Last Activity: Jul 2 '25, 10:53 PM
Joined: Jul 21 '07
Location: Somerset, UK
-
Access Europe Video from Wed 4 June Meeting
The video of Domenico Ruggiero's presentation to the Access Europe User Group on Wed 4 June is now available on YouTube:
https://youtu.be/ZXtxh63d-fgThe topic was Orchestrating Office. I hope you enjoy it.Next month, Wed 2 July, Pete Poppe (MajP) returns with what I know will be another excellent presentation: Faking ‘Non-Normal’ User Interfaces with Normal Data -
Access Europe Video from Wed 4 June Meeting
The video of Domenico Ruggiero's presentation to the Access Europe User Group on Wed 4 June is now available on YouTube:
https://youtu.be/ZXtxh63d-fgThe topic was Orchestrating Office. I hope you enjoy it.Next month, Wed 2 July, Pete Poppe (MajP) returns with what I know will be another excellent presentation: Faking ‘Non-Normal’ User Interfaces with Normal Data -
isladogs replied to Access Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)in AccessNOW AVAILABLE ON YouTube
The video of Karl Donaubauer's presentation to the Access Europe User Group on Wed 7 May during which he explained how best to identify, report and manage the impact of any update bugs
Video URL: Update, update ... the company is in a state!Last edited by isladogs; May 12 '25, 08:32 AM.Leave a comment:
-
For info, MSysDb is a system object present in all Access databases. It is not a system table and cannot be directly accessed / queried.
MSysDb stores the database properties as shown in the Database Documenter. See my article: Long Value Binary fields
Its unusual for that object to get corrupted but if it does so, your only course of action is to see what you can recover either using built-in Access tools or recovery software.Last edited by isladogs; May 5 '25, 10:02 PM.Leave a comment:
-
isladogs started a topic Access Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)in AccessAccess Europe - Wed 7 May: Update, update, the company is in a state (Karl Donaubauer)
The next Access Europe User Group meeting will be on Wednesday 7 May 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are very pleased to welcome back Karl Donaubauer from Austria. Karl has been an Access MVP for over 27 years and has long been a champion for the Access community. He organises two annual Access conferences (DevCon and AEK), co-ordinates the Access Forever blog site and had... -
isladogs replied to Access Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)in AccessThe video of Anders Ebro's excellent presentation on Class Modules to the Access Europe User Group on 2 April is now available on YouTube:
http://https://www.youtube.com/watch?v=9chkPUV dvcw
Enjoy!Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)in AccessAccess Europe User Group - Wed 2 Apr: Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)
The next Access Europe User Group meeting will be on Wednesday 2 Apr 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
I hope you will join us on Wed 2 Apr for this session. For local start times, please check https://www.worldtimebu ddy.com
Note that the UK, Europe and North America will all have changed to daylight savings times so relative start times will be unchanged.
This session is based on... -
isladogs replied to Access Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)in AccessThe video of Philipp Stiefel's superb presentation on COM Add-Ins to the Access Europe User Group is now available on YouTube: https://youtu.be/kisZ7CbBSXk
A PDF of the presentation slides is now available to download from:https://isladogs.co.uk/aeu-35/
Enjoy!...Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)in AccessAccess Europe User Group - Wed 8 Jan: Developing COM Add-Ins for Access (Philipp Stiefel)
The next Access Europe User Group meeting will be on Wednesday 8 Jan 2025 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
Note that the date is one week later than normal to avoid clashing with New Year celebrations.
In this presentation, former MVP, Philipp Stiefel will demonstrate how to develop COM add-ins for Microsoft Access.
COM add-ins can be used to extend the development...Last edited by isladogs; Dec 29 '24, 06:26 PM. -
Which specific Access version / build / bitness / channel are you having problems with?Leave a comment:
-
isladogs replied to Access Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)in AccessThe video of Adrian Bell's excellent presentation to the Access Europe User Group is now available on YouTube:
AEU34: Custom Ribbons Usng CommandBars (Adrian Bell)Leave a comment:
-
isladogs started a topic Access Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)in AccessAccess Europe User Group - Wed 4 Dec: Custom Ribbons Using Command Bars (Adrian Bell)
The next Access Europe User Group meeting will be on Wednesday 4 Dec 2024 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
In this presentation, fellow UK MVP, Adrian Bell (AKA Bytes.com moderator @NeoPa) will demonstrate how to create custom ribbons using command bars.
Adrian will first demonstrate a technique based on the original Office CommandBar (CB) objects that allows CommandBarButto ns (CBBs)... -
isladogs started a topic Access Europe User Group - Wed 6 Nov: An Image/Photo Cataloguer (Chris Arnold)in AccessAccess Europe User Group - Wed 6 Nov: An Image/Photo Cataloguer (Chris Arnold)
The next Access Europe User Group meeting will be on Wednesday 6 Nov 2024 starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM).
In this month's presentation, Chris Arnold, will demonstrate his very versatile image/photo cataloguer.
The cataloguer allows the user to catalogue the pictures – perhaps a place name, a project, a person, an event or maybe your trainspotting or floral collection.
It...Last edited by isladogs; Oct 27 '24, 07:23 PM. -
Access Lunchtime User Group - Tues 29 Oct
Maria Barnes (MVP) will be leading a presentation for the Access Lunchtime User Group on the new Monaco SQL Editor for Access which is likely to be released to Access 365 Current Channel users by the end of this month.
The meeting starts at 12 noon CST (US - Central Standard Time) which is UTC-5. See the above link for connection details.
NOTE: For those in the UK, for this month ONLY, the meeting will start one hour earlier than...Last edited by isladogs; Oct 27 '24, 05:08 PM. -
isladogs replied to Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)in AccessThe video of the excellent presentation by Pete Poppe (Maj P) to Access Europe last week is now available on YouTube.
It was by far the best explanation of when & how to use treeviews successfully that I've ever seen.
Well worth watching if you missed it ...and to watch again for those were present!
https://youtu.be/XpEHuWcHang...Leave a comment:
-
isladogs started a topic Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)in AccessAccess Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)
The next Access Europe User Group meeting will be on Wednesday 7 Aug 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome Pete Poppe who is very well known on several Access forums as MajP
In this session, Pete will introduce the Treeview control and demonstrate when it can greatly benefit the display of certain types of data within Access applications.... -
isladogs replied to Access Europe - Wed 3 July: Improved, Enhanced Message Box (Olaf Nöhring) ; Enhancing Access forms (André Minhorst)in AccessThe video of last week Access Europe meeting is now available on YouTube:
https://www.youtube.com/watch?v=hgq1t8JeGew
A PDF of each presentation is also available from https://www.isladogs.co.uk/aeu-29/
There were some internet connection issues which affected the host.
Luckily this had no effect on the two excellent presentations.
Enjoy!...Leave a comment:
-
isladogs started a topic Access Europe - Wed 3 July: Improved, Enhanced Message Box (Olaf Nöhring) ; Enhancing Access forms (André Minhorst)in AccessAccess Europe - Wed 3 July: Improved, Enhanced Message Box (Olaf Nöhring) ; Enhancing Access forms (André Minhorst)
The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst.
Olaf will demonstrate his improved version of the Enhanced Message Box which was originally developed by Renaud Bompuis about 15 years ago.
It is (almost) a drop-in... -
isladogs replied to Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasksin AccessThe video of my presentation to Access Europe on Wed 5 June is now available on YouTube: https://www.youtube.com/watch?v=jUed-4aCUxs
Hope others find it useful
There were two separate parts to the session.
A PDF of each presentation together with the two example databases used in the session are available from https://www.isladogs.co.uk/aeu-28/Leave a comment:
No activity results to display
Leave a comment: