I want to write into Access Database File using C# Application, probably using WPF ... I also want the file to be password protected ... is it possible to connect to it while it is password protected or should I remove the password? ...
i will be importing a table with data. one of the columns called CAR will look something like this: mercedes,ford,toyota for every record in the DB i will need to add a comma , to the end of the string like: mercedes,ford,toyota, since i will be programmatically importing the table, what is the best way to add this trailing comma t...
We have a program in which each user is given their own Access database. We'd like to merge these all together into a single SQL Server database. The problem is that, using the SQL Server import/export wizard, the primary/foreign keys do not get updated. So for instance if one user has this table: 1 Apple 2 Banana and another us...
I've spent hours trying to figure this one out. This is for a manufacturing plant. A person on the plant floor logs their activities on different machines using a computer system which produces data like this: Empnbr Datestamp Shift Machnbr Time 00090 6/30/2010 1 0354 11:10 00090 6/30/2010 1 S 12:00 00098 6/...
Hello I am building a form in access database. I have a combo box which is linked to a query which is looking up a unique reference number from a table called Tbl_Submitted_Requests. What I need the form to do is auto populate the other text boxes when the user selects the unique reference from the combo box. How can I get the text bo...
Hi I have an MS Access 2003 frontend and mySQL backend. I would like to automatically connect to MySQL when the MDB is opened for the first time, eg when the Main Menu form of Access is displayed. However I have no idea and I keep getting the "annoying" MySQL "Connector ODBC" pop up box. This happens when I go into a form in Access whi...
Hi I am working on MS Access 2007. The project is a data entry project with chained forms inserting data into respective Access data tables. The data entry part is working just fine with Arabic strings. My problems arise with reports created within Access. In a typical report page, pie charts were created using the chart wizard and pred...
I have been developing an application in Access 2003 that uses SQL Server as the back end data store. Access is used only as a GUI and does not store any data. All the code in the application is written in VBA using ADO for data access. In recent meetings the DBA that works in my organization has become increasingly concerned over the f...
How can I create access 2000-2003 file using C# WPF and add tables in, data in and perform queries on it? ...
How can I create access 2000-2003 file using C# WPF and add tables in, data in and perform queries on it? I`m using MS Visual Studio 2010 this is what I`ve been able to accomplish: OleDbConnection conn = new OleDbConnection(); string myDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); strin...
I am using SSIS to grab the results from 2 Views in a SQL Server database, union them (with appropriate mapping), filter them and place them into an Access database. This process is working, but the precisions of certain data are changing. I was already aware of the normal float/real problem of storing approximate values (e.g. http://s...
I'm looking for some tips on how to export a mysql database into a .mdb file that is readable by Microsoft Access 2007+ (and editable too!). It needs to be a script that can run on a Linux server (maybe using PHP?). I can't seem to find out anything anywhere. Any ideas? Cheers! ...
I have a mySQL database that tracks our projects and drives our website's display of their info. For ease of updating the database I have set up an access database that used an ODBC connection (MySQL ODBC 5.1) to edit the data. It has been working just fine for the past few months with no hiccups. However, last night users(2 of 3) exp...
Hi developing an application in Access. The access file will be located on a db however when users need to use it, I want them to copy it on there desktop. If they do run it off the G:\ drive (our networked folder), it should give them a message. So are there Win API that will help me solve this? I am going to put this code in the For...
here is my expression: =([Panels] not Like '*IT_AMPH,*' and [Panels] not Like '*AMPH_SN,*' and [Panels] not Like '*AMPH_S,*') can i say this instead: = not ([Panels] Like '*IT_AMPH,*' Or [Panels] Like '*AMPH_SN,*' Or [Panels] Like '*AMPH_S,*') are these expressions the same? *i need to mention that my question is not about logic i...
I have an Access frontend with a lot of tables linked through ODBC to a MySQL backend. I have a VB.net application that sometimes adds columns to the tables in the backend, and when that happens, I need to refresh the link to the table in the frontend from the VB.net app to show the new columns. I'll consider just about any solution as...
Here's what I've tried: -Find Vista's ODBC Data Source Manager* through search, -Add a new File Data Source*, selecting Driver for Microsoft Access (*.mdb), and selecting my mdb file of interest, -import pyodbc from python shell and try: pyodbc.connect("DSN=<that Data Source I just created>") I get the following error message (Port...
I have a simple piece of code written to open a report. Private Sub FormButton_Enter() Dim strwhere As String strwhere = Me.FormText DoCmd.Openreport "rtpname",acViewPreview,,"ColumnName=" & strwhere End Sub I am getting two popups , even though i pass the filter criteria from the form. Please advice. ...
I am developing a database with about 10 tables in it. Basically it will be used in 2 or 3 distant geographical locations (let's call them A,B and C). The desired work flow will be as follows: A,B and C should always have the same database. So when A does any changes he should be able to send those changes over to B and C. Emailing the e...
Hi, I have a large 1.3 GB accdb file to which I added security by password protecting it. Accdb file enforces encryption along with password protection so now i am not able to Compress it with winzip. Is it possible to password protect that file without encryption. Any help is greatly appriciated as both are must for the work i a...