Visual Basic :: Can ASP && VB6.0 Access Microsoft Access Database At The Same Time?

RUN-TIME ERROR:[Microsoft][ODBC Microsoft Access Driver]cannot Update
Error message; Cannot Update1 Database or object is read-only?

please help me? i'm having a prolem updating my tblSubject in my database. here's my code:

Dim Record As New ADODB.Recordset
Private Sub Form_Load()
     SQL = "Select a.*, b.Subj_Desc, b.Subj_Units From tblSubj_Intrc a, tblSubjects b " _
        & "Where a.Subj_Code = b.Subj_Code"

    Record.Open SQL, MyConn, adOpenStatic, adLockOptimistic

    getFields
    SetLock (True)
    Set_Buttons
End Sub
Sub getFields()

    If Record.EOF Or Record.BOF Then
        MsgBox "Wala nay Recordord"
        Exit Sub
    End If

    txtDesc = Record!Subj_Desc
    txtSubCode = Record!Subj_Code
    txtUnits = Record!Subj_Units
    txtNum = Record!Num_Stud
End Sub
Sub ClearFields()
    txtDesc = ""
    txtSubCode = ""
    txtUnits = ""
    txtNum = ""
End Sub

Sub SetButtons()
    cmdAdd.Enabled = False
    cmdEdit.Enabled = False
    cmdDel.Enabled = False
    cmdSave.Enabled = True
    cmdCancel.Enabled = True
End Sub
Sub Set_Buttons()
    cmdAdd.Enabled = True
    cmdEdit.Enabled = True
    cmdDel.Enabled = True
    cmdSave.Enabled = False
    cmdCancel.Enabled = False
End Sub
Sub SetLock(Stat As Boolean)
    txtDesc.Locked = Stat
    txtSubCode.Locked = Stat
    txtUnits.Locked = Stat
    txtNum.Locked = Stat
End Sub
Private Sub cmdLast_Click()
    If Record.RecordCount > 0 Then
        Record.MoveLast
        getFields
    End If
End Sub
Private Sub cmdNext_Click()
    If Record.RecordCount > 0 Then
        Record.MoveNext
        getFields
    End If
End Sub
Private Sub cmdPrev_Click()
    If Record.RecordCount > 0 Then
        Record.MovePrevious
        getFields
    End If
End Sub
Private Sub cmdFirst_Click()
    If Record.RecordCount > 0 Then
        Record.MoveFirst
        getFields
    End If
End Sub
Private Sub cmdAdd_Click()
    ClearFields
    SetButtons
    SetLock (False)
    txtDesc.SetFocus
    EditMode = False
End Sub
Private Sub cmdSave_Click()
    If Not EditMode Then
        Record.AddNew
        Record!Subj_Desc = txtDesc
        Record!Subj_Code = txtSubCode
        Record!Subj_Units = txtUnits
        Record!Num_Stud = txtNum
        Record.Update
        SetLock True
        Set_Buttons
    Else
        Record!Subj_Desc = txtDesc
        Record!Subj_Code = txtSubCode
        Record!Subj_Units = txtUnits
        Record!Num_Stud = txtNum
        Record.Update
        SetLock True
        Set_Buttons
    End If
End Sub

Tnx1

Importing Microsoft Excel Files Into Microsoft Access Database?
Hello, I was wondering how to automate Microsoft Access to import a Microsoft Excel File? I can do it normally, but I want to know how (or what commands to use) so that my Visual Basic program will create a Microsoft Access database from a Microsoft Excel spreadsheet internally?

Any help will be appreciated - Thanks.

Access A Microsoft Access Database
Hi,
I am trying to connect to an Access database using ADO in visual basic. Can anyone help me with this. I don't know how to compose the connection string.

Microsoft Access Database
I have program where the database store as table in Microsoft Access database.

If I do package and deployment Wizard, Does I have to copy the Microsoft Access database that contains password table to target machine or it also include during package and deployment Wizard ?

Does Client Machine need to be install Mircosoft Access software?

Microsoft Access Database In Vb 6
HI,
How do you connect to a database then read/write to it?
Many Thanx
jjohall2000

