DB/Reporting :: Migrating Access Database To MS SQL?

Jul 16, 2009

I need to update a database app written in VB, Visual Studio 2003, using an Access Database.Currently: Customer has 4 users, local network. Access Database is 30MB, about 50 tables.Wanted: Customer is opening new offices, and wants to connect to the database via the internet. There will be 10-15 users.App background: I have all data access via OleDbDataAdapters and one OleDbDataConnection.There are 4 DataSets: Global, Lookup, Reports, FormSpecific.

I have one Private function: FillTable:

Private Function FillTable(ByVal TableToFill As DataTable, _
Optional ByVal OleDbAdpToUse As OleDb.OleDbDataAdapter = Nothing) As Integer
' fills the table by using OleDbDataAdapter.Fill(aTable)

[code]...

All is working well.What I Need to Do:I think I need to migrate the Access Database to MS SQL. What I Have:Visual Studio 2008 Professional. I have started the MS SQL walkthroughs. I did the �Create a Data Connection to the Northwind Database� walkthrough, and connected via MS SQL Server. I cannot find where I can modify the SQL Commands. If I convert my Access Database to a MS SQL Database then can I

1) Just update the OleDbConnection, so it connects to the MS SQL Database (not the Access database).

2) If I cannot do #1, what do I need to start with?

View 6 Replies


ADVERTISEMENT

DB/Reporting :: OLE Database Access - Move My Programs And The Database To Another Computer And Hard-disks

Apr 21, 2008

I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?

View 3 Replies

Migrating From Access To SSCE?

Jan 4, 2012

I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets.Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?

View 6 Replies

DB/Reporting :: 3 Laptops Access Same Database

Sep 29, 2010

---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?

View 1 Replies

DB/Reporting :: Access Database In VB 2005?

Aug 21, 2008

I'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?

View 3 Replies

DB/Reporting :: ACCESS Database With 3 Columns?

Dec 3, 2009

i have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.

View 5 Replies

DB/Reporting :: Accessing ACCESS Database?

Aug 29, 2009

I installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".

View 7 Replies

DB/Reporting :: Connecting To An Access Database?

Aug 27, 2009

I'm trying to query an access database, but my query results only display the first cell of the query results.

For example, if I select 3 columns, 5 rows, only Column 1 Row 1 is displayed. Someone mentioned something about EOF but I can't find EOF code for OleDB. Should I be using another type of connection?;

Code:
Private Sub btnGetReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetReport.Click
Dim StartDate, EndDate As Date

[Code]....

View 1 Replies

DB/Reporting :: Create Access Database?

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

DB/Reporting :: Creating A Database Without Need Of MS Access

Aug 2, 2009

I'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?

View 7 Replies

DB/Reporting :: SQL - Using Access 2001 And My Database ?

Mar 11, 2008

I'm using Access 2001 and my Database is structured as follows:

Chance(Number, Detail, Action, Amount, Owner)
CommunityChest(Number, Detail, Action, Amount, Owner)

[CODE]........

I'm making a Monopoly Game which i'll make sure i post up here when done, I'm using Visual Basics 2005 and OLEDB Connection, i know how to work all that but i have the following scenarios to find SQL for.

Upgrade Property - I need to use the Update Query for this. A PropertyName is selected from a list box and someone then clicks to upgrade a property.

Properties.HousesOwned should have it's value raised by 1 Where the player owns all 3 sets. The Houseprice should then be took off the Players Money.

Downgrade Property - I need to use the Update Query for this. A PropertyName is selected from a list box and someone then clicks to downgrade a property.

Properties.HousesOwned should have it's value lowered by 1 (until it gets to 0) Where the player owns all 3 sets. The Houseprice should then be added to the Players Money.

View 2 Replies

DB/Reporting :: Update A MS Access Database?

May 30, 2009

I'm trying to update an MS Access database, but that doesn't seem to work. I do NOT get an error, but nothing changes in the database.

