Some users will use the database as read-only and some will need to add, delete and update records. Now, users that will be read-only on the database also have the read-only rights as windows permissions on the backend directory. What happens obviously is that the backend becomes read-only. I thought using the access security thingy wo...
Such a simple task: How to store a Byte[] in Access 2010? (Searching the web all day long about this.) I have to use a "Attachment Field" in access 2010 because as far as i can see there is no other possible (varBinary, Image,..) field available. I tried: (ConvertImageToByte returns a Byte[]) Cmd.CommandText = "UPDATE Clubs SET Field...
Long story: I need to connect to mdb stored on a separate windows computer from php running on apache2 on linux. I guess odbc is the way. But the only available driver, libmdbodbc, seems to be buggy, dying randomly at odbc_fetch_row after successful odbc_exec - and taking php with it. Moreover, I'm not sure how well it handles concurrent...
Is there a way to view A PDF file in access? I am storing the path to the file in the database and am able to open it from a button in the database, but I'd like to be able to show a preview of it as well. ...
Pardon my outrageous silliness, I don't know if this is even possible. Here's the situation. There is an MS Access "database" (yes, I know, believe me, I know) which I'll need to SELECT, UPDATE and INSERT to from a remote location. The catch is that this needs to happen securely. I have complete control over the remote machine which h...
In MS Access, I have a simple data entry form. At the bottom of the screen, you can step through the records and doing so updates the form with each click: How can I do that from a combobox on my form? That is, I want to be able to quick-pick an item from a list and have the form show that item. As a shameful attempt at more exp...
Hi, I'm connecting to a Jet 4 DB through ODBC. The Jet DB uses pass-through queries to an Oracle DB. This works so far (can't access the p-t queries directly, but creating a view on the query does the trick). I need some subset of the data returned by the p-ts. Parameters would be best, but are not supported. Two questions: 1) Jet d...
Hello all, The company I work for have an access database that is linked to a sql server table. The database is on a shared network location so it is used by lots of people in the company (with the annoying problem that only one person can use it at a time). There are several forms that are used as a front end for the data and on one pa...
Hi, I am developing a win .net application which runs continuously in server machine. Application will get connected with access(mdb) databases resided in several client machines using Jet 4.0 OLEDB provider. Each connected database was already in use by some other application installed locally. My app successfully communicates with...
Hi folks, Apologies for posting this but although there are a few examples on the site, I just can't get mine to work. So I have two tables as follows: A Telephony table ID | Name | GradeID 1 Richard 1 2 Allan 1 3 Peter I also have a Grade table: ID | Name 1 1 2 2 3 3 4 4 5 5 Anyway I'm trying to us...
I have an access database with a table. This table keeps getting records deleted, and I can't seem to find where the delete command is coming from. Can I simply protect the records in some way so that NO ONE can delete them? ...
I know that docmd.close will close the current form but for some reason I have gotten it in my head that I want to be more explicit. What I do is docmd.close acForm, me.name. Is that totally crazy or is there a good reason to do this? ...
I need to read the data in an Access 97 file that has about 400K records. I would like to use either TurboDelphi Pro or dBASE SE. I only have Access 2003. What is the easiest way of proceeding ...
sir, it like searching function i need to search the table which has data stored in ms access table. i have create a text box for the contract no,username and date and need to search the table according to contract no or username or date. for that i need a coding with solve the problem in single sql command. i have try it with where he...
There's this program written by VBA running in Access. Every time we enter some data on a form and press the next record button on navigation bar data is saved automatically. I would like to know if there's a possibility to change this behavior, for example, to ask the user before saving the data. ...
Hi Every now and then I come across a problem with an old system one of my colleagues has developed. They tend to have thousands of lines of code to do a simple thing like importing a csv file. Currently the vba process is: open excel application create new worksheet populate the csv file into excel add the header names to the f...
It seems that Visual Studio Lightswitch is aimed at the some sort of application that Microsoft Access was aimed at. Therefore am I right to assume that: “Visual Studio Lightswitch” is “Microsoft Access” for the web age ...
hi i try this in access 2007 and its work excellent !!! but in access 2003 it dosent work what can be the problem ? public string Office2003 = @"C:\Program Files\Microsoft Office\Office11\msaccess.exe"; public string Office2007 = @"C:\Program Files\Microsoft Office\Office12\msaccess.exe"; ProcessStartInfo MSAccessInfo = new ProcessSt...
Hi folks, I asked a question regarding joins yesterday. However although that answer my initial question, i'm having more problems. I have a telephony table ID | Date | Grade 1 07/19/2010 Grade 1 2 07/19/2010 Grade 1 3 07/20/2010 Grade 1 4 07/20/2010 Grade 2 5 07/21/2010 Grade 3 I also have a Grade table ID | Name 1 Grade 1 2 Grad...
What odbcconf.exe command line can I use to change the path to the MS Access .mdb file for an already existing System DSN? ...