Microsoft Access Database
In my application I use Microsoft Access database.
I want users to access this database using my application.
But I don’t want users to access the database

What are the available methods to do this …

Send The Current Time And Date Using Vb To Microsoft Access
hi
i need help , i want to send the current time and date using vb to microsoft access. i tried to use this code for time and date and its working, but i don't know how to send it

Private Sub Command1_Click()

Dim MVDT As Variant
MVDT = Now()
MVDT = Format(MVDT, "dd/mm/yy hh:mm:ss")
Label.Caption = MVDT

End Sub

note: i'm using

Set DBConn = New Connection

DBConn.Open "Provider= Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "customer.mdb;Persist Security Info = False; Jet OLEDB: Database"

Edited by - afrah on 12/4/2005 9:24:58 AM

Time To Call The Shots : Xeon VS. Microsoft Access
First, I apologise for posting this thread in the VB forum, cos' in the first place, the nature of this thread is not totally VB-related.
I don't wanna anger or offend the many warm-hearted VB programmers here, like AIO, CoolBiz, Praymond, John G. Duffy, JeffB(a.k.a Jeff Bezos) and lots of others.

Now, I'm getting kinda berserk and mad over my school's assignment.
Now, if you please, do hear me out.
No no......I'm not trying to get folks to complete my assignment totally or anything.

U see, it's like this :

I'm given a darn VB project that's suppose to allow the user to add, delete and search records in 3 tables : Customers table, Products table, and last but not least, the Sales Transactions table, all in a database file.
We were suppose to write/read the values from this database file, to and fro the tables and such.
The thing is : I've already completed coding and everything of the Customers and Products table. All is fine and if I can't get high marks for 'em, I'll never be a man again.

The thing now is : the Sales Transactions table. In my project, you actually need to create a relationship between the Customers, Products and Sales Transaction tables.
This is due to the nature of a typical Sales Transaction :
1) Sales Transaction No.
2) Customer No. of the customer who purchased the products
3) Name and address of customer
4) Date on which current transaction was carried out
5) Name and price of products purchased
6) Total quantity of products and grand total

The thing is : I dunno anything about creating a link/relationship between the Customers, Products and Transactions table using Microsoft Access!!!!!! God!!!!!!
This is very pathetic and a total shame, cos' imagine you've everything working like perfect and now this one single spoiler that will pull down all your marks to as low as the Abyss.

So, I was thinking of getting someone to create this Transactions table for me and establish the relationships as well.
Once I've this underlying database structure ready, writing and reading to/fro the file using VB code would be darn simple and such.

And in return, I would do anything! Anything! Maybe you would like to trade porn sites etc, or maybe I can create icons for you and your programs. Mind you, I can create respectable icons that will boost the image and selling-point of your programs, pal.

So, if you're interested, do reply to this thread, send me a private message, or mail me at : xeonboy@hotmail.com, so that we can discuss the details.
You don't need to be a VB programmer or have any previous database programming knowledge anything, although if you're, then probably things would be easier to explain.

Thanks a lot for your time! See you!
Xeon.

SQL In VB6.0 For Accesing Microsoft Access Database
Can you please take a look at the code below and tell me what is wrong:

demand = "SELECT [Tabelle Kundenanschriften nach KD Nr].[Kunde] "
demand = demand + " FROM [Tabelle Kundenanschriften nach KD Nr] "
demand = demand + " WHERE ([Projekt].[Datum Bestellung]>= #" + FirstDate.Value + "#) AND "
demand = demand + " ([Projekt].[Datum Bestellung]<= #" + SecondDate.Value + "#)"

I think my error is when comparing dates (row 3 and 4). And another question: I work with two tables connected through a field customerID. Do I need to put the condition that the customerID in one table to be the same as in the other table or this is done automaticaly?

Sharing A Microsoft Access Database
Hi,

I have just finished my first database application using VB6 and Microsoft Access 2000.

I have a major problem. I placed the complete program on the File Server. My Application is called "Autohouse Solution". I have a M: mapped on all machines to the server.

