 |  |  |  |  |  |  |  |
Shared Database with Jet possible?
 |
I have a database working with VB6 and Jet. Everything works fine except that I now need the database to be accessed from a second machine on the network.
It appears that only one person can be connected at a time to the database using Jet, is this correct?
In the 'DefaultType' of the data method it has the option for Use ODBC, which, from my research, appears to be a more recent and flexible way to access databases. Is this what I need to use to get shared connections to the database?
Is so how do I use it? If I select it and run I get a 'Data source name too long' error.
Many thanks
It appears that only one person can be connected at a time to the database using Jet, is this correct?
In the 'DefaultType' of the data method it has the option for Use ODBC, which, from my research, appears to be a more recent and flexible way to access databases. Is this what I need to use to get shared connections to the database?
Is so how do I use it? If I select it and run I get a 'Data source name too long' error.
Many thanks
More than one person can access it. Never done it with VB6 but its definately possible in .NET, just ensure that record locking is set correctly, and that the data connection is SHARE DENY NONE
If i am helpful, please give me reputation points.
There is an option for 'Exclusive' which I have set to false so I assume this is the same as your 'Share Deny None'
I can't find anything to suggest Record Locking. What does this do? Does it lock the database whilst you are making changes then release it to others after you have made an edit?
Any idea where this is in VB6?
Many thanks for the help.
I can't find anything to suggest Record Locking. What does this do? Does it lock the database whilst you are making changes then release it to others after you have made an edit?
Any idea where this is in VB6?
Many thanks for the help.
nah record locking is actually set within MS access itself under DB properties
and yeah it does, theres different types, e.g lock whole database, lock whole table, lock whole row, or lock whole field, or none (bad)
and yeah it does, theres different types, e.g lock whole database, lock whole table, lock whole row, or lock whole field, or none (bad)
If i am helpful, please give me reputation points.
I think it may be this:
ReadOnly = False or True
If, when compiling the program, I set it to False then I can Write a new record and read etc. But I cant backup the database as it's in use. If I set this to True then I can read data using my program and backup the database but I cant create new records.
So I though I could change this at runtime using Data1.ReadOnly = False when creating a new record then setting it back to True when saved. However I can't seem to change this value at runtime.
Why on earth cant I change this value at runtime???
ReadOnly = False or True
If, when compiling the program, I set it to False then I can Write a new record and read etc. But I cant backup the database as it's in use. If I set this to True then I can read data using my program and backup the database but I cant create new records.
So I though I could change this at runtime using Data1.ReadOnly = False when creating a new record then setting it back to True when saved. However I can't seem to change this value at runtime.
Why on earth cant I change this value at runtime???
|
Similar Threads
- Connect to access database on a shared folder (C#)
- connect to access database over network (C#)
- High cpu in win explorer, task mng - HJ Log (Viruses, Spyware and other Nasties)
- Removing Party POker popups (Viruses, Spyware and other Nasties)
- VB6 or VBA - Copy table contents from one database to identical database (Visual Basic 4 / 5 / 6)
- Explorer wont load. Hijackthis log please help!! (Viruses, Spyware and other Nasties)
- Hijackthis report, I just don't know (Viruses, Spyware and other Nasties)
- can someone help me ive been up for 6 hours (Viruses, Spyware and other Nasties)
- i have an aurora popup, please help (Viruses, Spyware and other Nasties)
- hijackthis log for bridge.dll file missing - yes version 1.99.0 (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: multiple condition update
- Next Thread: inserting character in a string
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
