I have been asked to setup a course leaflet system for a college. For whatever reason in the past their current system is not linked to their actual course file, they wish to close this link so course leaflets are related to actual course codes. Unfortunately their course file is a ms access database linked to many of their existing syst...
I am trying to connect to a SQL Server Compact edition db (.sdf) from Access 2003. Here's the start of my code: Const sdfPath = "C:\SSCE\AmphiData.sdf" Dim pConn as ADODB.Connection Set pConn = new ADODB.Connection pConn.ConnectionString = "PROVIDER=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source = " & sdfPath pConn.Open The Open com...
I have an MS Access 2002 database with password security. When I exit the application, the password dialog box reappears. Now, after this I can only exit the application if I give in the password again or press Cancel. I don't know why this dialog appears on exit. ...
So I have an Access application, and I'd like some forms to be maximised when they are opened, and others to be medium-sized when they are opened. However, if I try something like this: Private Sub Form_Activate() DoCmd.Maximize End Sub or Private Sub Form_Activate() DoCmd.Restore End Sub it has the effect of maximizing or res...
I have been trying to read a picture saved in Access DB as a OLE object in a PictureBox in a C# windows Application. The code that does this is presented below: string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Rajesh\SampleDB_2003.mdb;"; OleDbConnection oConn = new OleDbConnection(connString); ...
I need to migrate Access databases to SQL Server 2005. Since this needs to be done from within a setup so that a customers' installation is transparently migrated to SQL Server 2005, I wonder if it is possible to automate the SSMA toolkit from Microsoft. ...
How do I broadcast a message from a single source to all nodes, and from multiple sources to all nodes? Are there any libraries in java that may help? ...
I work for a custom cabinetry manufacturer and we write our own pricing program for our product. I have a form that has a pop-up box so the user can select which side the hinge will be on for ambiguous doors on that cabinet. I've got that to work so far, but when they copy an item and paste it at the bottom I don't want the pop-up box ...
Hi all, I have a problem perplexing me to no end. When I run the following query against an access database: SELECT * FROM PreferredSpacer INNER JOIN SpacerThickness ON PreferredSpacer.SpacerTypeID = SpacerThickness.SpacerTypeID ORDER BY PreferredSpacer.UnitTypeID DESC (UnitTypeID field is a text type) The results do not come ...
I am having a real problem at work with a highly ingrained developer obsessed with ms access. Users moan about random crashes, locking errors, freeze's, the application slowing down (especially in 2007) but seem to be very resistant to moving it. Most of the time they blame the computer and can't be convinced it's the fact its a mdb sat ...
I have coded a MS Access 2000 report that displays a calendar with one month per page and projects added to particular days. The only data in the underlying record source is a list of months. The structure is created via the On Page event, which also reads in other data. When this report is opened, I've noticed that the On Page event do...
Are there any alternatives to MS Access? Requirements: Portable Database file Integrated form development for data entry No compiling necessary. Can be modified on the fly. Two more requirements: Available for Linux or Windows Does not have to be free EDIT: Emphasised Integrated form development for data entry as the top voted ...
Background I work for a large organization which has thousands of MS Access applications floating around. I didn't write any of these - in fact, most of the original authors have long since left the company - but from time to time another Access app lands on my desk for support. I would soooo love to replace access with a different so...
I'm working on something that was built on a PC set-up using php and an ms access database. When I port the app to my MAMP environment, I get Fatal error: Call to undefined function odbc_connect() in /path/to/index.php on line 37 line 37 looks like this: return odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=myfile.mdb",...
What is MySql equivalent of the Nz Function in MS Access? Is Nz a SQL standard? In Access, the Nz function lets you return a value when a variant is null. Source The syntax for the Nz function is: Nz ( variant, [ value_if_null ] ) ...
I know that Open Office Database uses a java database backend. Does anyone have any insight on how this compares to the Jet Database Engine? Also is the query designer/reporting nearly as robust as MS Access? ...
Hi to all, I'm trying to get a query working that takes the values (sometimes just the first part of a string) from a form control. The problem I have is that it only returns records when the full string is typed in. i.e. in the surname box, I should be able to type gr, and it brings up green grey graham but at present it's not bring...
It's the usual story, Access 2000 file created by former employee who protected the VBA code with a password. Now, some time later, the VBA code needs to be changed and we're unable to extract the password from the former employee. Searching online gives dozens of tools claiming to recover VBA passwords, but they have a wiff of Trojan a...
So I have an Access database with a front and a back end. I will be distributing it to users soon, but I have no control over where exactly they will put the files on their computers. However, I think I can count on them putting front and back ends in the same folder. As such, when the front end opens, I want it to check that the link...
While opening any MS Access database, a security warning appears saying that the file can be harmful to the computer. However, is there a way to remove this message. Or should it remain a necessary evil ...