When I run the application as standalone, it runs fine.

When i add a record it appears on the customers list as usual.

Today, I ran a test with the application. I opened the application on 2 machines - Machine1 (user1) and Machine2 (user2).

User1 opens the customers form list. And User2 opens the customers form list.

When User1 adds customer it is not displayed as expected, however the list is not displayed on customer2 when he clicks refresh. Both applications are pointing to the same database. And am refreshing the recordset.

I closed the customers form on both machines and re-open them. Still only the new customer appears only on User1 (the one who added the customer) but not on machine2.

Someone told me this was because I have to compile the MDB as an MDE file in order to be sharable. Why is this happening?

The amazing thing was that the database did not contain the new customer record I added, however it displayed on Machine 1 and Not machine2. What is happening???

This application is due tommorrow! Please Help my programming career before it turns into a nightmare!!

Microsoft Access Database On CD Problem
I made one program that converts a large text file into MS ACCESS format (97) mode 4. I have another program that is to open the access file and bind a text box and rich text box to the data.

This program works fine when it's on a writeable filesystem. When I copy the executable and mdb file to the cd- It can't open it.

I get the following error. Microsoft Jet Engine cannot open the file f:purge.mdb, It is already opened exclusively or you need permission to view the data.

How can I open a database on a cd without getting that error since it's a read only filesystem?

Jeremy

Microsoft Access - Vb Database Problem
I made a "very" simple database using Microsoft Access 2000. Then I add a data control in my vb form.....in the "database name", I put the source for the database I created, and then I go to the "record source", and when I click on the arrow, to add a record, I get an error message saying "Unrecognizable database format".
This only happens with the databases I create..all the other databases (biblio.mdb, and others that I have downloaded) work fine. Does anyone know why this happens?

I have included the database with this post, if this will help anyone (only about 8 Kb).......Thanks

Microsoft Access Database Limitation
Hi There
I am using Visual Basic 6.0 and Microsoft Access 2003 to develop systems. My problem is that the access database file has a maximum capacity of 2Gig (Minus database objects). My clients are complaining because of this problem. I'm in need of an solution. If anyone has information regarding this problem, even if it means moving from access DBMS, please feel free to provide me with this information. Thanx in advance.

HELP - Microsoft Access Database Size
ITtoolbox Portal for Visual Basic - http://visualbasic.ittoolbox.com/

I currently have a number of Access97 databases being used in adepartment which are to say the least becoming big and wobbly.

The database operations stop when the size reaches 1 Gig, (Accessreports database has reached maximum size) is there anyway of stoppingthis, and letting access over run this size limit?

The data is stripped off regularly, as some of the tables contain 2million + records, but unfortunately i have inheirited the problems of aprevious database killer (Sorry i mean programmer).
We are currently in the process of migrating to SQL but because of costsetc. this isnt going to happen quickly, so in the meantime I need helpquickly.

Regards
Steve Tempest

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~

Query Microsoft Access DataBase
hi, all

i need help to create a simple and faster query because the data more thn 1
million record, and i must re-check each record cause they need to encode
first before i can use them.

now, for example we have a database that contain 3 field :

MainNumber as AutoNumber

MainDelete as number

CustName as string

Field MainDelete is contains a number that not use anymore for further, nd
that number is taken from field MainNumber.

MainNumber MainDelete Custname

1 0 Alex

2 0 Cynthia

3 2 Christpher

4 0 Fransisca

.... .... ....

Now, i need a query that can grab all data, where the mainnumber is not n
Main Delete, so only 1, 3 and 4.

The data 2, is not include in query cause he already exist on Maindelete

is That Possible to create a query like it ????

Please Help Me.

Thanks Before,

Hok Sun

Problem With Accessing A Microsoft Access Database Is VB 6.0
Hello, I'm sorry for asking such a dumb question as this since I'm sure u guys are all professional programmers, but I'm a newbie in VB .
What I've been trying to do is make a list of my books in Access with the following record subjects: Book Title, Issue Title, Publisher, ISBN number, Volume Number and Author.
In my VB project, I made those 6 text fields, so that later on I can add, delete, modify or do whatever I need to the list of books. Then I cliccked the "Data" icon in the Toolbox to add the data thingy on my form.

