473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ADODB error message in access 2000

48
hello
I'm running XP and using access 2003
Every time i try to run my database i get the following error

Runtime error -2147467259 (80004005) The database has been placed in a state by Admin, that prevents the machine from being opened or locked

I can just ignore the message by clicking end, and it will work, but i'm worried it will give me problems later because it will be accessed by all the users in the company. sometimes i get a message saying i cannot save any the changes that I've made.

When the error pops up, if i click on debug it highlights the "ado.Open strConnection" . as shown below

Expand|Select|Wrap|Line Numbers
  1. Dim ado As ADODB.Connection
  2.  
  3. strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" &                                 CurrentProject.Path & "\Table1.mdb;"
  4.  
  5. ado.Open strConnection
i've tried changing the references but that didn't help the situation and i havn't installed or uninstalled any software of late.

Thankyou for your help
Sep 17 '08 #1
9 1613
FishVal
2,653 Expert 2GB
Hello.

That usually happens because somebody didn't save module having written the code in.
While db contains any unsaved design changes it is "placed in a state by ... on machine ... that prevents it from being opened or locked".

BTW, you should not create ADO connection, because you already have one available via CurrentProject.Connection property.

Regards,
Fish
Sep 17 '08 #2
zandiT
48
Hi FishVal
Thankyou for the quick reply. so if i don't use ADO then how else can i get the records in the table to my unbound form. i tried using DAO but that was a disater. should i remove the CurrentProject part and continue with ADO?

Okay here's the deal:
i have 2 tables and one form. all i want to do is to access the tables in the form so the users can manipulate the records whichever way they want and save the changes to the main table.
originally i had created the form using the wizard and bound the table(s) to the form and it worked fine with a lot of VBA. the only problem is i found out just recently that the database is going to be placed on the server and accessed by the whole company. different users with different levels of access etc. so i decided to "restructure" it and now its a lot harder than i thought. i'm very new to this and a bit overwhelmed. As an expert, do you think i should leave it the way it was originally and just pile on more VBA code to further its functionality or is there another way out? your adice is much appreciated
ZandiT
Sep 17 '08 #3
zandiT
48
Hi FishVal
Thankyou for the quick reply. so if i don't use ADO then how else can i get the records in the table to my unbound form. i tried using DAO but that was a disater. should i remove the CurrentProject part and continue with ADO?

Okay here's the deal:
i have 2 tables and one form. all i want to do is to access the tables in the form so the users can manipulate the records whichever way they want and save the changes to the main table.
originally i had created the form using the wizard and bound the table(s) to the form and it worked fine with a lot of VBA. the only problem is i found out just recently that the database is going to be placed on the server and accessed by the whole company. different users with different levels of access etc. so i decided to "restructure" it and now its a lot harder than i thought. i'm very new to this and a bit overwhelmed. As an expert, do you think i should leave it the way it was originally and just pile on more VBA code to further its functionality or is there another way out? your adice is much appreciated
ZandiT
Sep 17 '08 #4
FishVal
2,653 Expert 2GB
Hi FishVal
Thankyou for the quick reply. so if i don't use ADO then how else can i get the records in the table to my unbound form. i tried using DAO but that was a disater. should i remove the CurrentProject part and continue with ADO?
O_O

What did you mean by this?
I've just suggested you not to open a new ADO connection, because you already have one permanently accessible via CurrentProject.Connection property.

