I have a question relating to Access, which I'm hoping that someone here can help me with. We currently have a large CD library, and a few years ago we had a database created in access which allows us to catalog all of the CD's in the library. Fields include information on artist, track title, publisher, composer etc. We're at a stage now where we'd like to rip all of our CD's, and have a searchable database which allows us to port across all of the existing data from access, but also to locate and audition the tracks themselves. I'm not an access programmer, so please avoid overly technical responses, but does anyone know of any software which would allow us to do this? Essentially we're looking for fully searchable mp3 ripping software with the ability to import data fields from access. Thanks
I have been tasked with converting a spreadsheet to an access database. I work for a growing firm of Tree-Surgeons (no pun intended), who service a sizeable chunk of the power grid in the UK. At any time, we have up to 150 operatives in the field, cutting vegetation around power lines. Because of the obvious danger, the power company need advance warning of where any teams will be cutting on any given day.
Various team leaders call in each day and give their intended locations for the following day to an individual who's responsibility it is to log the info onto a central spreadsheet, an Excel workbook. Each workbook contains a worksheet for each day (Mon-Fri). Each worksheet contains the following fields:
1. Number (Unique Numerical Sequence for the individual) 2. Name 3. Phone Number 4. Working/Not Working 5. Type of Line (132kv, Extra High Voltage (EHV), High Voltage (HV), Low Voltage (LV)) 6. Area (in this case a lookup of 8 geographical areas) 7. SubStn Number (a name of exact location followed by nn/nnn) (LV Only) 8. Circuit and Pole Numbers (a location followed by nn) (HV Only) 9. Locality (nearest village/town) 10. Grid Reference (nn/nnn/nnn) 11. Time On-Site 12. Time Off-Site
So far I have created a table (Called Contact) for the individuals:
Team Members can move between teams, but Team Leaders remain largely static.I guess I should create a separate table for Team Leaders and Team Members, with a one-to-many relationship between them? All of the others could be around the network but would not be attached to a Team Leader, so I guess they can be in the same table as Team Leaders for the purposes of tracking their location.
Also, what is the alternative to using a look-up for some of the fields, for example the Area field? I was concerned about breaking one of the commandments, and cant see a reason why, but I await enlightenment!
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later FROM TESTSTAT WHERE [LOG_NO] LIKE '*' ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later FROM TESTSTAT WHERE [LOG_NO] LIKE '*' ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
I'm trying to get a way to creat a database of my phone messages (SMS). I have them on a .txt file and I would like to create on ACCESS (or other program) the fields "Date:" "From:" "Message:", etc. So, everytime I introduce a day, all sms sended on that day appears, or, when I introduce a Name, every message from that person, appear. Is that possible? Of course that I want to convert it, not introduce one bye one because I have around 2000 messages...
Thank you very much
This is a example of the .txt file I have:
================================================== ========= Message type: SMS From: 0: Maria Date: quinta-feira 03 Maio 2007 15:33 ----------------------------------------------------------- Hum que bom então. Tou com a minha amiga na praça da república. Vais ficar aí? ================================================== ========= ================================================== ========= Message type: SMS From: Figueiredo 0: Maria Date: quinta-feira 03 Maio 2007 14:59 ----------------------------------------------------------- Tas em casa?a mariana foi aí? ================================================== ========= ================================================== ========= Message type: SMS From: Figueiredo 0: Maria Date: quinta-feira 03 Maio 2007 14:52 ----------------------------------------------------------- Já tá? ================================================== ========= ================================================== ========= Message type: SMS From: 0: Maria Date: quinta-feira 03 Maio 2007 12:47 ----------------------------------------------------------- Desce tou no carro em frente ao mc donalds.. ================================================== =========
I have been informed by an off-site program of ours (out of state) that they need to convert an Omniform application to Access.
I did an initial search on the web on Omniform but I really don't know anything about it.
Has anyone every converted an Omniform application to Access? Is this something that can be done in an automated way or would the Access db need to be made from scratch?
Hi, I have a few Access 2003 databases and I need to open them on my computer which has Access 2000 on it. Can anyone please tell me how to convert it so it is compatible? I have looked into "databse utilities" "convert to" etc but can't figure it out.
I am in the process of converting data from an excel sheet into Access 2000. I know the import procedure, however some of the fields in the Excel sheet have multiple data.
Is there a way to sort out this problem, short of cutting and pasting or re-entering the data? For example one field has the following: Mon, Jan 10,2006, 9AM to 11AM. I want to eliminate this field and create a field each for the day, date, start time and end time.
i'm importaing a table through a mysqlserver, it contains a field (call_time) and its a long integer, i suppose it's an unix date format that can be converted
into DD:MM:YYYY HH:MM format, only problem is i cant find a way to do it on access i've tried creating a query with all the fields and adding my one fields with commands such as valdate([call_time]) but it dosen't seem to work.
I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new version of access comes out we will have to recreate the database from scratch because there are lots of problems converting between versions. I'm aware there might be some hiccups but I don't really agree with him. Plus once the database is up and functioning I don't see why we'd even have to upgrade it to a new version. It's just a small health centre patient database with info about patients and their treatments. Does anyone have any opinions about this. Thanks.
Hi, I am converting a database from Access 2002 to Excel 2002 but when converted each value in the spreadsheet has the value ' directly before it. Is there anyway around this problem.
A group in my company has, for quite a while now, used a spreadsheet template to capture information needed for customer hard output. Someone built a page, with the less-than-a-dozen required cells in the appropriate places and a set print area, for printing the information. After they enter the information and print the page, they save the excel file. They have been doing this for quite a while now, and the number of files they have on their shared drive is staggering... and the method they using for naming conventions and cataloging them is almost beyond comprehension.
As they do indeed refer back to these files quite a bit, I am wondering if it possible to import the required cells of information from this mass of excel files, all of which are formatted and laid out the same, to an access table. I have never considered this before and have no idea how to start or whether it is even possible. I did a search on "import" but no results match what I am considering here.
To clarify one thing about these files: The information is not contiguous. It is spread all over... C6, E12, F45, J5, etc. They tried to build the form in excel so that it would print in the format they needed.
I would like like to convert some of my Access 2003 databases to 2007. I am on a stand alone pc running Vista Business and Office 2007.
When I follow the "convert" instructions using either the SAVE AS option (or even the CONVERT), I get this error message which prevents the conversion taking place.
"You attempted to open a database that is already opened exclusively by user 'Admin' on machine <name>. Try again when database is available."
My Vista User Account is one of administrator.
Any help would as always be appreciated. Thank you
I am trying to import certain data from a massive excel workbook into different Access tables but some of the worksheets contain simple formulas such as multiplication and division. I was wondering if it is possible to create these same formulas within Access? If it is possible then what are the necessary steps to create them? Thanks!
We recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.
When converting the Front End of my database to an MDE, Access just hangs and says (Not Responding). I've left it our an hour and there's no sign of stirring.The Back End converts in just a second or so.
I'm trying to convert a matrix within a table (m x n) to a single column. So basically
1 2 3 4 5 6 7 8 9
to
1 2 3 4
5 6 7 8 9
I would do this in excel, but the problem is I have already over 1 million rows, and I'm converting 48 columns into one (too much for excel). Is there a way to do this via a macro or query?
The other catch is that I want to repeat Column A (which has the username) with each row of data, for example
Joe 1 2 3 Sam 4 5 6 Jeff 7 8 9
to
Joe 1 Joe 2 Joe 3 Sam 4 Sam 5 Sam 6 Jeff 7 Jeff 8 Jeff 9
Our Access database is multiple user. The front end is on the local drive and the data file is on our main server. Our database has numerous queries, forms and reports accessed by command buttons or directly. Various queries are set to merge with Word documents.
What are major or annoying problems that have been encountered by converting. Our database is contains our membership information and is crucial to our operation. Detailing problems/solutions if possible would be extremely helpful. Asking for allot but very concerned about conversion. Thanks for any input.
Hi, Can anybody help me ? I've a case where ms access displays oracle's numeric field as text where msaccess is linked to oracle.The possible reason could be when we don't specify precision in declaring the filed in oracle table, default precision is 38 which ms access cannot hold. So, it(driver) converts this to text field.But this is with MSORCL32.dll(microsoft driver for oracle).Is there any other possible reason that will result this behavior?
The following are the configuration details: 1.Oracle 9i on Unix server. 2.MSAccess on Windows XP. MSAccess holds linked data of Oracle server.
I am calculating the check digit for a 13 digit number in Excel and I need to be able to do it in Access.
My Excel formula; =1&E1&MOD(-SUM(MID(1&E1&0,{1,3,5,7,9,11,13;2,4,6,8,10,12,14}, 1)*{3;1}),10) -- cell E1 holds the base 12 digit number. My attempt to convert to Access; =1 & [txtBase] & [-SUM(MID("1" & [txtBase] &0,{1,3,5,7,9,11,13;2,4,6,8,10,12,14},1)*{3;1}) mod 10] -- txtBase holds the base 12 digit number
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated, Sam
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated, Sam
Hello, this is my first post (anywhere ever)!:eek:
While I have lots of Access programming experience over the years I have broken new ground this week and am in unchartered territory and need help please!
In the organization I am working for (as Procurement Manger), we use AMMS (by Microwest) for work order generation and inventory management, etc. I have been able to import into Access the tables of interest from this SQL-based package. The problem is that I need to share the tables (via nice front end forms/queries) with about 20-30 people in the field.
I don't know much about ODBC but the administrator of AMMS was kind enough to give me access to the AMMS database tables via ODBC and I, personally have access to read the table data but none of the other people in the field can access these tables due to security rights.
So, what I have done is I created MS Access tables for each of the 4 AMMS tables of interest and I run code that runs delete and append queries on each table. I then have a separate public db that the field people access with all the queries and forms but only links to the Master db containing the 4 Access tables derived from the ODBC tables. This works ok but there are issues:
1) if any field people are on the Public db, the code to import the ODBC table data loops and does not complete the delete/append cycle on one or more of the tables. I can only refresh the table data when nobody is connected to the db - impractical.:(
2) the ODBC tables are rather large - one is over 38,000 records and it takes several minutes to run the delete/append queries.:mad:
3) When I created the Master db it was some 83MB. After running the delete/append queries it is some 179MB and appears to increase in size every time I run the delete/append code. When I run "compact db" it stops running after a short time. Does nothing but create a new file (db1.mdb) of the same huge size as the Master.:confused:
I suspect the most graceful solution would be to give each user rights to the ODBC tables from AMMS in Access. In this case, I wouldn't have to run delete/append queries and the data would always be in relative real time subject to the refresh timer. Unfortunately, due to AMMS licensing restrictions, this is not doable.
I have tried to search the internet for guidance but no luck. This forum appears to be an excellent opportunity to get expert advice on this particular issue. I thank you for your thoughts and guidance.
