So we have a few (or more, no one knows) apps written by someone who has now left, these apps access Microsoft Access Databases stored on this developers old PC, which in turn read from our Production SQL database. Now to track all these programs down, and what time they are run, I'd like to keep a log of a files access time, is this pos...
I have code that depends a relatively small MS Jet (created in Access) database. Our source control process is far from all that it could/should be (which is a problem that needs to be solved immediately) and we have ended up with two versions of the same database. The person who edited the "other" version is no longer around to give me ...
[Apologies for long question but I thought it would be clearer for others to answer] I have a Microsoft Access database and it contains a table "Customers" with following columns: ID (auto number) Name (Text) Active (yes/no) I created the database table class in C# as below: [Table (Name = "Products")] public class Product { [C...
Hi, We have Exchange 2007 and have a need for quite complex group scheduling. Group scheduling is useless if the people invited do not see it in their Outlook Calendar of course. The data about when those appointments are to take place and who should be there live in an Excel or Access application. I bought the Microsoft book "Inside Mi...
I have two Access 2003 databases (fooDb and barDb). There are four tables in fooDb that are linked to tables in barDb. Two questions: How do I update the table contents (linked tables in fooDb should be synchronized with the table contents in barDb) How do I re-link the table to a different barDb using ADO.NET I googled but didn't g...
I've been trying to find some information about getting access to the raw code in MS Access (I use v2007 but should probably apply to all versions). Say for instance that I'd like to list all functions in every code-behind form and module in the application and list their parameters. How would you achieve this? Note: I'm of course ass...
I have inherited a web application with an Access backend (yes I know). I need to get this thing deployed asap to a shared hosting provider. Unfortunately, it's not as easy as I imagined as hosts tend to lock down access to Access databases (AFAICT). I have a shared account with GoDaddy - I have enabled Access database use, and created...
I have to use a Microsoft Access application. (At least until I've got time to rewrite it in another language.) I've got a report that throws the error "Syntax error in PARAMETER clause." At the moment the SQL looks like this: PARAMETERS [Test] Text ( 255 ); SELECT … If I remove the PARAMETERS-line the problem vanishes. Strange is,...
I am building a small application for a friend and they'd like to be able to use Excel as the front end. (the UI will basically be userforms in Excel). They have a bunch of data in Excel that they would like to be able to query but I do not want to use excel as a database as I don't think it is fit for that purpose and am considering usi...
Given a pre-configured ODBC System DSN, I'd like to write a function that gracefully tests that connection using VBA. Private Function TestConnection(ByVal dsnName As String) As Boolean ' What goes here?? ' End Function Edit: To clarify, the System DSNs are pointing to external SQL Server 2005 databases, with Windows NT authenti...
I have an MS-Access 2003 front end (backend SQL2000) that I want to move to asp.net. The system is too hungry bandwidth wise to run across the web/vpn. I have started manually building the aspx and ascx's, which is becoming a bit of a nightmare, and will start on the code shortly. Has anyone successfully migrated MS-Access/vba to asp.n...
Hi, I've seen numerous answers to similar questions like this one. I haven't seen on the web many people have asked the seemingly simple question "How do I connect Access 2007 to an SQL server 2008 database" - but all of the answers describe how you can migrate from access 2007 to an sql server 2008 database, or they describe how to conn...
I have an Access application with a SQL server back-end, mixed with quite a few DB objects local to the Access app. I've tried running SQL Profiler, but I got very little except a cryptic sp_execute 2,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297. I would like a trace tool that is local to the Access DB, so I also pick up any activ...
[Edit 2: More information and debugging in answer below...] I'm writing a python script to export MS Access databases into a series of text files to allow for more meaningful version control (I know - why Access? Why aren't I using existing solutions? Let's just say the restrictions aren't of a technical nature). I've successfully expo...
Hi, I have the following table: log(productId, status, statusDate, department...), where productId, status and statusDate is the primary key. Example: id1 01 01/01/2009 id1 02 02/01/2009 id1 03 03/01/2009 id1 01 06/01/2009 id1 02 07/01/2009 id1 03 09/01/2009 id2 01 02/01/2009 id2 02 03/01/2009 id2 01 04/01/2009 id2 03 06/01/2009 id3 01 0...
I have a table errors(errorId, category, eDate). I am trying to show as result the number of errors per week and categories. The query result should be something like: Week Category1 Category2 01 2 5 02 0 20 ...
I have a table which contains a book and then multiple prices about the book (this is a highly simplified sample): ID BOOK PRICE 1 BOOK1 10 2 BOOK1 15 3 BOOK1 12 4 BOOK2 8 5 BOOK2 2 I am easily calculating the average, but there must be a nice way to calculate the median? Current SQL: SELECT DISTINCTROW Books.BOOK, Avg...
I made a standalone Access 2003 app with a bunch of forms that is beginning to get unruly. I'm trying to clean it up a bit and I'd like to do things such as find all uses of a query so that I can make some global updates. I can use ctrl-f to find uses of a query in code but my question is: Is there an easy way to search the entire app...
I'm trying to connect to an Oracle Database with Access 2003. I want to use an ODBC connection and I want to set it up so that the user doesn't need to enter a password. One of the problems I am having though is my sql query uses INTERFACE.Products and Access sees the period and thinks I'm trying to opening a file. IE Interface.MDB, w...
I am getting the following error when I try to open a report in Access 2007. The code works fine in Access 2003. run time error '3075' Syntax error (missing operator) in query expression '[COUNTRY_ID]=' here is the code giving the error... How could I fix this? Private Sub List25_Click() Combo20.SetFocus 'DoCmd.FindRecord List25....