Okay here's the deal:
i have 2 tables and one form. all i want to do is to access the tables in the form so the users can manipulate the records whichever way they want and save the changes to the main table.
originally i had created the form using the wizard and bound the table(s) to the form and it worked fine with a lot of VBA. the only problem is i found out just recently that the database is going to be placed on the server and accessed by the whole company. different users with different levels of access etc. so i decided to "restructure" it and now its a lot harder than i thought.
i'm very new to this and a bit overwhelmed. As an expert, do you think i should leave it the way it was originally and just pile on more VBA code to further its functionality or is there another way out? your adice is much appreciated
ZandiT
That all depends on what you actually want to enhance in your database. ;)
Could you specify what are your concerns with current configuration?
Sep 17 '08 #5
zandiT
48
its been made mainly from wizards and vba code here and there and i thought it wouldn't be best practice to implement a database with such a structure for a medium sized multi user environment, with concurrency and speed issues etc. thats why i started using Ado and made a big mess of things. i don't even know much about but i got some stuff from the net a a few books but it didn't help much.
i just want the database to function in a multi user environment and i was looking for the best way to develop it. using the wizards and vba or starting from fresh with ADO or DAO?
Sep 17 '08 #6
FishVal
2,653 Expert 2GB
its been made mainly from wizards and vba code here and there and i thought it wouldn't be best practice to implement a database with such a structure for a medium sized multi user environment, with concurrency and speed issues etc. thats why i started using Ado and made a big mess of things. i don't even know much about but i got some stuff from the net a a few books but it didn't help much.
i just want the database to function in a multi user environment and i was looking for the best way to develop it. using the wizards and vba or starting from fresh with ADO or DAO?
There are several ways to upsize Access database to multiuser enviroment.
The following depends on your network performance. So, check it first - simply by opening database from network drive.
  • Access database could work pretty fine with somewhat about 3-7 users just as single file on shared drive.
  • If it is not your case, then try to split your database to single back-end and multiple front-ends - according to specification Access supports up to 255 concurrent users.
  • And at last you may think about upsizing to SQL server.

P.S. The only advantage you may get from creating unbound form is that you could perform a remote connection - connect to database only when user queries or updates data. And that is not a simple coding. ;)

P.P.S.
... database is going to be placed on the server ...
BTW, what does "server" state for?
Sep 17 '08 #7
zandiT
48
Thankyou so much for the advice
i'm going to leave it as it was before, when it was working, then split it and see where it goes from there. the network speed is pretty good and there will be around 30 people accessing the database. sorry i didn't understand your question about "server" state?? thanks a bunch
Sep 17 '08 #8
FishVal
2,653 Expert 2GB
Thankyou so much for the advice
i'm going to leave it as it was before, when it was working, then split it and see where it goes from there. the network speed is pretty good and there will be around 30 people accessing the database.
Well. I almost sure that with good network speed, 30 users and only 2 tables overall performance will be good enough.

sorry i didn't understand your question about "server" state?? thanks a bunch
Is it file server or just a shared folder?
Or, though I almost sure it is not, is it database server?

Regards,
Fish
Sep 17 '08 #9
zandiT
48
Its a file server, thats why i'm going to split it.i'll cross that bridge when i get there, right now i have to make it function. different levels of access and the rest of it. thanks again
Sep 18 '08 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: Patrick | last post by:
I understand that with IIS5.1 on Windows XP Professional SP1, I can 1) Either set under IIS Manager-> Any specific Virtual Directory-> Configuration->Options->ASP Script timeout for all pages...
5
by: Simone | last post by:
Hello I hope you guys can help me. I am very new to ADO... I am creating a ADODB connection in a module and trying to access it from a command button in a form. Function fxEIDAssgn(plngEID As...
1
by: Nigel C | last post by:
Access 2000 - A am trying to access another Access 2000 database from a code module. I have seen examples of the ADODB connection string - to connect to an access database however the database...
6
by: ASP.Confused | last post by:
I have an ASP.NET page writtein in VB that uses ADODB. I just had to force-install MDAC 2.8 after I tried to rollback to 2.6 (my web host uses this, and I wanted to be compatible with them.) I...
0
by: ASP.Confused | last post by:
The old message looked a little stale, so I am re-posting it here. Anybody have any ideas of what I could do?!? The previous responses to this question are below. If you want to look at the...
3
by: Joe Befumo | last post by:
I'm getting the following error in my application: Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined. Source Error: Line 112: if(Request.Form("HdnQuestionCount") =...
4
by: T | last post by:
-------------------------------------------------------------------------------- I tried this audit trail code, using 2003 and it works great, I try and use it at work w/97 and it blows up:...
8
by: Ben | last post by:
Hi! I already sent this to the ACCESS newsgroup. But since I do not know really which side is really causing the problem, I have decided to send this inquiry to this newsgroup also, if I may....
5
by: muriwai | last post by:
Hi, I have a C# assembly project under Visual Stuio 2008 Pro on Windows Server 2008. I converted the project from VS 2005. The project references COM->Microsoft CDO for Windows 2000 Library...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.