VB and Access Database. -
OK I am totally new to Access, I've created 2 fields in Access
will say name Username and ID.
then I saved it.
nvc.db
So that is my access file, so now I want to call the access file I have that.
now does anyone have documentation on how to create a proper Access file.. something simple .. I can create the link with VB to the file..
thank you all
Database security -
Hi - I am currently working on an ActiveX control (my first one so I am having a ball with it, let me tell you). The goal of the control is to detect if a database has been accessed by anyone using another program.
I have a macro set in Access that will tell me if someone uses Acce
Access 97 --> Access 2000 -
I have done a Access database with Access 97. Here at my work, we use Access 2000 and Access 97. How do I do if I wanna use the same Accessdatabase to the both versions. Access 2000 and Access 97?
Now I get this error:
You can't make changes to the database objects in the databa
Access 97 / 2000 compatibility -
I am trying to set up a database as part of the company Intranet (which needs to be ready for next Tuesday - ulp). The problem is as follows:
- The company has a mixture of Access 97 and 2000, but they need to both access the same database. Solutions I am thinking about are as follo
MS Access Database isn't working -
I made a database using MS Access. Then I went to properties list under the data bottun, and went to Database name, then selected the database, and it works fine. But when I click record Source it says Unrecognized Database format. I'm just using MS Access database. I've never made
Need help converting workgroup database to stand alone -
Hi All,
I have been given the task of having to look at some data in an old Access workgroup database. The database file has been copied to my computer, which has Access 2000.
This database was designed with Access 97 or earlier. I am not sure how to tell what version it was cr
Help using access through VB -
I have an application that connects to an Access 97 database.
I am using ADO and have the mdac 2.5 installed.
Them problem is I have used the JRO object for compacting the database, and since then if I try to access the database through Access 97 it displays a message box saying
different versions of access databases... ezzzy -
Ok... this is a simple question. Can an access 2002 database be opened up by access 2000 (or whatever jet database engine comes with 2000)? I obviously need this database to be used by a visual basic 6 program, and a good portion of the people who recieve this database will either not
DAO or ADO in Access 2K -
I have observed a strange thing!
If I import an Access 97 database into Access 2000, in the later MDB file (ie in Access
2K), I find only DAO and no ADO in code modules! For example, I can't write
<< Dim cnn as ADODB.Connection >> even if the database is currently o
Need to access an ACCESS Database from a web page -
Hi All,
Here is my dilemma, I need to access an MS Access database via a web page. The database actually resides on a machine other than the IIS server. What is the syntax for the connection string so that anyone who hits this web page will see data from this database. I have tri
How the Access database can be made as multiuser Please.. -
friends, i have a app with sql server database +VB6.
now the company decides to use the Access database instead of SQLServer database. In SQLServer, there are 50 users will access the database at a time.
but now in Access how the 50 users can access the database at a tim
Access database query efficiency -
May I ask a fundamental question about Access database query?
I know that when a Access database application make a query
to another Access database through network, the whole
table data are sent to client computer for processing,
that is what desktop database means.
But i
- Access - Oracle - Database - -
Hi there..
I'm currently programming a software which connects to an Access database thru SQL statements. Every database request, update, delete is in SQL. The only problem I now encounter is the database size...
Though I'm not using any Microsoft specialities in my code, I was won
ADO in Access -
I have an Access Database that I need to retrieve information from.
I cannot Link the database as the file extension differs from .mdb (the other software creates an access database with a .vdd extension).
I am trying to open the database in Access through ADO (DSN-Less connection) a
vb to access and somehow "sharing" to another database noob question -
Hello everyone!
I am trying to think of the best way to do this, I'm going to create a vb application which can write to an access database and can also view the files of the access database. Now i'm also wanting all that data which is going into the access database to be able to
Access 97 & Access 2000... -
Hi guys, I orginally had a project using DAO to access an Access 97 database. Just recently, I installed Access 2000 along with Office 2000 on my system. And now my project can't access the database after I have converted it from Access 97 format to Access 2000 format. What should I do
SQLClient with an Access database - Using VB .NET -
This is probably a stupid question. But can you use the SQLClient (import it) to connect to an Access database?
I have a VB .NET application that reads from an Access database on a network shared folder and I am trying to increase the speed in which records are retrieved from a stor
Distributing Access Database..Please Help! -
Hey,
I am trying to make a distributable program with an access database. I can read and update the database fine with ADO or DAO, but I have a problem with the report. I have created a report in the database that I want to access from VB. I can print it out and manipulate it by cre
Creating an Access Database in VB -
I have created a access database comprising of only three fields, however my problem is a) I am not too good at access (dunno why) and b) I have NO IDEA how to integrate an Access database into a VB program and get VB to write and read to and from it respectively.
Can anybody help me
pulling data from an access DB into SQl -
Hi there,
I have a database project (I am using visual studio 2005) I also have a connection to an access database and then a connection to a SQL server (sql server 2005)
What I want to do I pull data into the new sql server database from the access database. This would be a sim
Microsoft Access 95 to 97 -
I have a strange problem
I have moved my PC on to this new Network and I have two Access Database files *.mdb and they were created in Access 95, However on my machine i have Microsoft Office 97, (Access 97). I can open the file (but can`t modify) it tells me to convert, that is fin
Implementing Access 2000 -
hi,
I have created an applicatin that uses Access 2000 as a backend. While installing the application on the end users machine , is there any way that i can use the ACCESS database ("use": as in access the data in the database) without actually having ACCESS 2000 installed
Security method/dtandard -
Ok, be patient since I’m new to database connectivity via VB6. I have a project that is using an Access database ( I know, but it’s all I’ve got to work with at the moment.) I need to make the database NOT readable if someone were to try and open the database in Access (or any
Data protection outside VB! -
We use Access as our database syatem! We could protect the Access using password. But when we link to VB programs, the Access password becomes a problem to open the database. If we don't use password in Access, one could access the database if this person knows Access and knows that
Help: Best way to access a database remotely -
I was useing data enviroments to access a database on the work LAN.
Now the rules have changed, the database is gogin to be situated off premises and not on the lan, therefore i need to have access to an access database over the net.
Any idea on how to go about this and the best
How to's on creating a database project -
Hello,
For example, I want to create a database project that will check people in and out of a building. I can use and Access database or SQL right? Now if this is just a standalone project on on PC would you use Access or SQL? Help me understand the differences in Access and SQL un
will access database work -
Will access database(.mdb) work on a cgi script. I have learnt cgi yet but because I have worked with access database using asp like creating a link page.
Does CGi allow you to use SQL to minipulate the access database
Question about using VB.NET/Access database on a network -
Hi
for a school project I am creating a VB.NET program which will connect to and use a database created in MS Access.
The database will store things such as student login info (I mean usernames & passwords).
I was just wondering what the best way to 'set it up' would be.. for ex
networking an access db -
In the past, any database work I've done over the internet or a network has always been through SQL server 7 and 2000. However, I just got a new client who has an access database that I really don't want to have to convert to VB if at all possible because he has numerous forms, report
Major Access Questions...... Please help -
Hi,
I just read a book on MS Access and learned how to use the whole program. The only problem is, it didn't tell me anything about putting my database on the internet.
Now, Access is my first time going into the world of Database development so I dont know much about it.
writing to access and allowing access to share its information with mySQL -
Hello everyone!
I am trying to think of the best way to do this, I'm going to create a vb application which can write to an access database and can also view the files of the access database. Now i'm also wanting all that data which is going into the access database to be able to
[2008] Database access problem -
Heya guys
I have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that &quo
Open Access DB Tabels From Win XP -
hello
Unable to open database with full access to tables through
shift / enter function after Microsoft XP was installed.
Database was created in Access 2000 with a main
switchboard and limited menu & toolbar options. How can I
access the database tables, form design to make c
Access control in Access 2000 -
I made a database application is Access 2000.
Now I want to distribute to various user for use.
But I want to restrict their access - for example, end user will not be able to view
relationship, they should not see tables directly (they must see thru Forms)
etc.
I know that
[2005] Access and VB.NET -
Hey everyone,
I have a couple of questions about Access and VB.NET.
1. If I create a query inside the database in Access, is there a way to get/store those results in VB.NET?
2. My database is currently in Access 2003, and I recently had Access 2007 installed on my computer, h
vb to access database -
Hi, Im having a little trouble getting my vb program to see my access database. All the settings are correct, but it reports unknown database format. vb is vb 6.0 sp2 and access is access 2000 9.0.2720. I understand that the versions are different but is there any way to make them unde
Number of tables in a database - Access -
When using MS Access as a database, how many tables am I safe to use in a single database? Or does it matter?
I hear so many people say stay away from MS Access for your VB application. Isn't Access 2000 better than the 97 version and more stable? I'm using ADO connections in my VB
Database for standalone VB app -
I'm looking into the possibility of creating a standalone application that will be distributed to certain employees of the company I work for. I was considering using Access 2000 as the database backend for the VB frontend. The problem is that not all of the users have Access 2000 alre
copy data from MS Access database to MySQL -
Hello All,
I have Access database which I modify every once a week. We also have a MySQL database which has more complex structure of tables than MS Access. Whenever I modify tables in Access I want that data to be copied to MySQL database.
I am pretty new to MySQL database. As fa
Simple Search Database -
Dear Gurus
I have been developing databases in Access and know VBA fair bit but I have never developed a database in VB.
I had to develope a simple database comprising of just one table Contacts and all I want is one text box to enter full and partial name and one subform displa
Deploying with Access Database Reference -
Hi, I'm new to VB.Net so bear with me.
I've built a simple test application using the 'Server Explorer' to add a Database Connector to access the MS Access database I am using, I have then added dbAdapters (OleDbDataAdapter) to my form to access several seperate tables.
The prob