This is the part where I got stuck: after changing the properties of the Data object (like changing the path to the DatabaseName to C:whatevermangalist.mdb), I tried to run the program so far, but it tells me "Unrecognized Database Format"

How can I fix the problem? I was thinking that it might have to do with a problem in the Database itself?....Any suggestions?
Thnx!

Deleting Records From A Database (Microsoft Access)
Hi ive created a program to store movie names and their categories. Ive used a recordset to connect to the database from vb6 but i am having trouble deleting a record from the database from vb6.
If there is any other information you wish to know then please ask but if anyone knows an effective method to delete records from a databse or knows a website that would be of any help please post it.
Thanks

Load A Microsoft Access Database Into A Treeview
Hi all,

I'm a little stuck with this problem of how to load a database(I'm working with a simple database in Access that has the infgrmation of names and addresses from an address book) into a treeview control. I'm using ADO in VB6 as i prefer this over DAO. What i'm trying to acheive is having a treeview control on a form that may show the persons last name, and then by clicking on the item can reveal more information?

Thanks in advance
Jason

Microsoft Access 2000 Database Crash
Hi gurus,

OS:Windows 2000 SP 4.0
D/b:Office 2000

I have a Access db which was working fine for 5 yrs on a standalone m/c

Now recently, we've upgraded to work on network.

Now, this d/b is operated by 3 persons.

Now the problem is, the database is getting corrupted every now & often.
But, Repairing the d/b would solve the problem. But for that all the three users have to close their application. One of the user will repair it. and then others start the application.

But this is happening very often. Even when 2 users are not operating, but their applications are open also, the third computer makes the d/b corrupt.

The client wants it on Access backend. This is my problem.

How can I solve this.
What's the solution?

Please help me out.

With Regards,
Shivakumar G.M.

How To Use An Encrypted Microsoft Access Database In VB Program
how to use an encrypted microsoft access database in VB program. if i encrypt it, the VB program is not able to access it through DAO method. if i leave it unencrypted, anyone can modify it.
pl help

How To Export Dbase (*.dbf) File To Microsoft Access Database
I want to export Dbase file (*.dbf) to Microsoft Access database through Visual Basic. Is there any way that i can open Dbase file in a shared mode through Visual Basic

Installing Database Programs On Machines Without Microsoft Access
I have a program in VB 6 that uses an access database.
When using Visual studio installer, the file msacc8.olb generates a message that "neither a merge module or dependency info could be found for msacc8.olb"
The program just uses the database and I hope to be able to install it on machines that do not have Microsoft Access.
The User will not have to work with the database as code handles all the connections.
What I'm wondering is, if there are other files which VB didn't add to the project that I would need to create a merge module for to get the program to work correctly in such a case.
Obviously, I have Access so it's going to work fine for me. I'd prefer not to have to uninstall it to find out.
I'm a newbie and self taught so really technical stuff will go right over my head.
TIA for any suggestions
Tim Garrison

How To Use EVB Code To Download Microsoft Access Database To Pocket PC ?
Hi,

I have a Microsoft Access database and I use eVB to develop my application. My problem is how to download my database to Pocket PC ?
There are several sites talking about functionality of Microsoft Active Sync ("Import Database Tables") which I found not so friendly.

I am trying to use vb function which is DestoptoDevice function but it cannot be use in Pocket Pc because the vb function that I use is not in Pocket PC environment.
Even I use SHELL in evb to call the vb exe file, it still not work !!!

So I need someone who have experience it to suggest to me...which I want to use evb coding / function to download my Microsoft Access database to my Pocket PC (.cdb) database.

Meanwhile I can't find any solution. ..so I hope someone got an idea for it

Thanks you

Justina

Error In Pulling Up Microsoft Access Database With A Startup Form
I've got frmStartup that loads a hidden frmLogOutMonitor that closes out the original frmStartup form.
I have this because in other databases I may have frmStartup load other forms.

In the frmLogOutMonitor - Form_Open code I have the following:

