Is it possible to set Access persmissions using Active Directory users? Edit: The overall objective is to allow some users to see certain tables and deny this permission for other users. I'm wondering if it can be done using active directory users. ...
I want to import data from a DB2 database into MS Access via ODBC. The connection is set up and working but decimal values get converted due to some locale issue (German Windows). 234.75 ends up as 23475 in the Access table. I had the same issue with Oracle but was able to fix it by setting the ODBC drive to US locale. How can I do tha...
I'm working with MS Access to do some math. I'm taking a Cost and Dividing it by a decimal value to get a Price. I'm using a link table and a access sql query. SQL Ex Select (cost/markup) As Price From T_Cost; Calulcation Ex. 1234 / .55 = 2243.6363 1000 / .50 = 2000 I'm trying to figure out a way to remove the decimal places that w...
I would like to get all the source code from an Access database (forms, modules) without using Office interops. I liked the AllCodeToDesktop() function found here. However that runs from inside the mdb file. What would a VBScript file be that loads the mdb file and runs that function on it? ...
Using VB6 and MS Access Table: ID Lunch_Intime, Lunch_Outtime 001 13:00:00 14:00:00 002 12:00:00 13:00:00 003 12:00:00 15:00:00 004 14:00:00 16:00:00 So on… Lunch_Intime, Lunch_Outtime column data type is text. I want to get a Total_Lunch_Time for the id. Tried Query: Select Lunch_Intime, Lunch_Outtime, Lunch_Ou...
is there a widget to embed an explorer like view inside an ms access form? i have a folder with the name of the primary key, which holds documents (.doc, .xls) for that dataset (it’s an employees table) currently i have a button which opens an explorer window, but having it embedded would be really nice. any help, link, similar questi...
I'm having a problem with Jet throwing error 3011 when I try to use it to open a file with 2 "extensions" ("filename.tst.csv"). Run-time error '3011' The Microsoft Jet database engine could not find the object 'filename.tst.csv'. Make sure the object exists and that you spell its name and the path name correctly. Where the cod...
I'm getting data as an Access file. My application uses MySQL/Java. I'd like to parse the Access data, and stick it in MySQL. Is there a Java tool that will help me do this? ...
I need help navigating Microsoft Access Reports. I am in the Report Designer, and I need to know the which menu selection will enable me to view the Query that was used in the report. I have never used Access before. ...
Hey guys, can anyone help me with a simple question. I have this SQL statement below in a sub in VB within access from a button click, and I am new to this. Here is what I typed: Private Sub Command0_Click() Dim rs As Recordset Dim sql As String Dim db As Database Set db = CurrentDb sql = "SELECT * FROM Transactions" Set...
I need to work with Access to create a form based solution - does anyone know of any good quickstarts / tutorials aimed at .net programmers for this? Everything I have found is aimed at Access beginners where all I need is a foot up to save time trawling through each control etc. ...
Hi there, im developing a simple access application that helps us to order the right products for a project. i have a table for each contractor containing its products. i have a table "favorite-products" that relates to products and gives additional information how and when they should be used. normally id have a big table (containing ...
I have a textbox on a MS Access form that users are going to copy a column of numbers into from an excel spreadsheet. I need to take this input and use it as parameters to build a query. I have code that looks like this Dim data as variant Dim input as String data = Split(input,vbLf) I want to be able to build a list of the input fr...
I have created an Access file with forms and report and put it in a shared drive with full access rights. But when one user open the Access file, another user can not open the file. He clicks on the file, but no response comes... while I, at the server, am able to open it at anytime. I am stuck. This Project is for all the users, all of ...
Hi, Thanks for help with previous question. SUMMARY: I'm trying to open an access 2000 file in access 2003 but Microsoft Access 9.0 Object Library is missing. any ideas?? BACKGROUND: I recently inherited an access 2000 file containing a number of automated reports. When I try to open I get the following error: Visual Basic for App...
hi, i have multiple tables containing similar records. i want to merge them into one table. therefore i use an update query and map the fields from the various tables to the ones in my target-table. but i need to keep track from which table a record comes, so id like to add a literal "TABLE_XY" in the ORIGINALTABLE field in the resultin...
I have been asked to build a simple database for my church. Those using the database will need to use the form view only, so I am trying to make it very user friendly. The church has 3 bank account (checking, savings, and allocated). The allocated account is my problem. This account holds money for 4 separate missions, fundraisers, youth...
Hey, I need to use an .accdb database, and to do that it needs to be imported into PostgreSQL. I believe this would be a simple and straightforward problem (I expected it had been already solved), but a simple solution escapes me. I'll add that I don't have access to Access (lol), and my solution is loosely dependant on that. If th...
Hello, I am looking to achieve two things: a) To find a free, whether open-source or not, XML database that is simple to use and b) To access an MS Access DB and convert it to the XML database. If this can be done automatically, so much the better :) Otherwise, what would be the easier way to do this? Thanks! ...
When I try to import an SQL Server database into access I am getting this error I am using OS: Windows Vista App: MS Access 2007 DB: MS SQL 2005 Error: Connection failed SQLState; "01000' SQL Server Error: 52 [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] ConnectionOpen (Connect()). Connection failed; SQLState: '08001' SQL Server Err...