VB 6.0 - CODING FOR VB & ACCESS AS MULTIUSER
Asked By Chandan Mukherjee
05-Feb-10 04:17 AM
Dear all,
I want to develop one multi user application using vb as fornt end & access as back end. Now, I want help regarding connection between VB & Access.
1. Is it possible to use Access as Multi User Database, if possbile please provide same sample coding how to connect the database and at the time of inserting/deletion/update what should I do.
Please help
Chandan
Adil Saud replied to Chandan Mukherjee
Hi
Yes you always use the access database in a multi user environment, there is no issue in this(depends on the size and type of use)
code is pretty simple :
Dim con As New OleDb.OleDbConnection
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source C:\AddressBook.mdb"con.Open()
MsgBox("A Connection to the Database
is now open")
con.Close()
MsgBox("The Connection to the
Database is now Closed")
Where C:\AddressBook.mdb is the acess database you want to connect.
thnx
Adil...:))
Access will start to get flaky at around ten simultaneous connections over a mapped drive
If you keep the number of simultanoues users to a minimum, you'll be fine. Access is not specifically designed for multi-user applications although it does work.
SQL content from access database DataBase I have connection to Access database and a name of a view Dim Conn As New System.Data.OleDb.OleDbConnection Conn String = ". . ." I would like to programmatically find out the inner content of the SQL query (Access) Dim SqlContent As String = ? The purpose is not to read data from this view, but the SQL only! Hope to get help Roman * ** Sent via Developersdex http: / / www.developersdex.com * ** Access Discussions VB.NET (1) VBA (1) Database (1) SqlContent (1) ViewName (1) Helptext (1) System.Data.OleDb
Search for Keyword In Access Database VB.net Morning Peoples! Wonder if you can help, i am stil;l working on the program that is connecting to an access database. I have got the program to communicate with an access database, create new, edit and save new information. The only problem that I have is with be a simple count. I need the program to look at a table in the database and count how many times a specific keyword is in the column and return the
Need vb script / macro to append table in access database A to datab DataBase Need vb script or macro to append a table in access database A to table of the same name in access database B Access Macros Discussions Database (1) DougSteele (1) TableName (1) Datab (1) Actually, you
Compact and Repair Access database C++ / VB Hello, How do I programmatically Compact and Repair an Access database? I found several examples, on how to Compact and Repair an Access database using VB, but I have not found any examples using VC++ / MFC. TIA -jc VC MFC Discussions
Protecting an Access Database DataBase I have built an Access database a while ago and I have gained a lot of interest in the database. I now need to protect it so no one can change any of the data or applications within it i.e. make it equivalent to a read only file or database some how. I have hidden the database window so only the display screen an menu options can be accessed but this does