Code:
Dim myCommand As OleDbCommand = Nothing
Dim strUpdate As String
strUpdate = "Update Settings Set Data = @Data Where Name = @Name"

[Code].....

View 11 Replies

DB/Reporting :: Vb 2010 And Access Database?

Dec 13, 2010

I'm new to Visual Basic. I came across a random number generator tutorial. Got it working fine and then I thought, Is there a way to get it to access a database Here's the thing

1. Generate the random number.
2. looks at the database and finds the corresponding id number.
3. Takes the field for that number and enters it into a text field in the program.

So for example the number generated is 32. Then the program looks at the database and looks for id number 32. then takes the text in line 32 and enters it into a textbox in the program.Now I have my database and the program. But just can't seam to figure out how to get the two connected like I want. I have looked and searched but have found nothing like it I am using Visual Basic 2010 and Access 2007.

View 2 Replies

Reporting :: Add Data To An Access Database?

Aug 18, 2009

I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:

Code:
Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OpenFileDialog1.FileName = ""
OpenFileDialog1.Title = "C# Corner Open File Dialog"

[code]....

View 4 Replies

.net - Migrating Application From Microsoft Access To VB Or C#.NET?

Sep 5, 2010

I'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.

I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.

Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?

What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.

We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.

I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.

So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.

View 5 Replies

Migrating MS-ACCESS 2003 To DotNet

Nov 17, 2011

Would like to migrate MS-ACCESS 2003 legacy applications into modern Dot Net, including migration of the MS-ACCESS Database to Sql Server 2008 (with potentially also migration of the MS-ACCESS Reports to Sql Server Reports). The purpose is to move to DotNet application with Sql Server as its database.

[Code]....

View 5 Replies

SQL Server - Migrating From Access To SSCE

Jan 4, 2012

I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets. Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?

View 1 Replies

DB/Reporting :: Adding To Ms Access Database Using VB 2008?

Jan 11, 2009

I have two tables in the MS Access 2003 database " SAMPLE" and they are : 1. INFO 2 INFO2Now i have created a form in VB 2008 express edition with the text boxes: Name, Age, Occupation.he tables INFO has - Name, Age as columnsAnd INFO 2 has - Name, Age, Occupation.All i want is when the user presses the ok button, it should add the name & age to INFO and also add Name, Age Occupation to the INFO 2 Table.

View 10 Replies

DB/Reporting :: Get Column Type From Access Database?

Sep 29, 2008

How can I get information what data type a certain column is. (Integer, string, memo,...)

View 1 Replies

DB/Reporting :: How To Access A Database With Visual Studio

Feb 1, 2012

I've been googling to find a guide on how to access a database with visual studio.I cant find anything complete or up to date. I should point out that I dont have a great deal of experience with SQL.I'm not really 100% sure where to start. Most of the guides I've found tend to assume your accessing an existing SQL database and I need to set one up from scratch. I'm not sure if I'm even setting SQL server up correctly. point me in the right direction on where to get started. A good, up to date tutorial would be great.

For my purposes the SQL database will only be written to from the local machine but there will also be another machine writing to this database.I'm currently using Visual basic Express 2010 and SQL Server Express 2008 R2, mostly because they are the most recent when I googled it.

View 3 Replies

DB/Reporting :: Restricting Access To SQL Server Database

Dec 8, 2009

I have developed a Windows Forms application using VB.NET and MS SQL Server 2005 Express Edition. My database name is 'AC'. I do not want ANY user, SQL Server or Windows authenticated, to access, read, write to, update, drop or take backups of this database, except this login 'Adel'. So my connection string looks very similar to:[code]What configurations should I make in the MS SQL Server Management Studio 2005 Express Edition to 'Adel' login, 'AC' database, and all other logins to accomplish this?Given the following:I do not own the server; my client owns the server. They have a domain set up (LAN network).They have ASP.NET applications running using other databases on the same server. However, these applications have nothing to do with my database 'AC' or login 'Adel'.Some of their applications do not specify 'User Id' in the connection string; they use 'Integrated Security=True'.

