DAO Error 3028
-
Hi, I'm working on a VB6 solution that's using two access databases. One "local" database that is always accessible, located in the same folder as the application and another "remote" database that could reside either on the same computer or on a network drive. At the start-up of my application I have to open the local database and read in some settings. It all works great but here's the problem: If I unplug the internet cable from the computer I get the following error trying to open the local database -- Error 3028: "Can't start your application. The system database is missing or opened exclusively another user." What is really puzzling is that the local database has nothing to do with the remote one (which may be located on a network drive that may be disconnected by removing the network cable) and yet it doesn't let me open it. In my code I'm using DAO methods to open the database in non-exclusive mode such as:
Dim db as Database db = OpenDatabase("",False,False,";DATABASE='C:\Work\MyProject\local.mdb'; PWD='passcode'")This happens running on a Windows NT 4.0 Workstation.. does naybody have any ideas what might be causing this and if you do.. how can I get around it? Thanks for any info you might have/share Mikk -- modified at 17:22 Monday 17th October, 2005
-
Hi, I'm working on a VB6 solution that's using two access databases. One "local" database that is always accessible, located in the same folder as the application and another "remote" database that could reside either on the same computer or on a network drive. At the start-up of my application I have to open the local database and read in some settings. It all works great but here's the problem: If I unplug the internet cable from the computer I get the following error trying to open the local database -- Error 3028: "Can't start your application. The system database is missing or opened exclusively another user." What is really puzzling is that the local database has nothing to do with the remote one (which may be located on a network drive that may be disconnected by removing the network cable) and yet it doesn't let me open it. In my code I'm using DAO methods to open the database in non-exclusive mode such as:
Dim db as Database db = OpenDatabase("",False,False,";DATABASE='C:\Work\MyProject\local.mdb'; PWD='passcode'")This happens running on a Windows NT 4.0 Workstation.. does naybody have any ideas what might be causing this and if you do.. how can I get around it? Thanks for any info you might have/share Mikk -- modified at 17:22 Monday 17th October, 2005
mikanu wrote:
If I unplug the internet cable from the computer I get the following error trying to open the local database -- Error 3028: "Can't start your application. The system database is missing or opened exclusively another user." What is really puzzling is that the local database has nothing to do with the remote one (which may be located on a network drive that may be disconnected by removing the network cable) and yet it doesn't let me open it. In my code I'm using DAO methods to open the database in non-exclusive mode such as: Dim db as Databasedb = OpenDatabase("",False,False,";DATABASE='C:\Work\MyProject\local.mdb'; PWD='passcode'") This happens running on a Windows NT 4.0 Workstation.. does naybody have any ideas what might be causing this and if you do.. how can I get around it?
Where is the system database located? This maybe causing the problem, if it’s on a network share and there is a loss of network connectivity. A quick search of the MSDN indicates this error code is security – system db related. You might try specifying a local system database before opening the database. DAO Error 3028[^] DAO error 3028 may occur when you try to create a workspace DAO object [^]
DEBUGGING : Removing the needles from the haystack.
-
mikanu wrote:
If I unplug the internet cable from the computer I get the following error trying to open the local database -- Error 3028: "Can't start your application. The system database is missing or opened exclusively another user." What is really puzzling is that the local database has nothing to do with the remote one (which may be located on a network drive that may be disconnected by removing the network cable) and yet it doesn't let me open it. In my code I'm using DAO methods to open the database in non-exclusive mode such as: Dim db as Databasedb = OpenDatabase("",False,False,";DATABASE='C:\Work\MyProject\local.mdb'; PWD='passcode'") This happens running on a Windows NT 4.0 Workstation.. does naybody have any ideas what might be causing this and if you do.. how can I get around it?
Where is the system database located? This maybe causing the problem, if it’s on a network share and there is a loss of network connectivity. A quick search of the MSDN indicates this error code is security – system db related. You might try specifying a local system database before opening the database. DAO Error 3028[^] DAO error 3028 may occur when you try to create a workspace DAO object [^]
DEBUGGING : Removing the needles from the haystack.
Thanks for the reply! Actually, I did search MSDN for this error but that didn't clear it anymore. Your statement is intresting though:
sfdougl wrote:
Where is the system database located? This maybe causing the problem, if it’s on a network share and there is a loss of network connectivity
yet I don't understand why it would be a problem: The system database thata I'm using is the default that access is using, that is located in C:\Windows\System32\system.mdw... which is not on a network share... at least is shouldn't be... it's local, on my hard drive. It's really weired. So, if the system.mdw is in my windows folder... any ideas why I may be getting that 3028 error? (The file is there, it's not read only.. it doesn't appear to be opened by anybody... and MS Access itself is able to open the database without yelding an error) Any ideas will be greatly appreciated!!!
-
Thanks for the reply! Actually, I did search MSDN for this error but that didn't clear it anymore. Your statement is intresting though:
sfdougl wrote:
Where is the system database located? This maybe causing the problem, if it’s on a network share and there is a loss of network connectivity
yet I don't understand why it would be a problem: The system database thata I'm using is the default that access is using, that is located in C:\Windows\System32\system.mdw... which is not on a network share... at least is shouldn't be... it's local, on my hard drive. It's really weired. So, if the system.mdw is in my windows folder... any ideas why I may be getting that 3028 error? (The file is there, it's not read only.. it doesn't appear to be opened by anybody... and MS Access itself is able to open the database without yelding an error) Any ideas will be greatly appreciated!!!
mikanu wrote:
Any ideas will be greatly appreciated!!!
I know ADO fairly well and have forgotten just about everything related to DAO so not sure I can be of much help, but here goes. Are you using Access permissions? Or just a plain simple database password? I think the problem my be related to how your opening a connection to the db. Check out this MSDN link for opening a connection to the db. As memory servers if you don’t open the db correctly you will get flaky behavior. OpenDatabase Method[^]
DEBUGGING : Removing the needles from the haystack.
-
mikanu wrote:
Any ideas will be greatly appreciated!!!
I know ADO fairly well and have forgotten just about everything related to DAO so not sure I can be of much help, but here goes. Are you using Access permissions? Or just a plain simple database password? I think the problem my be related to how your opening a connection to the db. Check out this MSDN link for opening a connection to the db. As memory servers if you don’t open the db correctly you will get flaky behavior. OpenDatabase Method[^]
DEBUGGING : Removing the needles from the haystack.
I'll check it out... Thanks! I figured it must be related to the open database process since it's the first db-related operation in my code and it fails. The question remains: How can I tell VB to create a workspace for me and specify the fisical location of the .mdw file... guess I'll have to dig deeper! Thanks again!
-
I'll check it out... Thanks! I figured it must be related to the open database process since it's the first db-related operation in my code and it fails. The question remains: How can I tell VB to create a workspace for me and specify the fisical location of the .mdw file... guess I'll have to dig deeper! Thanks again!
mikanu wrote:
I figured it must be related to the open database process since it's the first db-related operation in my code and it
try the methods provided by the MSDN, I cant dig any deeper as my dev computer is boxed up waiting to be moved...
DEBUGGING : Removing the needles from the haystack.