Access Database Manipulation -
In my program, I'm going to give users the option to "purge" the database of older records. So, I need the following to work behind the scenes.
I'm going to create a "duplicate" database, with the same table structures as the original, however, this database is going to have no data in it. I need the program to
a) copy this database (named templatedb.mdb) from the root of the App.Path folder, to the same location as a file named: archive.mdb
b) then, i'm going to scan the records in the current db (which I know how to code) , but how do i move the record (exactly as it exists) to the archive.mdb file and then delete it from the old database (db1.mdb)
I know how to work with recordset information (as in rs.MoveFirst, rs.edit, rs.update), but I'm not sure how to copy the database and not sure how to copy the whole record and then delete it.
ANy ideas? (BTW this is an access 97 mdb file)
Database Manipulation -
Hi All,
I am just getting into vb.net. But am finding database manipulation quite tricky. How do i add new info into a database? If anyone has a example of code that shows input and output of data and the connection setup i would be grateful.
Thanks In Advance!
Dean
Importing Data from Excel/Flat File to Access -
I am new to Access and Visual Basic. I am trying to determine how, if at all possible, to import data from an Excel spreadsheet into an Access database table. Essentially I need to take the spreadsheet data, probably do some manipulation (calculations, if/thens, etc), then move the dat
Server / Client Question ('c Database) -
HELP NEEDED FOR SQL SERVER...PLS
Hello....
Im a student at UDW, RSA studying Elec Eng.
Im currently experimently with client-server programming with primary focus on database manipulation. I have little experience with the client-server part, but have satisfactory experience
[2005] Updating Database after manipulation -
I need some idea some on what is the best way to update the database records.
Initially i will load the relevant records from the databse and have them loaded to a dataset. And this dataset will go through lots of records manipulation, update insert delete, and after all the manipulat
how to connect to access db on diferent computer -
hi guys,
i have done some basic vb applications some ime ago, but now i am required to develop a vb application to be used on 2 computers, at the same time. meaning i have to create an access database and put it on 1 of the computer. i need both application to access the same database
Simple Database connection... -
Hi,
I am a new dev in .NET technologies. I am trying to develop an application which will do the common database manipulation (add,edit, delete). Database may be MS Access or Sql Server or Oracle.
If anyone guide me how to develop this I will be thankful.
Or just men
Text File DB manipulation -
Hi there,
Could someone point me to an example of creating, inserting, retrieving, editing, manipulation of a comma delimeter text file database. I know i have seen this around, buy i cant find it again.
A big thank you for your time.
Kyle
database application -
how to develop a program that access the server database for manipulation....i mean i can insert, delete update database in the server.....i got no idea about this....
may someone show me where to get those simple reading.....or give some idea about this.....
if can....sample exa
Image manipulation, etc. [probably resolved] -
Hi All,
I’m interested in the manipulation of images (BMP, JPG, etc.) WRT changing contrast, hues, lightness, etc. Can anyone tell me where I might get – preferably free – a suitable graphics manipulation library? Alternatively, can anyone point me in the direction of releva
DAO, Access .mdw files etc. -
I am quite new to the whole VB / database manipulation sector, but I am getting very involved very quickly!!
Anyway, I am trying to call the current users name from a secure .mdw file on a network using DAO data controls and I am not getting very far.
Please take pity on one so y
Access Database Manipulation -
In my program, I'm going to give users the option to "purge" the database of older records. So, I need the following to work behind the scenes.
I'm going to create a "duplicate" database, with the same table structures as the original, however, this database is
Kind of tough question about database manipulation -
Hi,
I have been trying to figure out the best way to do this for the last two days. Please bear with me...
I have about 20 scattered people using a stand-alone vb app that uses Jet (Access ) as the database. I have been asked to make something that'll make it possible to view some o
Help with database manipulation using access queries and vb.net -
I am currently working on a project in vb that needs to be able to search through a database, using a textbox as the search field, for information in that table.
Example. i have a table listed as tblMembers already created in access containing member information, and I need to be able
Mssql Server Windows Authentication -
I am accessing an MSDE database. The connection to the database is established and data manipulation is conducted via a DLL that was written and compiled by someone else - I have no way of changing this.
I can connect to the database so long as there is an SQL Server login account
ADO performance problem. -
Hello, I wonder if anybody can help. I am using ADO to access an Access 2000 database and I have hit a performance problem.
I have generated a large array and want to store it as a table in a database.
Using the addnew method in ADO it takes forever.
I used the getrows meth
string manipulation on listbox -
hi peeps,
i am a new member here, but really would like to discuss wif all of you, after seeing how active all the conversation has been..
my question would be,
is there anyone can give me examples on how to do string manipulation(get string length, replace characters, remove
Palm OCX -
Where can I get a Palm OCX for manipulation of Palm databases? I wish to be able to extract records from PDBs and bulid PDBs from desktop database files like Access etc.
Thankyou in advance,Bob.
Access VBA to VB6 -
I don't know if this has been asked before, or makes sense but I need to aks. Is there a way to convert an Access 2000 application (Forms with VBA code) to VB 6?
I have an extensive application written originaly in Access 97, upgraded to Access 2000. Most of the Data Access, SQL's
gdi32 and bmp manipulation -
i was curious what this dll can all be used for i have seen the getpixel and thats it. i figured someone out there mite be able to tell me what else i will be able to use it for in vb. thanks
edit: i was also curious what other dll's out there are used for bitmap manipulation.
ms Access 2007 -
Hi
I need to get data froum ms Access 2007.
How do I do it in Visual Basic 2005 Express Edition?
I really need some quick help. I have searched the internet and MSDN
but haven't found a complete code giving me a exact code on how to
"Connect ODBC to Ms Access 2007 IN VB.n
MySQL Connector .Net VERSUS ODBC -
I hear that these are 2 main drivers that people use in .Net to access a MySQL Database, both Connector/.Net and ODBC. In My Current project I am using
"DRIVER={MySQL ODBC 3.51 Driver};"
I have some questions on the two for my instance. I just want to be able to pull
GRaphics Manipulation -
Any1 knows good sites about Graphics manipulation in VB???
Thx
how do i access data from an dll to an ASP -
hi all
I have an application that uses an ASP scripted using VB.
This ASP references a dll which is responsible for manipulation of data.
I was able to send data from the asp to the dll and finally save it onto the data base. But now I wish to retrieve data from the database and dis
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
VB6 Connect ODBC to Ms Access 97 -
Hi
I really need some quick help. I have searched the internet and MSDN
but haven't found a complete code giving me a exact code on how to
"Connect ODBC to Ms Access 97 IN VB6". I have several times did it before but
that was years back and I've been using Java since th
Data Access and Grid control -
Hi,
Could some one please help me with the following :-
I have a table in the MS Access DataBase. And I need to access the table (inorder to display, add and edit the records) ALL Through CODE.
Could someone help me with the code for setting up a connection and reading the records
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
MSFlexgrid manipulation -
Hi
I am working on a project using a msflexgrid.
I have managed to run the program and get it to show the records contained in an Access database and everything is fine.
However, now I want to make the grid display only the records in the database that contain a certain figure
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
Whats a good database ocx/plugin for VB -
Im making a program now and the use of a database and easy manipulation/retreiving data from would help me a LOT.
Anyone know of a a ocx or plugin for VB that can use databases?
RS-232 pin manipulation II -
I'm a geophysicist. The program I am writing will monitor the earths' magnetic field via a G856 proton precession magnetometer and warn us of geomagnetic storms.
The Geometrics G856 (www.geometrics.com) can be made to output readings via RS-232 by a "pulse (pull line low) on
&
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
Can vb 6 enterprise edition do data access and manipulation[n00b] -
Can the VB 6 enterprise edition be used to retrieve information from Ms-Acess,sql... etc....? & does it also allow to add back into the database//// or are these features only for VB6 Professional Edition?
sry for the n00bs q/a
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
XML as a Flat File Database - HELP -
I want to use XML as a flat file to store data. I want to use it like a database in a way but dont need all the fancy stuff. I dont want to use Access or SQL, or anything that requires a seperate server, thats why i would like to use XML. I need help pulling the data from the XML docum