View 2 Replies

DB/Reporting :: Save Textboxes To A Access Database?

Aug 4, 2009

Does anyone have any code on how to saves the following textboxes to a access database

Userid (on form1)
Reel no (on form2)
Reel weight (on form2)

[code].....

View 1 Replies

DB/Reporting :: Scrolling Through The Rows Of Access Database

Jan 25, 2009

Usually, to go through my Access Database records in VB, i used the "Data control tool" in the older versions of VB, but i cant find it in VB2008, is there anyother tool that allows you to scroll through Access database records, on VB 2008?

View 1 Replies

DB/Reporting :: Searching Across Access Database Fields?

Mar 30, 2010

I use the following code in vb.net to search across several Access database fields, which works well, is there a way to find out WHICH field had the search data in?

[code]
Public Function Incomming_Number(ByVal strNum As String) As String
Dim oConnect As New OleDbConnection
Dim sql As OleDbCommand

[code]....

View 2 Replies

DB/Reporting :: Updating And Savinf A Access Database?

Jul 6, 2009

I'm currently looking to add a code where, when executed, finds the appropriate value (searches for it), then on the same line, but in a different category, changes the text to 'YES'.

[Code]...

View 2 Replies

Assistance With Migrating Text File To Access

Mar 5, 2009

I created a program that logs incoming data to a serial device to a text file but the output is not what i really want, the data appends to the text file and looks like:

[Code]...

View 9 Replies

DB/Reporting :: Access Database Decimal Type Error

Jun 28, 2008

I am trying to insert a variable in Decimal type into an Access table. When I use "decimal" field with 0 digits after the decimal separator (,) my program works properly. However, when i use the field with 2 digits after the separator I get a "Data type mismatch in criteria expression." exception. This happens also when I try to update the table. The debugger shows me that my variables contain the right values but the update or insert command gives the error.

View 2 Replies

DB/Reporting :: Can't Open Access Database On Mapped Drive

Dec 8, 2008

I can't open an Access database on a mapped drive. However it works if I use the UNC path. how I can get this to work? See the code below for an example of what works and what doesn't...

Code:
mConnString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=\tiger-2000dvb_mt7MTrackBE.mdb" ' This works
mConnString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=T:vb_mt7MTrackBE.mdb" ' this does not work
Dim objConn As New OleDbConnection(mConnString)

[code].....

The error message I receive is...'T:vb_mt7MTrackBE.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.I've done the obvious and verified that t:vb_mt7MtrackBE.mdb is a valid path.

View 3 Replies

DB/Reporting :: Fill Access Database Table From Dataset?

Jun 5, 2011

I have 2 databases that I am working with. One is a compant customer database and the other is my personal call log. Now I am creating a front end for the Call Log. I was updating my customer list by Importing 2 tables from the customer database, a series of queries would erase all of my info, take all the data from the imported tables and move it into mine then erase the imported tables.

Im trying to accomplish the same in my VB frontend. I can connect and fill datasets from the customer database. I can erase my tables. How do I take all of this data from the newly created dataset and move it over to my empty tables?

[Code]...

View 1 Replies

DB/Reporting :: Import From Text File To Database (access)

Nov 10, 2009

I am trying to import a text file to an access database in VB2008 express. The text file I am testing with is a csv file with 34,000 records. The problem is this takes 2 minutes to read through all this and write it to the database. The actual text file I will be using in production has over 800,000 records and this will take a ridiculous amount of time. I think I am doing something wrong. I have posted my code below. I am reading a record, parsing out the fields to an array, then creating an SQL statement to insert the record and executing it.

reader = New IO.StreamReader(fname)
Do While reader.Peek() >= 0
linesread = linesread + 1

[Code].....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved