Hello,
I'm having a bit of a problem regarding my back-end database for Access 2003. The db is set for shared mode, has no programming code at all, only back-end tables that is shared on our server, that everyone accesses. Everything has been working fine up until today.
So today I need to add about 20 fields to one of our tables (making the total about 40 fields in all for this one table). When I go to save the table, it tells me that I can't because there are too many fields (there aren't). Actually, if I update add even one field it tells me that's too many. So I say "OK, I'll compact the database" wrong again. It attempts to compact and repair the db but it tells me that "You attempted to open a database that is already opened exclusively by user 'Administrator' on machine '[my machine]'. Try again when the database is available".
Of course, the Administrator on my machine is me! So I close all my programmes, try again - no good. I restart my computer - no good. I kick everyone who is working on my database off of their computers and close Access - still no good.
I'm starting to get worried that I'm never going to be able to make any changes to my table fields again. Is this normal?
Thanks!
-BG