Code:
Private Sub Form_Open(Cancel As Integer)
On Error Goto Err_Form_Open
'turns hourglass on
DoCmd.Hourglass (True)
'closes Startup form
SysCmd acSysCmdSetStatus, "Closing startup form ..."
DoEvents
DoCmd.Close acForm, "frmStartup"
'check properties for all databases
Call Check_Properties

The Check_Properties is a reference to Public Sub Check_Properties in a module and thus I have several of those that are under Form_Open that point to several modules in various areas. Each one of those modules also has error handling...
Keep in mind that frmLogOutMonitor is opened up as hidden - monitoring all kinds of events. It has a timer that uses ADODB to see if a table has a certain value that is checked off as false because if it isn't then it logs everyone out of the database!
If I don't have the proper Error Handling in this database (with another form) and it stops for some serious reason - then I start having issues with running the database. (even when I fix what's causing the error.)
Even if I decompile the database correctly - after all of that... remove the form from the Startup.... then decompile ... do a compression, then a repair...compile and save all modules.... then later put the form in the Startup....frmStartup it still will not run the database at all. It comes up with that Do you want to send this error to Microsoft?

So I know its technically corrupted. To overcome all this I create a new database and then load everything from the old one - since I can at least open the database if I don't have a form in the Startup. But I can't have this happen everytime I get an error. This is too serious to ignore that this will happen in the database.

When my .NET debugger comes up - it gives the following error:

Unhandled exception at 0x651078f1 in msaccess.exe 0xC0000005: Access violation reading location 0x001b89a7.
Address 651078f1 movzx eax, word ptr [edx+eax]

Do you want to Save changes to msaccess.sln?

An exception 'Unhandled Win32 Exception' has occurred in msaccess.exe

Any ideas how I can solve this?

Tutorial On Populating A DataGrid With Data From A Microsoft Access Database
can someone plz tell me how to do this or give me a link to a tutorial

i have been searching the net and this forum for ages and aint been able to find a simple tutorial that explains how to simply add data from an access database to a datagrid on my VB 6 form

VBscript To Send Form Values To Microsoft Access Database
Hi,

I have created a html form. Basically i need to have a submit button to perform 2 functions:

1) validate the text fields
2) send the text fields values to Microsoft Access Database

I have already done the coding for validation portion. what i need is how to use vbscript to read the text field values & update to Access table. Can someone help me on this?

How Can I Secure Access Database To Stop Copy. I Used Microsoft.Jet.OLEDB.4.0
Hello

I developed a small mdb database browser application in vb, Can i prevent reuse of MDB file. I want that no one can understand data file. I used Microsoft.Jet.OLEDB.4.0.

Thanks

Edited by - rishiacharya on 10/11/2004 10:41:54 AM

Saving Data To Microsoft Access Database ( Couple Of Questions )
Hey Guys

  I trying to use Microsoft Access as my Database on my Pocket PC 2002. The only problem is that I don't know how to do my connection. Right now I'm using SQLCE but it giving me problem when I try to Insert data into the Table manually.

This are the code I use to connecto my my SQLCE database table.

           Code:Import system.Data
Import system.Data.SQLCE

   'Connection to the Database
        Dim MyConnection As SqlCeConnection = New SqlCeConnection("Data Source=My DocumentsADP.sdf")
        Dim MyDataAdapter As New SqlCeDataAdapter
        Dim MyDataSet As New DataSet

        'This give the Status of the user depending on the User ID enter in the
        'Textbox called txtUserID
        Dim Status As String

        Try

            MyDataAdapter.SelectCommand = New SqlCeCommand
            MyDataAdapter.SelectCommand.Connection = MyConnection
            Status = MyDataAdapter.Selectcommand.commandText = "Select UserStatus from Users WHERE UserID = '" & txtUserID.Text & "'"

            MyConnection.Open()
            MyDataAdapter.SelectCommand.ExecuteScalar()

        Catch EX As Exception
            lblErrorMessage.Text = (ex.Message)
        End Try

        MyConnection.Close()

1) How could I connect to my access Database??

