Hello,
Is it possible to connect to a text file via ODBC with an Access database. I have tried with a pass thrrough query but I get an error stating you can not use ODBC to link to an external Microsoft Jet or ISAM database table. I know I could import the file but this would put my database way over the 2 gig limit.
I have a form that has a 3 column: ID, first name and last name.
And I also have a table that have a same column (ID, first name and last name).
I want that when i write the ID, access fill the first name and last name fields in a right data - the first and last names of ID entry
Example:
if my table like that:
ID
last name
first name
13456
Elen
Miki
When I write in form in ID text box: 123456, in last name field appear Elen and in first name appear Miki.
I haven't used access before and have been set the task to create a data of photos. The table is called 'Find a Photo' and contains 6 catergories of various information including river, site and date. I would like to create a search/command button by which i can type the river, site and date into seperate text boxes and search all of them at the same time.I don't know how to connect a command button to command button and not sure if any macros/queries are needed. Hope all this aint to hard to do.
View 1 Replies View Relatedhello,
I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).
I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?
Tokunbo
hello everyone, i really need some detailed help as the deadline is approaching and I need to find a solution for this. Any help would be greatly appreciated
I currently have a batch file that ftps a text file from a Red Hat Linux Server to my W2k C:. I would like to make another command in the batch file that imports this text file into an existing access table. I would like the text file to repopulate the table everytime it is imported. I do not want the data added on to the existing data in the table.
Thank you for your time and insight.!!!:)
I need to open and process the data from a text file on the network.
The first 7 characters of the file name will be the same every day.
The rest of the file name will change from day to day.
There will only be one file in the folder that has those first 7 characters.
There are a total of about 120 text files in the folder every day - give or take - including the one I need to open and read.
I have some vba where I'm importing a text file and splitting it out into a table. For the most part its working just fine.
But I have a line of data that I need to pull out the string right after "Old" - Murphy and right after "New" ZMurphy
Acc# : 111111 This is test data, Person : 22222 Old Murphy New ZMurphy
I'm thinking Instr() could do this but I'm unable to get it to work.
I am using Access 2010...
I'm trying to figure out at what point an error message occurs while a database is closing. This problem only occurs if someone clicks on the red close button on the top right of the screen when there are several forms open. If the user exists normally there is NO problem.
I am attempting to use the print statement to write to a text file to track what is happening as the database shuts down. Unfortunately, the open (print) statement, when issued, zaps any prior contents which precludes having a full printed record. I am hoping for a print syntax that would allow appending.
Code:
Open "ErrorReport.txt" for Output as #1
Appended text to the file to show what is happening in that event.
Close #1
The program, in closing, does stop with an error message that a certain file can't be found. But when I click on debug, the program simply closes. I have also commented out VBA references to the file that can't be found, but the error still persists .
Hi all,
I have a text source file and inpul layout i.e. field names start and end positions in excel file. I want create a table in access from the text data using excel file layout.
Can you please help me out in this. I am a mainframe programer and recieved an request to work in access.
I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
View 1 Replies View RelatedI am not sure if this is possible or not, I am trying to export a large table that includes a text qualifier "". I have managed to change all the fields in the table to text. the problem id that I need to supply the data to an outside source that wants the qualifier to also be included for null fields (they receive other files not processed from Access with this included).
I was just after info about if it is possible or I am wasting time trying to come up with a solution (this will be done on a regular basis so I don't want to have to export the table to another software package to perform the task.
Thank you for any assistance.............
what options do i have to connect to my database if back end of my db is in newyork and front end is in washington. how do i connect to my db??
View 1 Replies View RelatedHello my helpfull friends,
I am going to build a multi-user database with the tables en queries stored on a server. So I will deploy multiple front ends.
Here is my question:
What is the best way to connect to the BE?
Should I link the backend using the linkingmanager (bound to a recordset) of access 2007
OR
should I interact with the data in the backend using undbound form using a disconnected recordset
OR using SQL
I would prefer the first option because it's the easiest way.
But what do you guys (and girls) recommend?
I tried referencing a table in my Access DB that held my login id and password info but it didn't work. How can I make it work?
ODBC;DSN=DB2Q;UID=[Table].[UserID];PWD=[Table].[Password];MODE=SHARE;DBALIAS=DB2Q;DISABLEKEYSETCURSOR=1;DIS ABLEUNICODE=1;IGNOREWARNINGS=1;
Hi all,
I'm designing a db in which I have a list of teacher names, and for each record (each teacher), there is a list of subject that this teacher teaches.
what i did is the following:
I have designed a form with teacher name, and a form for subjects.
I have added a button in the teacher form, next to each teacher name, this button we take the user to the subjects form to add the subjects for this particular teacher.
To link these to form, I have added the primary key of the teacher table (TeacherID) in the subjects table, so the relationship is one-to-many.
but I couldn't get to connect them.
I want the subject form to get the TeacherID from the teacher form to connect each teacher with his subjects. How can I do that?
Any help will be very much appreciated.
Best Regards,
CS.
Hi
I use an application called FIZZ which is a Sensory Analysis program (works with statistics etc.). This application uses files with the extension *.DB and I was wondering if it is possible to connect access to this kind of file? These file are basically tables...
Thanx for the help
Hi All,
I am new to ASP, so bare with me. I am trying to connect to a database with ASP thats on an online server. I am recieving the following error:
Code:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x1018 DBC 0x99aa314 Jet'. database/test.asp, line 15
Here is my file name "test.asp"
Code:<html><head><title>My First ASP Page</title></head><body bgcolor="white" text="black"><% 'Dimension variablesDim adoCon 'Holds the Database Connection ObjectDim rsGuestbook 'Holds the recordset for the records in the databaseDim strSQL 'Holds the SQL query to query the database 'Create an ADO connection objectSet adoCon = Server.CreateObject("ADODB.Connection") 'Set an active connection to the Connection object using a DSN-less connectionadoCon.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath( "/database/atosdba.mdb" ) & ";" 'Create an ADO recordset objectSet rsGuestbook = Server.CreateObject("ADODB.Recordset")'Initialise the strSQL variable with an SQL statement to query the databasestrSQL = "SELECT Elements_list.Sys_id, Elements_list.Element_Name FROM Elements_list; "'Open the recordset with the SQL query rsGuestbook.Open strSQL, adoCon'Loop through the recordsetDo While not rsGuestbook.EOF 'Write the HTML to display the current record in the recordset Response.Write ("<br>") Response.Write (rsGuestbook("Elements_list.Sys_id")) Response.Write ("<br>") Response.Write (rsGuestbook("Elements_list.Element_Name")) Response.Write ("<br>") 'Move to the next record in the recordset rsGuestbook.MoveNextLoop'Reset server objectsrsGuestbook.CloseSet rsGuestbook = NothingSet adoCon = Nothing%>
As i said, I am new and might be missing something simple.
Thanks for the help.
Bones
Hi All,
I've been working on many other domains but very new to Access world. Anyway,coming to the point.I have a database built on Access and the reporting is being done on Excel.Till now,there is no connection between both.Users are doing copy/paste procedure for reporting in excel.i tried to connect both and get the data directly in to excel with out copy/paste procedure(i.e., just by refreshing the excel sheet would do). But when i create an ODBC connection between them, it says that the required permissions are not given to you by the administrator.I'm trying to create a file DSN.so,can anyone tell me what exactly i need for this?is it the admin rights of access database (or) the admin rights of the folder where the mdb file is located?little confused on this.I already have the admin rights on the folder where the mdb file is located but still getting the error.admin rights of the datasbe cannot be given because no one knows the password of administrator ID of Access database(little funny but it is the fact!)
can anyone please let me know how can i get through this problem as this would be the crucial thing for this project.
Regards,
Ravindra
We are struggling with the following thing. We already tried to explain it in this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=111533) but we still don't get it :(.
We have a table, named "Tblapa".
This table contains: ID, UK, Area, Tf, Tt and Number
We have made a query, named "Qrychoosearea"
This query gets his input from the "Tblapa"
(and thus, the query results in: Area, UK, Tf, Tt and Number)
Now we would like to make a form, named "FrmArea" with a combobox.
This combobox lets people choose an Area of their interest out of the list of given Areas. Then they have the press an "OK" button
Upon clicking on the "OK" box we want to generate a REPORT based only on that specific Area (and the related UK, Tf, Tt and Number ofcourse) and thus not showing all Areas.
How do we have to do that?
As we are just beginners in Access and have no feeling for VBA (yet), a detailed explanation or a link to a website who explains how to do this (with images or so) would be much appreciated.
Greetz,
Math
I was wondering if it would be possible to type in a description eg.(Days, nights, O.T.,ect.) and have excell automatically insert the rate I specify into another cell.
View 1 Replies View RelatedHi
I'm new to ASP and I need to connect my webpages to an Access database I have created. I would do this in dreamweaver normally but I'm having trouble using the custom connection string function to do this. So I was hoping someone could explain how I would do this by coding it instead.
The code my web host provide to connect to a database is below. If someone could explain to me how I would use this to connect to a database, I would be very grateful. Thanks.
Quote: Dim oConn, sConnection
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:sitesSingle??UserNamedatabasedata.md b;" & _
"Persist Security Info=False"
oConn.Open(sConnection)
oConn.Close
Set oConn = nothing
I am trying to connect to an access database format 2003 from my access 2007 database. I would like to create a recordset from a table in the 2003 database and bind it to a listbox in my 2007 database.I tried to the following code that didn't work.
Code:
Dim DNHConn As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim connStr, xSource, xSys, xUsr, xPsw
On Error GoTo errH
[code]....
When I try to execute that code, I get an error that the apllication can't start because the worgroup file is either missing or opened exclusive by another user.
Access 2007, split database, 9 users. I have been able to link the BE tables with the Linked Table Manager. I use the DNS name path because everyone has different drive mappings. I can open my linked tables as a RecordSet and AddNew and Update records. However, I cannot Seek and Edit the linked tables. I understand that I need to open the BE tables directly in order to do this. Now, I can do a connection like this, and it works for me:
Dim dbs As DAO.Database
Set dbs = DBEngine.OpenDatabase("R:DataTask_be.accdb")
But, as I said, everyone has different drive mappings. Therefore, I need to use the Network address instead of a drive letter. I tried this:
Set dbs = DBEngine.OpenDatabase("ServerMyBackEndDataTas k_be.accdb").
We have received a zip file from a new client containing several thousand loans. The problem is that when I open the file as text all of the data is in one "field" meaning instead of going across the data goes down.
loan type,
loan number,
origination date,
loan term,
lo type,
etc....
Then it starts over with the next loan. There are over 17,000 lines.
How can I import the text file and have the loans go across. Even when I have imported the file using comma delimited it still imports them going down. Even if the comma delimited would work, I would still have issues because Access would not know when the new loan began to move it to the next row.
Any thoughts or suggestions? Sorry for my rambling.
Hi all! I'm not sure if this is the correct area to post this in, but hopefully it is!
I have a Microsoft Access database, and I need to output the content of one of the tables in a specific format-the table contains a Name field, a Description field, a URL field and an Alt Text field, and I need it to end up in a text file in this format:
NAME|DESCRIPTION|URL|ALT|
Where each line of the text field is a different product, and the content of each field is separated by the | symbol (whose name escapes me right now).
Anyone that can help?
Kevin
Hey,
I have a text file i wish to link up to one of my tables. The problem is that even if i try to import data from that file i get "Text file specifikation field separator matches decimal separator or text delimiter." message and after that one an err that the file cant be imported. Does anyone know why?
Thats the sample of my file:
'PV','045.302','KROG VEN S PNEU POG','JOHN-VALVE + AIR TORQUE','JV-9301NC-BW + AT051DA','','','','15','8','VANI','','1.4408','PTF E','ZRK'