| Thread | Last Post | Replies |
|
| Linked Tables Locking Up | 30 Apr 2007 22:40 GMT | 6 |
I have a relatively small split database (<50,000 records). The users who are located out of state and use VPN to access the server database have client databases with data entry and inquiry forms that use linked tables. I have an inquiry form with a query as a record source. ...
|
| To sync date from my desktop Outlook to my laptop Outlook | 30 Apr 2007 20:41 GMT | 1 |
I set up my Outlook in my laptop. the problem.. it ate up all of my inbox & set info. Luckly I have them still at my desktop Outlook . Questions: How can I transfer the messages from my desktop Outlook to my Laptop Outlook.
|
| Export & Import Tables | 30 Apr 2007 20:40 GMT | 3 |
I have a simple three table DB which will be given to three offshore locations. They will use the DB and then need to export the information from their side to me so i can consolidate thier data into my copy here. The DB has the same structure,table names etc and all i need is ...
|
| transferdatabase | 30 Apr 2007 01:16 GMT | 2 |
I am using MS Access 2003. When using transferdatabase function to export tables in an access database to Oracle. I get an error message sayin "type mismatch". The code I type in as follows: DoCmd.TransferDatabase "acExport", "ODBC Datababe", "ODBC;DSN=fdr1;
|
| Connect Access to MS-Small business accounting - need further help | 30 Apr 2007 00:22 GMT | 4 |
http://office.microsoft.com/en-us/help/HP011737241033.aspx -- The above link is a direct quote from the help section on linking MS-SBA to Access. I understand how to do the ODBC thing, but I am lost on how to recognize the data source (which I assume is a data file from MS-SBA.) ...
|
| Problem with a linked database | 28 Apr 2007 08:09 GMT | 3 |
Recently, I got a call from one of the offices I support and they told me that they had gotten a message on screen saying that the database their application was linked to could not be found. On further investigation I found that when I logged into the front end application I ...
|
| Import Query to Excel with Query Parameters | 27 Apr 2007 22:32 GMT | 2 |
Hi. I would like to import some data from Access into Excel, but limit the data by date. When I import the query without the date limitation it works, but when I adjust the query to limit by date (by putting =[Enter Date] in the criteria field in my Access Query) I get the ...
|
| Using XML Database w/ Access Database | 27 Apr 2007 21:26 GMT | 1 |
I have 6 general sections of a group of forms. For ease of example, Section A, B, C, D, E, & F. Section A, E, & F are pretty fixed in their table fields. However, sections B, C, & D vary drastically on each paper form. The purpose of the database is to input paper form data into ...
|
| Memo field in Access 2003 is truncating the data | 27 Apr 2007 16:51 GMT | 1 |
I am importing data from Excel into Access and it is truncating the comments field which we have set up in a Memo field. How do I rectify this problem?
|
| import data from FoxPro database (ISIS) | 27 Apr 2007 16:37 GMT | 4 |
I work for a non-profit wildcat sanctuary. In the past they used a program called ARKs to track their animal records. ARKs is a the front end for an ISIS database- which is a zoo-industry standard. Our facility backed up this database in 2001, and it hasn't been touched since. ...
|
| Import Excel Data from Ranges on a Worksheet | 27 Apr 2007 13:50 GMT | 3 |
Hi, please help... I am trying to import data from a series of ranges on a worksheet and import to tables in my database. This code below will import the whole worksheet into a table but thats not any good, I need to import a range (I have named
|
| Text files | 27 Apr 2007 05:43 GMT | 1 |
I want to find a way to put a delimiter in place of the first space in a line of text which i can use to separate email address from a name I get a list of names like the following brown1@someplace.com John M. Citzen Jr.
|
| How Do I copy an Existing Import Spec to New DataBase | 26 Apr 2007 23:50 GMT | 1 |
I have some import specs from another database that I would like to use in other new data bases -- How do I copy them into New Databases without recreating them? Thanks.
|
| Importing Text file Issue | 26 Apr 2007 22:42 GMT | 10 |
Sorry to post this seemingly common problem. I've read and read and tried various things but still need help. I have an Access 2003 database. I am need to import multiple comma delimited texts. I can do this very easily with TransferText.
|
| Import Text with prn extentions | 26 Apr 2007 20:27 GMT | 3 |
i am trying to build a database,but all the files have the .prn extension. Is there a way I can import these files through Access? There isnt an option to choose this type of file when I try to import the data. I added prn to the HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4 ...
|