2) Where would I located or transfer my Database file too on my Pocket PC??? Would I place it in My Document or some where else???

3) What type of file should I convert it to???? I know SQLCe uses .sdf.
4) What I be able to do Query with my Access Database???
5) Would I be able to Insert, Delete, Update, my Access database once it's upload to my pocket pc??

Thanks Guys

Thanks

Sincerely; Oscar Martinez

Edited by - youngOz on 8/5/2004 9:55:28 PM

Modual Problem In Secured Microsoft Access 2000 Database
Hi,
I am having some issues while setting up the user level security in access 2000. I have ran the user level security wizard and it worked great but on all my forms and reports where I use a module object it says "invalid username or password" and I click end and it opens the form. But it works fine on all the other forms and reports that don't use any module objects.

I know that there is a way to write some VB code to connect to the database but everything I saw you must put a DB path and password which is not going to be possible in my case because the database uses the module in many places and the database is going to be deployed to many different computer systems with different paths and passwords thus it is not feasable to change the code at every install. What can I do?

The error:

I open the database and a user name and password box pops up. If I type in an invalid username or password here it tells me it is invalid and this is not the problem. If I log on as an Admin then everything works fine. But when I log on as any other group (Read Only, Full User, etc...) the database opens fine with no errors but as soon as I open a form that uses a module the following error pops up:

run-time error '-2147217843 (80040e4d)':
Not a valid account name or password

With 2 options End or Debug. If I click end the form opens but the module does not run (I know because in one case the module object adds some text to the form).

There is no errors however when I open a form that does not use a module object.

My initialization method in the module (perhaps a problem here?):

Private Sub Class_Initialize()

Set mconn = New ADODB.Connection
Set mrst = New ADODB.Recordset

FixUpRefs
mconn.ConnectionString = CurrentProject.Connection
Debug.Print CurrentProject.Connection
mconn.Open

mrst.LockType = adLockOptimistic
mrst.CursorType = adOpenDynamic
mrst.Open "CustomOptions", mconn, Options:=adCmdTable
Call GetOptions

End Sub

From Semicolon Delimited Text File To Microsoft Access Database Table
Hi,

I have a text file I receive daily with semicolons as delimiters. I was hoping to take certain data from this text file and shoot it into an Access database table (appending to existing data).

My goal is to create a table which historically tracks specific elements in this text file.

Any help or direction appreciated.

Runnning A VB-Access Application On A System Where Microsoft Access Is Not Installed. 2
Hello

I´m Using an VB & Access2002 DB. I´m trying to make the installer for my application where Access97 is installed in target PC´s, or no Access at all.

I´ve solved the problem... I insert the MSOffice XP Install CD into the target PC to update the system (Windows) so that Access 2002 DBs work properly, then i abort the MSOffice XP installation. Some clients ask about the licence of Office XP, and i have to explain that Office XP is not installed in their computers (this sucks, they don´t seem to trust me).

I´ve already checked this topic, it´s helpless

Runnning a VB-Access application on a system where Microsoft Access is not installed.

I´ve already found many MDAC versions but no one seems to work.

Does anybody knows what files does MSOffice XP Install CD uses to update the system before MSOffice XP is installed? I´m clueless, and the file names in the CD are not helping.

Any comment may work...

Edited by - Shandy on 9/8/2003 11:59:02 PM

Runnning A VB-Access Application On A System Where Microsoft Access Is Not Installed.
Hello All,

I am developing an application in VB & Microsoft Access.Now I want to install that application on a system where Access is not loaded.
How to run the application in such conditiion without installation of Microsift Access on PC.

Could any body suggest any solution ...

Thanks
Sachin

Cant Access Database Second Time Around
i have a combobox,which populate a flex grid with certain dat when changed like so:

Code:
If Combo1.Text = "Line 1" Then

MyCnn.Open
Set rs = New ADODB.Recordset
strString = "SELECT [Last Name],[First Name],Value,Workstep,Line FROM .....
rs.Open strString, MyCnn, adOpenKeyset, adLockOptimistic, adCmdText
Set MSHFlexGrid1.DataSource = rs
MyCnn.Close

