I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.
From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).
Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time
This is the function used to connect.....
Public Function connectpm()
Set cn = New ADODB.Connection
Dim cnstring As String
cnstring = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" & server & "\" & path & "\Patent_ipm_db.mdb"
cn.Open cnstring
End Function
5  2231 
I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.
From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).
Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time
This is the function used to connect.....
Public Function connectpm()
Set cn = New ADODB.Connection
Dim cnstring As String
cnstring = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" & server & "\" & path & "\Patent_ipm_db.mdb"
cn.Open cnstring
End Function
Hi,
Yes, Access Database Can be Opened for Multiple Connections..
Check the Sharing options for the Folder Which has Database.
It should be shared with Complete access.. (Read/Write).
Otherwise, you will get that error.
Regards
Veena
I have a vb6.0 program wherein I am using Access2003 file as a database for information. I put this Access file on a shared folder on our network.
From my laptop, on a VB6 software I did, I can put data on the access file. And then, I installed the software on my friends laptop. When my friend tried to open the software while I am using it, it showed error on the database, saying that someone is still using it (some sort of that).
Can you help me please on how to create Visual Basic 6 programs that allows multiple users to access database at the same time
This is the function used to connect.....
Public Function connectpm()
Set cn = New ADODB.Connection
Dim cnstring As String
cnstring = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" & server & "\" & path & "\Patent_ipm_db.mdb"
cn.Open cnstring
End Function
Please do not post questions in the articles section.
Moved to the forum section.
I haven't shared an access databases before, but I would:
Open the database connection as Read Only when not performing an update.
Close the connection to the database immediatly when done updating and reconnect as read only when finished.
This question was posted twice, so I have merged the two threads.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Tony Clarke |
last post by:
Hi,
Background:
I have written a Call Logging and Reporting System using PHP that integrates
with an existing MS Access Database. The information in the database is all
held in flat tables...
|
by: John |
last post by:
Hello.
I am currently working through a book on Dreamweaver and using PHP. I
am having a little trouble with setting up the database though. I
have php 4.2.3 and MySQL 4.0.20a. I am running...
|
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message...
|
by: et |
last post by:
I have an aspnet program that uses an Access database -- I won't go into why
I'm using Access -- and can't get it to run in share mode.
If I have opened the website, and I try to edit the...
|
by: DaveG |
last post by:
Hi all
I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a...
|
by: Jordan S. |
last post by:
SQL Server will be used as the back-end database to a non trivial client
application.
In question is the choice of client application:
I need to be able to speak intelligently about when one...
|
by: samadams_2006 |
last post by:
I'm having a problem in accessing a Microsoft Access Database in a
VB.NET Web Application. It's so straight forward, I thought I'd walk
you through all the details here:
1) I have a .NET Web...
|
by: Bob Alston |
last post by:
I am looking for others who have built systems to scan documents, index
them and then make them accessible from an Access database. My
environment is a nonprofit with about 20-25 case workers who...
|
by: Rajendran |
last post by:
Hi all,
I've installed pyodbc module to access my database (MS Access). I've
setup a User level DSN to the database.mdb file. When I run my python
code in the command prompt it is retrieving the...
|
by: Mike |
last post by:
I have a multiuser access database to which I have split into fe &
be. The system refreshes the links at each log-on between the fe & be
automatically via code.
PROBLEM:
Locally it runs...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
