Create A Dll And Us It MS Access VBA?
Jun 16, 2010
I have created a dll in VB using Visual Studio 2005 that uses System.Security.Cryptography to encrypt and decrypt a text string. My intention was to reference this from using VBA in MS Access in order to encrypt field values in a table and decrypt it when needed.
I can use this successfully from a simple VB application that I also wrote using Visual Studio 2003 but when I try to add the dll as a reference in MS Access I get the following error: "Can't add a reference to the specified file."How can I modify the code in my dll to make it compatible with VBA?
View 2 Replies
ADVERTISEMENT
Oct 22, 2010
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
View 1 Replies
May 11, 2009
Does anyone know how to create MS Access Database using DAO in VBnet?i know it can be done using ADO ext. but i want to know if it still possible using DAO.
View 3 Replies
Apr 24, 2012
I am trying to create a database in access, and interact with it using a VB form and listboxes in particular. I am stuck on one small section which should open the rest up for me if fixed!The database has 5 columns, ID, Book Title, Author, No. Sold and Year Sold. I have managed to get my program to put all the data from 'years' into a listbox using this coding:[code]This nearly works, but the problem is that it copies ALL the Number Sold from every year, not just the one highlighted.
View 3 Replies
Jan 4, 2009
Is it possible to create an ms access file, create some tables with certain properties, and then change its extension and associate it to my application using VB.Net?
View 1 Replies
Jun 5, 2011
How to create a ms-access database with table in run time .i mean i want to create a database when user run the application
View 6 Replies
Jul 27, 2009
I need to create a .Net program that will access a webservice provided to me from a customer. I need to be able to call this .Net program from a VB6 program. Basically, this .Net program needs to be an in-between program between a VB6 program and a webservice.I'm not very knowledgeable about .Net so I am struggling to find a way to do this. When I search the internet I seem to find information on how to make a webservice. But, this is not what I need to do. I just need to be able to access a webservice provide to me and pass the data to a VB6 program.
View 1 Replies
Feb 10, 2011
how to make a crystal report in Vb.net using ms access as your back.end The purpose for this is about my project i think it's better to use a crystal report rather than to command another application for viewing your file right? ^_^
View 1 Replies
Sep 16, 2009
To create a data access form
View 3 Replies
Apr 17, 2007
New to both Access 2007 and VB 2005. Tried to create a data source with access in vb and kept getting an error about instantiation. Removed Access 2007 and loaded 2003 and no problems.
Even tried to create a mdb file with a save as 2003, did not work.Is there a way to use Access 2007 with vb?
View 4 Replies
Jan 8, 2010
I need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!
Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean
[Code]....
View 5 Replies
Jun 11, 2009
How do you create an access database dynamically?
View 2 Replies
Jun 7, 2010
I need to make an application that from a master database creates a number of access database files (tables of a larger db), then these are manually given to users who fill in data, the database files are emailed back to a user who, through the application, combines them again.The only part of this that I am unsure about is problematically creating the access db's. I have read that through Microsoft Jet OLE DB Provider and Microsoft ADO Ext I can create them (the tables and data), but I also need forms.
View 1 Replies
Jul 1, 2010
I need an example of how to create and use a random access file
View 3 Replies
Jun 5, 2011
do you Create Database in MS Access Using Oledb in vb.net?
View 4 Replies
Jan 14, 2010
i not sure can it be done.
Using VB.net by typing the name and hit the button to Show the person record from the database access.
the log file will pop out and show the person record in VB.Net
View 14 Replies
Apr 25, 2010
Does any of you know of a way to create an Ms Access Database (either mdb or accdb) without having to use adox or interop?
View 4 Replies
May 26, 2009
Is there a way to create reports from an access database using visual basic 2008 express?
View 4 Replies
Aug 2, 2010
I am using Access DB.I want to create Temp Tables in My DB.What is the Syntax for Crate Temp tables in VB.NET??
View 5 Replies
Oct 10, 2010
Is it possible to create temporary tables in MS ACCESS using VB.NET?
View 3 Replies
Feb 15, 2012
I have a storedProcedure in SQL-Server that I am using to delete duplicates from one of the tables. This storedprocedure makes use of a cursor.I tried to create the same storedprocedure in microsoft access by just replacing the 'CREATE PROCEDURE' with 'CREATE PROC' but it didn't seem to work.
Here is the SQL- storedprocedure:- ALTER PROCEDURE [dbo].[csp_loginfo_duplicates] AS BEGIN
SET NOCOUNT ON;
declare @minrowid bigint
declare @empid nvarchar(15)
declare @dtpunched datetime
declare @count tinyint
[Code]...
View 1 Replies
Mar 15, 2008
I wanna create an access database programmatically.How should this be done?Do you recommend that I do it via code?I don't know how to create an access 2003 compatible file at run-tim
View 4 Replies
Nov 21, 2011
How can i create a Database file in Access 2010 file format (.accdb) and create tables in it through Vb code at runtime by taking the filename and table names from the user.PBL (Visual Studio 2010 Ultimate)
View 16 Replies
Jan 8, 2012
My IDE is Visual studio 2008.I just want to ask how to create Stored Procedures in Microsoft Access Database (.mdb) and pass the values to a VB.NET Windows Application.
[Code]...
View 1 Replies
Jun 19, 2011
How to create Key access for that fast array in VB.NET [code] waiting for any sample, this sample fastest for me work, but retrieve by key not only by number.
View 6 Replies
May 20, 2010
Created Structure
opened file using FileOpen(1, "filename.dat", OpenMode.Random, , , bytes in structure)
used structure .ID = record number
FilePut(1, structure)
FileClose(1)
The program enters the first record but although when I enter more records it still shows only one record in the file.
View 2 Replies
May 3, 2011
How to get around access denied when trying to create subkey.[code]
View 2 Replies
Jul 22, 2010
How can I create a view (query) in Access, by SQL, using VB?
What is the similar command for the CREATE VIEW ?
In access, I only can use the CREATE TABLE, but I wanna change a view, by only using Vb.NET
How can I make this?
View 7 Replies
Feb 8, 2010
i need to make a professional form in vb 2008 to make a full backup and restore for my database file with progress bar and ability to write my backup in CD-room so
View 5 Replies
Mar 18, 2009
Im trying to create a form in VB that allows the user to perform queries on a number of tables which are in access.
View 3 Replies