End If

i have the same for line 2,3,4.
the form load contains the same code to make the default view "line 1"
the problem arires when you run the program.
it starts of and displays line 1,then if you change the combo box to line 2 it displays that. the same for 2,3,4. but if you reselect line 1 nothing happens. its very confusing because you can select 2 then 3 and reselect 2 and i works. sorrl for the long windedness...

Web Database, And Have Access From My App At The Same Time?
Hello everyone! This one, at least to me, is a little complicated. I want to have a Active Server Page website that access's a database (reads and writes to it). The website will taking and putting information in it all day long... Now, I also want to be able to have access to that very same database from my application on a desktop computer. I need to be able to update it from either the web, or the workstation. That's the first part....

The second part is, how would you go about preventing a user on the web and a user at a workstation putting in the same information to the database at the same time?

Example: Let's say that a person goes to the site for an appointment, the database retrieves all available appointments for a certain day and displays them. As the user picks the appointment he/she wants and inputs their information, another person on a workstation just took that appointment time. When the web user goes to push submit, that appointment will have been taken by the workstation, so then the user would be required to try again, and possibly again, until it goes through (thus really frustrating the user). I want to prevent that, how?

This is going to be a big enough project for me as it is, I need to start off on the right foot.

Database Access With 2 Applications At The Same Time
Well here again is my problem:
I have 2 identical aplications, that have access
to the same database (lets say Northwind.mdb).
When I'm trying to access to the database with both
applications one of them generates an error. I'm trying
to solve this problem so, that the second
application will wait and then access the base when the first will
finished. I don't have a clue how to do this. Can you help me please?

Thanks,
Jani

Multiple Access At Same Time Same Database?
Hi guys, after much googling and a brillant doc on databases in the ***. I've taught myself databases (multiple linked table, queries in SQL etc .)

The program im making is gonna be used on a network, where the database is stored on a shared drive. Users of the network access the same database from their PC running the vb program. I was just wondering, wot if 2 users open a connection and say try add/update/remove data at the same time?
How is this handled ???

And is it possible to check when a database is updated, so that the people can reload their data so that they are not looking at old data?

Heres my data base "type"... (dunno if this helps)
DbOpts = dbVersion25 + dbEncrypt
Set NewDb = DBEngine(0).CreateDatabase(Module1.DataBasePath$, dbLangGeneral, DbOpts)

Thanks for any input

Trying To Insert A Time Into Access Database
I'm trying to insert a time value into an Access 2000 database with Visual Basic 6.0, but I can't get the syntax right.
Here is my SQL statement:

strSQL = "INSERT INTO Events VALUES (" & StartDate & "," & EndDate & "," & StartTime & "," & EndTime & ")"

Then when I try to execute it, I keep getting the error "Syntax error (missing operator) in query expression '12:00'". How do I structure my SQL statement to correctly insert the time into the database? Also, is the date syntax correct? Here are my variables and fields:

StartDate, EndDate, StartTime, and EndTime are type Date
StartDate and EndDate will be 06/15/2004, as an example
StartTime is 12:00 and End time is 20:00

StartDate and EndDate will go into Start_Date and End_Date, both being Date/Time types and having Short Date formats.
StartTime and EndTime will go into Start_Time and End_Time, both being Date/Time types and having Short Time formats.

How To Get Server Time In Vb With Access Database
hai everyone,
This is suresh form bangalore, iam doing an application in vb with
access in which i've to get server time .
now iam getting only local pc time by using NOW method and in database
Time().if i store my database in server also its giving only localtime.
Already i search previous discussions but still i din't get .

Anyone send me sample code to get server time

advance thanks
suresh

VB5, Microsoft Excel, Microsoft Access, And Microsoft Word
I am currently using VB5 and I am trying to write a program that takes the data from an Excel file, copy and paste the desired data into a worksheet in the same workbook. I would then take that data, sort it, and then extract one type of data into one column and another type in the next column. With the data extract the code will tell Access to create a blank database and to import the data from the Excel file into a new table. After the importing the code will then match data from the Access file to data in a Word file. If there is a link, the code will then parse the data into the form.

