It's the Office app everyone loves to hate ;) I admit that it's often abused or misused, but it does come in handy on occasion. So what do you think? Are there appropriate uses for Access, or should MS jetison it from the Office suite? ...
We have a Microsoft Access database that has been used for many years. Our staff is very used to using the Access tables and forms to query, view, update and add to the data. But the database is at the end of its lifetime. We want to convert it to a PHP/mySQL solution. I have found tools that can convert the Access database to mySQL. ...
I have an ODBC connection to a database I don't own and can't change. What I am looking to do is to make related records merge into one record. The relationship is a 1 to many. I have a student managment system and want to export a call out list which feeds an automated callout service (charged by Call). I want to be able to call a ...
I think this should be easy, but it's evading me. I've got a many-to-many relationship between Accounts and Account Groups. An Account can be in zero or more Groups, so I'm using the standard join table. Accounts -------- ID BankName AcctNumber Balance AccountGroups ------------- ID GroupName JoinAccountsGroups ------------------ AID...
I have a single entry output from a paradox table which is imported into Access. Now I have created a report and done the databinding within the report to the dataset from Paradox. When work is done in Paradox the single entry output changes... How do I open up access and have the values from the report update automatically without hav...
I'm wondering how to add several data tables that I've built in code, to a blank MDB file that ships with my app. I find it easy enough to connect to the MDB file via the OledbConnection object, but then I'm at a loss for an easy way to add my tables to it. There it sits...open...and empty, but what next? I can add my tables to a datas...
Which can be the easy way to export some user tables (DDL and data) from an Oracle database to a Microsoft Access database Automatically, it means without user interaction. UPDATE: Linked tables on Access database raises the user/password dialog to connect oracle which is not a valid option. ...
I have a website I've built in VS2005, C#, .NET 2.0. This website does transactions against an Access database. It works fine in development. The mdb file resides in App_Data I have setup IIS on this machine to test the website as it would be deployed. I published the site to my IIS virtual directory. All went well. Whenever I try to ...
Hi, I have problem with unicode.. i have multi language project. when i enter the data in local language, in access the data is storing something like this as " ಅಮà³à²®" but i want those characters of local language to be seen at the bach end.. could you please suggest me ?? am using java, windows vista, and ms-access.. I had set ...
I'd like to find a good book to read to come up to speed on Visual Basic for use with MS Access. I don't want a book for dummies. There's plenty that I don't know, but I'm no dummy. I also don't want a book for neophyte programmers. I've programmed in several programming languages, and I'd like to leverage what I already know to help...
We have a set of applications that work with multiple database engines including Sql Server and Access. The schemas for each are maintained separately and are not stored in text form making source control difficult. We are interested in moving to a system where the schema is stored in some text-based format (such as XML or YAML) with d...
Hi everybody! We've got a weird problem with joining tables from SQL Server 2005 and MS Access 2003. There's a big table on the server and a rather small table locally in Access. The tables are joined via 3 fields, one of them a datetime field (containing a day; idea is to fetch additional data (daily) from the big server table to add ...
In my application I do the follwing things: Open a Access database (.mdb) using Jet/ADO and VB6 Clear and re-fill a table with new data Close the database Start another process which does something with the new data. The problem is that sometimes the second process cannot find the new data. Sometimes the table is just empty, sometim...
Is there an easy way, preferably with a scripting language or a small tool that could be called through a batch file, to operate on a text file, mark an offset, and put everything after the offset into a new file? I have a text file added to nightly, and I would like to make it so that the end of the file is marked, then after new data ...
I am amazed and dumbfounded to find out that a report generated in Microsoft Access will not include the charts I generated when exporting to Excel, Word or any other technology. Has anyone found a work-around for this? My user base needs to be able to copy/paste the generated reports (including graphics) into different status reports....
Using my tool (vb.net) I am able to count Activex controls present in a access DB Form. Is it possible to bifurcate the controls? i.e. I want to count activex controls separately. e.g. If there are total 10 Activex Controls, out of which 5 are calender control and 5 are check boxes. Then I need to count separately. Is it possible? Plea...
How do I calculate an MD5 of a string client side in Microsoft Access? ...
I am trying to troubleshoot an MS Access XP database and the first thing it does it close the main window and prompt for a date. Everything I enter comes with an error message stating that the value entered is not a valid date mm/dd/yyyy. It then proceeds to close access. I've tried every date format I can think of to no avail. Is it po...
Is there any way I can identify unused forms/reports/queries in a compiled Access (2003) project? Edit : There is no check for unused objects menu item in my database window. ...
I have an access DB which we use to track tickets. Each ticket may have multiple occurrences because of different programming changes associated with that ticket. Each record also has a program_type field which is SVR or VB. Example: 123456 - SVR - SomeCode 123456 - VB - SomeVBCode I've added a column to the database called VB_Flag, ...