Create A Universal Platform App With An Access Database?
Nov 8, 2011
Until recently I have been using net 2005 with distributing an app which uses an access database with getting data using recordsets
I decided it was time to upgrade so I got net 2010 & started using ADO.net with a dataadapter.
To my dismay I have found that my app will not run on all platforms, ie XP, Vista 32 & 64 bit, Windows 7 32 & 64 bit From another question I have been told
"If compiled to target AnyCPU, your program will fail to run in an x64 environment if it utilizes any ODBC database driver. In this case, you must compile it to x86. Therefore, x86 is safer than AnyCPU."
Which I have found to be correct I am not familiar with all the options to open a database & the respective code required to extract/change the database data. I also don't understand the implications of using x86 cpu instead of any CPU
MY net 2005 apps have been working fine for the last 6 years (until W7 64 bit), so I want to develop an app that has the same lifespan without having to make variations to the build for specific platforms
I would like the answers to the following:
1. is x86 the new standard for specifying cpu & works on all platforms?
2. why does W7 64 bit have a windows & windows x86 system folder
3. why does my installer when "any CPU" is specified install it in the x86 system folder (W7 64 bit, even though the app fails when trying to open the database as outlined above)
4. which method of opening an access database is preferred which works on all platforms with a common cpu specified?
View 14 Replies
ADVERTISEMENT
Apr 5, 2010
I would like to create/use a system-wide independent universal 'counter object' that can be called via COM in a thread-safe manner. The counter object will be passed an ID to identify which counter to return, handle the counting, 'persist' the count (occasionally), have reasonable performance (as fast as possible) perhaps capable of 1000 counts per second or better (1mS) and be accessible cross-process/out-of-process. The current count status must be persisted between object restarts/shutdowns.
The counter object is liklely to be a 'singleton' type object implemented in some form of free-threaded dictionary, containing maybe 10 counters (perhaps 50 max). The count needs to be monotonic and consistent, (ie: guaranteed unique sequential values).Each counter should have a few methods, like reset, inc, dec, set, clear, remove. As a luxury, I would like to have a variable-increment (ie: 'step by' value). To support thread-safefty, perhaps some sorm of critical-section or mutex call. It just needs to return a long/4byte signed integer.
I really want something that can be called from anywhere, including VBScript, so I figure COM is my preferred solution.The primary use of this is for database keys. I am unable to use autoinc or guid type keys and have ruled out database-generated counting systems at this point.I've spent days researching this and I have really struggled to find a solution. The best I can find is a free-threaded dictionary object that can be instantiated using COM+ from Motobit - it seems to offer all the 'basics' and I guess I could create some form of wrapper for this.
[Code]...
View 4 Replies
Aug 2, 2011
I'd like to test Oracle database connection via web service. Could I create Oracle database in MS development environment? Oracle version is 10.2... is it Oracle 10g. I'm familiar with MS SQL Server. Oracle is new for me.
View 1 Replies
Sep 8, 2011
I'm creating 10 web browsers at runtime, they are all in WBS() array and i need "navigated" event for all of them with ability to identify sender. Either 1 event for this array or event for all web browsers and then i would just check it they are the ones from array.
View 2 Replies
Jun 13, 2008
I have run across exam ples of how to create code for getting the universal naming convention for mapped drive in VB6 and access but that don't work in VB net.
View 4 Replies
Aug 4, 2009
I have a interesting problem: Where I work we've built a home-grown ERP system in VB6 that we are slowly moving over into vb.net. There are some projects have are in .net: we have a hand-held C# project that uses a web service to talk to our database, I've built some reporting screens using Crystal and some smaller maintenance screens.
Well as we have been plotting the conversion out, we want to have a way to separate our business logic and UI so that the UI can be a win/web form or a Smart Device project. Is this even possible? I try to reference the DLL in a test I have and it gives me this error when trying to debug using a emulator Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%smartdeviceproject1system.windows.forms.dll'. Error 0x80070070: There is not enough space on the disk.
View 2 Replies
May 12, 2010
I need to connect to MS Access 2003 database using ADODB connection from Visual Basic.I use the following connect string.
View 1 Replies
Jan 14, 2011
I want to create a RTSP/h264 video stream from static images, and incorporate it into my .NET application. So far I have found two possible ways to do this:
Use ffmpeg/ffserver, but I would need to compile ffserver on windows and then rely on it... and I don't necessarily want to rely on an external application
Use the LIVE555 [URL] library, but they do not have any .NET libraries, so I would need to spend some effort to make it work with the rest of my .NET application.
Can you comment on either #1, #2, or which is better. Is there a faster way to bring up a RTSP server in .NET? I do not mind putting in development time if there is a solid solution that takes time, but it would be good to have something we can work with fast, for prototyping and demos.
View 3 Replies
Jul 1, 2010
We have developed an application using Visual Basic .NET as the front end and Microsoft Access as the back end. If we run the application on Windows XP we can write records to the database but when we run it on Vista it does not write records to the database.
View 2 Replies
Oct 9, 2009
does VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 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
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
Feb 4, 2011
i have encountered a problem, i want to access the data coming to the computer from the in-built bluetooth module of a computer on windows platform, this data has been sent by a remote bluetooth module say a by an autonomous device (just like a bluetooth mouse connecting to the computer). The to be sent is in the form of numbers and i need these to manipulate on the computer.
View 6 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 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
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
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
Apr 9, 2012
so far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
View 4 Replies
Dec 5, 2008
I'm doing my work in VB express 2008. I'm trying to connect it to my access 2007 Database, so a user can log in with ther username and password, if they are using valid username/password.
I've connected my Access 2007 database using Data Source window: data->show data sources->add new data source.
Is this the correct way to connect database for my Log-In page? [code]...
View 3 Replies
Feb 5, 2010
What I need to create Microsoft Access database using VB.NET? I was looking for microsoft ado ext. 2.7 for ddl and security but I could not find anywhere.
View 2 Replies
Jun 21, 2010
I have an issue with my access database when creating a simple insert form on visual. When I load the form into the browsers and add the data, it says it has worked but when I look in the database the information has not been added.
View 3 Replies
Oct 22, 2009
I want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 Replies
Jun 5, 2010
I am attempting to create a program for a business but i have no idea how to create a database to hold the information and allow me to access it when needed
View 1 Replies
Jan 1, 2012
Im working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 Replies
Jun 5, 2011
I have a requirement to create n Access 2007 database & some related tables from my application at runtime.
I used to be able to do this ages ago in VB5 but having difficulties doing it in VS (VB) 2010.
View 1 Replies
