Caulfieldmusic
Thread Starter
- Joined
- Jan 17, 2011
- Messages
- 1
I've built a reasonably complex database system that maintains bookings, attendances, timetables, payments etc for a music tuition school, using Access as both the front and back end. (sigh, only because that's all I have to work with...)
Apart from all of the little annoying bugs and restrictive designs, I've come across an error "the database has been placed in a state by user 'admin'..." commonly referred to as error 3734. I've scoured the net for similar issues and every one of the problems I've found discussed refers to either multi-user databases or opening and closing the mdb repeatedly.
My problem is this is a single user database, only one PC is connected to the database in any way, and it only occurs when I try to run any of the design wizards; either chart wizard or combo box wizard etc...
I've tried restarting the PC, opening the database without running ANY macros or forms and designing a new form, chart wizard, BAM error pops up, can't create any charts.
Could this be because the database is corrupted? I would have thought I'd get other errors if this was so, and so far I haven't except the odd debug due to coding errors...
Now even more strange, after doing NOTHING different, sometimes, maybe 1 out of 20 times it works as per normal, no locking errors...
Any thoughts or ideas would be hugely appreciated!!
As an afterthought, I'd like to re-design the db/interface on a more stable platform, anyone have any suggestions on what database back-end is easy to maintain and import access data into, and what front end is relatively easy to work with and stable?? I was thinking MySQL and VB...
Apart from all of the little annoying bugs and restrictive designs, I've come across an error "the database has been placed in a state by user 'admin'..." commonly referred to as error 3734. I've scoured the net for similar issues and every one of the problems I've found discussed refers to either multi-user databases or opening and closing the mdb repeatedly.
My problem is this is a single user database, only one PC is connected to the database in any way, and it only occurs when I try to run any of the design wizards; either chart wizard or combo box wizard etc...
I've tried restarting the PC, opening the database without running ANY macros or forms and designing a new form, chart wizard, BAM error pops up, can't create any charts.
Could this be because the database is corrupted? I would have thought I'd get other errors if this was so, and so far I haven't except the odd debug due to coding errors...
Now even more strange, after doing NOTHING different, sometimes, maybe 1 out of 20 times it works as per normal, no locking errors...
Any thoughts or ideas would be hugely appreciated!!
As an afterthought, I'd like to re-design the db/interface on a more stable platform, anyone have any suggestions on what database back-end is easy to maintain and import access data into, and what front end is relatively easy to work with and stable?? I was thinking MySQL and VB...