VB Forum / Database Access / December 2007

MI5 Persecution: BBC Newscasters. Lie & Deny They're Watching Me
Central to the persecution campaign waged. against me for some nine years
now. by the Security Service is their use of the media, and in particular
the broadcast media, to make clear. to me that I am under surveillance ...

Help!  IN VB6 I'm trying to open a FoxPro .dbf with a memo field (.fpt file).
I've tried every driver I can find... I always get the error "External table
isn't in the expected format" when the database I open has an associated .fpt
file.  If the dbf has no memo file I'm fine.

I am really struggling with a school project involving VB and MS Access. I
really hope someone can and will help me out....
I am receiving an error message Microsoft Access Driver Syntax error in
Insert Into Statement. I am desperately trying to follow the correct

How can i fill one table with two forms in Access database ?
Thank U

Just wanted to see if anybody had any experience with the following
scenarios:
1) VB6 app connecting to an SQL Server Compact Edition 3.5 DB - any
problems?

I am using VB 6 with Sp6 (XP sp2), Jet 4.0 and Access 2000 database.
I have one table it has Memo field and I am trying to save Memo filed that
time it gives me error
"-2147467259   Could not save; currently locked by another user."

I have a software written in vb that uses MsAccess database. It runs without
any problem in many computers.
Recently however it is throwing up the "Error 3704" in a few computers.
In one system updating the MDAC software package from Microsoft to version

I have a client who is wanting me to develop an Access DB or VB app that is
basically a fairly simple call tracking system.
They are expecting approximately 15-20 users, and possibly about 25,000
calls per year.  

Does anyone have code examples of accessing an access97 database that
has both user security using an *.mdw file AND a database password.
Thanks.

How can I modify the Select statement after the Update statement in
sqldataadapter ADO 2.0?

The below text is going to sound like a weird ask, but I can't think of any
body better to put my thoughts across for some valued feedback.
What it is I have created this vb app for primary schools and my first
thoughts on installing this app were the traditional method of:

Can any body help me to use the ADO Recordset in Multiuser Environment for
SQL Server DB?
How Can I Restrict User 2 to Open the Same Row which is Opened By User 1 and
I will Display Message that "This Record is being opened for edit"?

Does anybody know how to create a db and link up with it using VB6?
Thanks

This question has probably been answerd before but I don't find an
satisfying answer in Google.
What is best?
Open the connection when the application loads and keep it open or

I work on a multi-user system which has been in production use at
several sites for years.  The database MDB lives on a server, and the
MDE file is run from each user's workstation with tables linked to the
database MDB on the server.