ASP.NET, SQL Server, WPF, C#, VB.NET

Hi Guys, 
 
I have recently reinstalled access after a computer crash and I can no 
 
longer import .DBF files that I have been using for years. 
 
I have found that renaming them into the 8.3 format allows me to 
 
import them however, there is critical information in the long file 
 
name that I manipulate through VBA. 
 
Could anyone tell me if there is an addin or update that allows long 
 
filename support i.e. 12.3 
 
I must have had this installed before but I cannot remember doing it. 
  ...

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

Hi, 
 
I need to update my access file which is available through internet 
 
i.e. http. 
 
What are the different ways avaialble for this? 
 
I tried liking that table at my client application which is again a 
 
access by specifing the URL "http:\\localhost\temp\db1.mdb" at Filename 
 
text box, but I am getting error "Not a valid File Name." 
 
Your help is appriciated. 
 
Thanks 
 
Ashwini

I have 2 databases with the same tables.  I need to merge the data from 
 
database 2 into database 1.  I created an append query but I keep getting a 
 
"not enough space on temporary disk" error.  I even limited it down to 3 
 
months worth of data and i still get this error.  if i limit it down anymore 
 
it would take me way too long to append all the data from every table.  Help!

Hi, 
 
I have 3 tables and I populate each by importing 3 spreadsheets.  The 3 
 
spreadsheets are basically set up the same way and on all 3 spreadsheets the 
 
1st row contains column headings.  The spreadsheets are created via VBA by 
 
extracting data from a series of formatted spreadsheets that are submitted 
 
from different divisions (budgeting data) to new spreadsheet files that are 
 
saved/closed and then imported. 
 
For some reason with one of the tables (same table every time) when  ...

I am hoping someone out there can help me.  I importing excel spreadsheets 
 
into an access database.  The excel files will be updated monthly so I am 
 
linking them.  However, when I do link them, for some reason the data type 
 
changes and I get mismatch errors when I run queries.  I know for a fact that 
 
before I link the sheets, I change the cell format in excel to text.  But 
 
once I get it to access it is in Number format.  I have tried changing the 
 
format in excel after the file  ...

Hi, 
 
I seem to have fallen over at the first hurdle and need your help: 
 
I receive an email first thing every morning with a data link in it 
 
like this: 
 
https://esales3.nj.ssmb.com/esalesauth/ReportAccess.smvc?Resource=/ftp_p 
 
ub/FsaRep4_20060815.xls 
 
when you click it, it requires a user name and password before opening 
 
as a excel spreadsheet. 
 
wondered if you knew of a way of importing it into MS Access2000 ? 
 
Plus the name of the link changes on a daily bases as it has a t ...

I have a dbase 5 file that contains 46,873 records. When I import the file, 
 
all 46,873 records show up but when I link to the file I only get 730 
 
records. Importing this file takes a very long time so I'd perfer to link to 
 
it instead.

I just ran into this exact problem.  I was trying to connect to a 
 
secured database.  I got past it.  The steps that I used follow. 
 
Edit the datasource (Start==>Administrative Tools==>Data Sources). 
 
Choose the tab for the correct DNS type (User, System or File). 
 
Select your connection from the list. 
 
Click on Configure. 
 
Click on Select and type in the path to the .mdb file. 
 
Select Advanced. 
 
Type in your username and password that you use to access the secured 
 
access data ...

does anyone know how to import the data and set up a contact list

I use an ADO connection to add new records to a SQL Server database. After a 
 
new record is added iit is supposed to be the current record. Yet, I cannot 
 
seem to retrieve the primary key (autogenerated) for the record. I just get a 
 
zero. The added data goes in and can be queried and viewed. Here is a code 
 
snippet: 
 
Dim cnSQL As ADODB.Connection   ' SQL server 
 
Dim rsTR As ADODB.Recordset     ' SQL table 
 
Set cnSQL = New ADODB.Connection 
 
Set rsTR = New ADODB.Recordset  ' trans ...