Is there a way to do all of this?

Writing To Access Database At A Scheduled Time
Hi,

Is there a way to read records from a text file and read them into an Access Database at a specific time everyday?

I've done this with VB6 & Oracle database, where I will scheduled the exe file to run everyday at say 2pm.

But is it possible with Access?
Please help!!! coz it's been quite a while since I used the Access database!
Thanks!!

Changing Time Values In An Access Database
This simple problem may have a simple answer but I am at a loss.

1) An Access table records a time value like O8:00 AM
2) Using VB 6 and the masked edit box the user enters a time.
3)This line of code works fine for the first entry:
If isdate(mskTime.text) = True Then rs!Time = mskTime.text

If at a later date the user must delete the time so that the field in the table is blank nothing happens. I can't figure out how to change a time field from a value to a blank.

Can anyone suggest a solution?

Set A Specific Date And Time To Access A Database (VB)
Hi, im tyring to create a program which can enable users to add data to the database, but the database should not be accessable to anyone, not even the administrator, till a specific date and time.

i have disabled the Open Database button with the VB command :
Open.Enabled = False
but i cannot understand how to set a specific date and time for the button to get active.

Help!

Passing Date-Time To Access Database
Hi,
I am developing an application where I have to pass Date of an event to the
database. I am using DatePicker in VB 6.0 and Access 2000. When I am
executing the command "Insert into TableName(Field) values " &
datePicker.value & "" , error message saying that valuess are not given for
certain parameters. When I change the command to " Insert into
TableName(field) values ' " & DatePicker.Value & " ' " then the date value
is getting stired in the table.
The problem is when I try to query the database with the date-based
conditions. " Select * from TableName where DateField = " &
DatePicker1.value & " " gives and error report that values of certain
parameters are not given. When I change the command to " Select * from
TableName where DateField = ' " & DatePicker1.value & " ' ", then it says
there mismatch in the datatypes.
The related field is defined as Date/Time.
I am using ADODB.
Please, anyone with solution/ Suggestion?
Thanks in advance,
George

Checking For Conflicting Date/Time In Access Database
I have a program that will allow a user to enter Dates and Times for Appointments that popolulate an Access Database.

Now I need to add code to no allow for conflicting appointments. All appointmetns are 1 hour and I'm having trouble figuring out how to have the program check the tables for conflicting dates and times when the appointment form is updated.

I know the logic needs to be that it should first check for matching dates and then check for the time range.

Any suggestions?

Thanks.

Query Time Against Access Database, Interesting Observation
Hello , I have designed a query builder where i allow the user to construct a query by selecting values from dropdown boxes and then run it against an access database. I am showing the query results in a datagrid.
He also has the capability to go back to the form and change the query and run it again.
I am noticing that when he runs it for the first time it is taking him about 8 seconds to get back the results in to the grid. There are about 80,000 records in the database.
But when he goes back and changes it and runs it again it takes only like 2 seconds.
Why is it taking so long for the first time and not much time even when i am changing the query the second time? Any clues or ideas?
help is appreciated
thanks
Sam

Inserting Elements Into A Access Database One Element At A Time
Hello everyone, i am a pretty big noob when it comes to VB, but i have a lot of experiance with C, Java, and ASM.

For this project i am working on we need to dynamically generate a VB database, with a variable amount of fields, i believe i have found how to do this(if the following code won't work let me know(thanks )):

Set db = CreateDatabase("C:junk.mdb",dbLangGeneral)

Dim db As Database
Dim td As TableDef
Dim fl As Field

Set db = CreateDatabase("C:junk.mdb",dbLangGeneral)
Set td = db.CreateTableDef("Table1")

For iFlds = 1 to 5
Set fl = td.CreateField("Field" & CStr(iFlds), dbInteger)
td.Fields.Append fl
Next iFlds

db.TableDefs.Append td

However as the amount of fields will be dynamically generated i don't know how to either:
(A) insert one element at a time into the access DB (this is the ideal case)
or
(B) dynamically generate a insert statement. (would perfer to not have to do it this way)