is it possible to access/write database ms access 2003 .mdb at the same time?

Posted by tintincute on Super User See other posts from Super User or by tintincute
Published on 2009-12-02T15:53:20Z Indexed on 2010/04/04 20:03 UTC
Read the original article Hit count: 141

Filed under:

microsoft-access

|

microsoft-access-2003

hi

i have a problem, i have a user who created a database using ms access 2003 the problem is, if he's opening the db and made some changes, the other user can open the db but they can't work on it. but if he's exited the program, then the user can make some changes.

i would like to know if its possible; that they can work at the same time when they open the database?

Thanks

I attached a .jpg here to see the program: www.freeimagehosting.net/image.php?ed11af4cc5.jpg

additional jpg: http://www.freeimagehosting.net/image.php?3c60d8e046.jpg

additional question:

I tried to do the "Splitting of Database" here and after I clicked on Split I got an error: "The database engine couldn't lock the table, because it is already in use by another person or process"... what does that mean? Did I lock the table?

www.freeimagehosting.net/image.php?fc52cfc486.jpg

© Super User or respective owner

Related posts about microsoft-access

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Microsoft Access: Customize Forms and Reports

as seen on Internet.com - Search for 'Internet.com'
Our Microsoft application guru Helen Bradley explains how to make Access database forms and reports more functional and attractive. >>> More
Microsoft Access 2007 Certification

as seen on Internet.com - Search for 'Internet.com'
Certification doesn't make one an IT super hero but it's something every developer should consider. Some might argue that there aren't any certifications for Microsoft Access application developers and they would be correct, however, the Microsoft Access 2007 Application Specialist (MCAS) exam might… >>> More
Bulk-Batch Email From Microsoft Access

as seen on Internet.com - Search for 'Internet.com'
If your users collect email addresses in a database, odds are before long, someone's going to get it into their head to send out an email "blast" or batch. There are several approaches, but what you really need is an engine to send individualized emails, one at a time... >>> More
SharePoint and Microsoft Access - Getting Motivated

as seen on Internet.com - Search for 'Internet.com'
Its time that Access specialists discover just how much Access has in common with Microsoft SharePoint. Read on to learn more. >>> More

Related posts about microsoft-access-2003

SSIS: How to create and export data to Microsoft Access 2003 database?

as seen on Server Fault - Search for 'Server Fault'
Goals - Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package) There is no "Access DB Destination" in BI toolbox. So the question is, How can I create an Access database (for me to load data to)? >>> More
Microsoft Access 2003 menu bar is missing under toolbar customize

as seen on Super User - Search for 'Super User'
Last time I was trying to hide the menu bars in my existing database. I added code in my module which I found on the internet. But now when I start Access I can't find the menu bars where I can usually see the File, Edit etc. I tried to restore the default, the menu bar can't be found under the… >>> More
Unable to remove master -> child subform links in microsoft access 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am having an issue removing the master - child link fields in an access subreport data form. I have tried every avenue to remove them, using the properties window of the subreport as well as the link wizard. I have also deleted the subreport from the database and then gone as far as re-importing… >>> More
Linked Tables not working With Access Database

as seen on Super User - Search for 'Super User'
Hi, I have an Access database in a computer and I want to access it from other computer in the network. so I made mapped drive and created Linked Tables, then Imported all the objects (forms, queries, reports). when I open access database in the second computer and make any changes in using the forms… >>> More
The database engine couldn't lock the table, because it is already in use by another person or proce

as seen on Super User - Search for 'Super User'
Hi I tried to do "Split a Database" and after I clicked on the "Split" button, here is what I got: "The database engine couldn't lock the table, because it is already in use by another person or process" Any idea? Thanks additional question: is it possible to split your database many times… >>> More