Successfully imported contacts from my office computer (which is connected to 
 
a LAN) to a new home computer, but the record of emails and notes, etc. under 
 
"activities" did not import. Using MS office 2003 & Outlook 2003 & Windows XP 
 
on both computers.

I am desinging a data entry form which enters some data in table "quote". 
 
There are 3 tables in my database 
 
Products, Customers, Quotes 
 
Structure of Quotes Table. 
 
QuoteId (Autonumber) 
 
CustName(Text) 
 
PartNo  (Lookup) 
 
Description (Text) 
 
Price (Number) 
 
At first I have to enter Customer Name and then PartNo which is a lookup 
 
field from products table. 
 
CustName is either present in customers table or a new entry. My concern is 
 
whenever a new customer is entered in  ...

I have recently purchased a new computer that came with access 2003 
 
pre-installed and am trying to move an access 2003 dbase containing linked 
 
tables to it from my old computer. I have set up an odbc connection on the 
 
new computer just as it was on the old and i still keep getting"jet database 
 
engine cannot find...." errors. Any suggestions as to what I may have missed 
 
???? 
 
Thanx in advance for any help. 
 
Thanx, 
 
Klutzz

we are not able to access our mdw file.  it says:  Not a valid account or 
 
password.  I guess the password was changed somehow.  How do we hack into 
 
our mdw file and find out our password? 
 
please please help 
 
thanks

Hello all 
 
I am trying to design a software in MS Access for my own use regarding 
 
Customers, Orders & payments. I need a sample file to refine my knowledge. If 
 
anyone can direct me I will be grateful. 
 
Best regards, 
 
isons 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200608/1

Access 2003:  Problem:  I cannot append to a linked Excel spreadsheet.  From 
 
what I've read in the posts, that's because there's no primary key.  The link 
 
wizard did not prompt me for a primary key, so I suspect the answer lies in 
 
creating a "local index".  How do I do that?  (Or any other suggestions you 
 
may have.) 
 
Thanks, 
 
Dorci

While in Excel I have changed my 10 digit account numbers into text format, 
 
and then I import them into Access.  Frequently, these numbers do not convert 
 
correctly.  They get converted into scientific notation and the trailing 
 
numbers are lost.  While converting Excel into Access, is there some way to 
 
keep all the digits intact?

I working on a project that uses single cell data for access to fill out 
 
single cells in Excel. Everytime I try and and add the "GET EXTERNAL DATA" to 
 
my Excel Template it wants to add the whole query rather then just single 
 
cell information. 
 
For example:   I have a job number and I want all the information for that 
 
job number to update my Excel Template Fields  such as PO Number, Customer, 
 
Deleviery Date? 
 
Does anyone have some input that they can give?

I'm trying to link a table from a sql server database into Access 2000 but 
 
the table list only pulls back a few tables. 
 
I have select permission to the record.

Hi all, 
 
I was hoping one of you may be able to assist me,  First off I am using MS 
 
Access2000:  I need to import a web link into access but have had no luck so 
 
far is it possible? 
 
Thanks 
 
Dave

I am new to Access 2003. I have two tables with identical fields. What is the 
 
easiest way to copy or merge the records from one table into the other. I 
 
tried "cut & paste" but that didn't work.

I am using Access 2003 and exporting several tables to separate spreadsheets. 
 
Some cells are empty and these cells display no borders.  A macro pastes 
 
each spreadsheet into a section of a report so I don't want to have to format 
 
each spreadsheet each time.  How can I have all the cells maintain the border 
 
even when there is no data in them?

The formula bar has disappeared from my Excel page, even for new sheets. 
 
It's not in toolbars. 
 
Any ideas?

We are trying to link AutoDesk Architectural 2006 to an Access mdb table. 
 
When we view the data in the database the information is in the correct sort 
 
order but when the drawing opens it seems to randomise the data.  Is there 
 
any way in which we can identify the system ID of the field and link to that 
 
so that the link is set more firmly?  Any ideas and help would be 
 
appreciated.