|
Import or Link Tables?
My database is in a MS SQL Server which I want to update when I update
anything in the *.mdb...Would I want to import these tables or link these
tables? Thanks for the help!...
|
2 |
26.09.2006 15:13:44 |
|
|
Incorrect field type linking Oracle table in ACCESS 2003?
I am linking an Oracle table using ACCESS 2003. 9 of the 10 fields display
correctly when I open the table. However, the 10th field, which is date-time
in Oracle, displays as "OLE Object" in ACCESS. I know I cannot change the
field data type in ACCESS because it's only linked to the table.
How do I correct this?...
|
1 |
25.09.2006 21:43:02 |
|
|
storing path only to database...please help me...
helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all th...
|
3 |
25.09.2006 08:59:41 |
|
|
Unable to open Excel 2007 files after export from Access 2007
Office 2007 beta 2 including the technical refresh is installed on Windows XP
SP2.
I exported several (linked) Access tables to Excel without opening them
directly.
I can open them just after the export. But a day later they cannot be
opened. The read only message is shown and after that a message is shown that
they are created with beta 2 and only can be opened with beta 2.
Is this beh...
|
1 |
24.09.2006 13:08:01 |
|
|
=A7_character_as_a_field_delimiter
Hope someone can enlighten me, I am trying to use the '§' as a field
delimiter but the driver throws an error (.. 'the Format option is
invalid....') which I assume means it doesnt like that character as the
delimiter.
Is there a way of getting this to work or am i stuffed!?!?!?!?
I find this rather annoying since the documentation specifies that
*any* character may be used [except a dou...
|
9 |
24.09.2006 01:44:23 |
|
|
access 2003
how do i design an access database table for compiling all the laws to help
prepare me for taking a bar examination?...
|
1 |
23.09.2006 23:01:02 |
|
|
can't link ODBC tables in Access 2003
I tried this on several computers, but it doesn't seem to work. As soon as I
select "ODBC Databases()" the dialog simply disapears.
It seems to work fine on older versions of Access.
Is this a bug in Access 2003?
Thanks
Tav...
|
5 |
23.09.2006 20:41:01 |
|
|
Change data from link tables
Hello all
I have linked an excel spreedshet to Access. Everything works fine but
my question is:
Is there a way to change the data from Access? or its read only?
I want to be able to change my excel data from a form in Access, is
this possible?
Thanks
...
|
6 |
23.09.2006 05:52:22 |
|
|
updating multiple databases
My problem is that I have 3 copies of the same databse running on three
computers that cannot be networked, and each has autonumber for forms like
Invoice, quotes etc. I need to collate the information monthly from the three
computers to my computer, but the forms overide each other.(ie three invoice
number 1, three number 2 etc) Is there a way I can collate the data? Thanks....
|
3 |
23.09.2006 03:04:01 |
|
|
TransferSpreadsheet
Hello,
I have queries that I'd like the user to be able to export to Excel. I set
them up with DoCmd.OutputTo and this works as desired, except for the fact
that it limits the number of rows (saved as older version). I understand the
solution is to use TransferSpreadsheet, but would like to retain the ability
for the user to select the directory where the file is saved to & change
filen...
|
3 |
22.09.2006 20:53:16 |
|
|
connect dns less..?
Hi all,
I would like to connect to a SQL-server and promt the user with password and
username.
Can I use something like?:
Dim oConn As Object
Set oConn=??
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};" & _
"Server=MyServer;" & _
"DataBase=MyDb"
End Sub
.... what do I have to do?
/Kent J.
...
|
6 |
22.09.2006 20:49:44 |
|
|
Database on Server and Laptops
I want to create a single access database on the server; then "copy" that
database to several laptops; have the laptops users disconnect from the
server and to out into the community and gather information that they enter
into the 'copy' of the database on their laptops; return and connect to the
server; and then 'update' the server database with their information (and
keep everything in...
|
2 |
22.09.2006 20:17:48 |
|
|
Defining criteria for transfertext
Is there any way to define fairly generic criteria for transfer text method
in vba?
ie to say use tabs to delimit, use field names etc without using a
table-specific spec-file
Thanks...
|
2 |
22.09.2006 15:50:02 |
|
|
Linked Table Field Types
I've looked everyone and need someones help please. I have a linked table
which is from a Lotus Notes .nsf database. When I link it into Access it jus
doesn't quite get all of the field types correct and I don't know how to fix
it - Is there a way in ADO through VBA to just select the info I want into a
recordset so I can parse it from there into a local table?
What happens is I the...
|
1 |
22.09.2006 15:30:02 |
|
|
Convert .mdb files to .cdb files
I am trying to convert an .mdb file (Acess 2003) using Microsoft Active Sync
to a .cdb file for use on a Pocket PC device. Ever effort to do so ends up
in an error message "Conversion failed, acess is denied" The program I am
trying to use in called DB Anywhere by Tiny Pockets recently purchased from
PocketGear.com and also purchased from Handango (older version). ...
|
2 |
22.09.2006 14:42:59 |
|
|
TransferText
im using the folowing code in an Access 2003 database
DoCmd.TransferText acImportDelim, , "DCS_DATA_Specification",
"T:\DCS_Data\viewer\DCS_DATA_Easington.txt", False
the code works fine but when the code executes it creates a new record in
the table. how do i get it to over write the existing table so only one
record only ever exists...
|
2 |
22.09.2006 13:25:17 |
|
|
Cannot execute data definition statements on linked data sources - A2003
Hello --
I want to maintain my backend mdb using code in my frontend.
example:
DROP and ADD constraints
CREATE TABLE
I receive error 3611 - Cannot execute data definition statements on linked
data sources
Is this not a recommended way to do things?
Can anyone recommend how to perform this kind of maintenance?
My coding skills are beginner-intermediate; I would appreciate an e...
|
5 |
22.09.2006 04:50:15 |
|
|
Exporting to Excel from Access using SaveAs
I currently have a module that exports data to a pre created/formatted
Excel template. Every time a user runs this module certian cells are
filled (data is based on a parameter they pick off of a form). This
data is run for a whole year every time, so I want the data put into
the blank template every time, and I want the template to have default
valuse of 0 (the problem is that it will have...
|
3 |
21.09.2006 20:46:17 |
|
|
HELP!!! Please!! Problem with exporting!
Hello there all you geniuses....please help a man in need :-)
I am very new to VBA and i have a big task in hand...
Here is my problem:
I am trying to export graphs made in MS Graph 2000 and embedded in a
subfrom in an MS Access form.
I use this code on my export button:
Private Sub Command12_Click()
Dim graphExport As Object
Dim vendor As String
vendor = cmbVendor.Value...
|
1 |
21.09.2006 20:10:28 |
|
|
Linking Outlook 2003 to Access 2003 Task Info Missing
When I link my tasks to access I cannot see the subject, or the notes
or the start/end date column data. I CAN see the columns but not the
data. IF I export it I get the data. We do not have our own exchange
server but my email is configured for the servers that are hosted
remotely. Not sure if that makes a difference.
I see the tasks and all the data in outlook
I can export it to acce...
|
1 |
21.09.2006 18:17:13 |
|
|
Visual FoxPro connection to remote server
Hi,
I don't know if this is the correct group to post this.
I have the following enviroment :-
Server A - Windows 2000 Server SP4 - Running Business Objects
Enterprise 11
Server B - Windows 2000 Server SP4 - File server holding Visual Foxpro
data.
I have created an ODBC connection from the Business objects server to
the foxpro files on the file server. If I run a crystal report us...
|
1 |
21.09.2006 18:13:20 |
|
|
How do i export graphs in Access to excel using VBA code?
Hi,
I want to export a couple of graphs to a single excel file. The graphs are
made in Microsoft Graphs 2000. Can this be done using VBA code. If yes, can
you explian how?
Appreciate your help!...
|
4 |
21.09.2006 18:00:16 |
|
|
How do I update database online automatically?
I want to store the database for Stock Exchange.
Where can I get this database?
And how can I keep the track of daily updates?
Is there anything like automatic database update?...
|
1 |
21.09.2006 08:35:01 |
|
|
How do I import Times such as 23:47:43.56 in Access 2003?
I have numerous (hundreds of thousands) of records in Excel that include a
Time field that includes hundreths of seconds. I cannot get it to import into
Access unless I strip off the hundreths part, which I would like to keep, if
possible. I see nothing in my manuals on how to do this....
|
3 |
21.09.2006 05:57:48 |
|
|
Get External Data
After reading here, I went to file, Access 2002, but could not see Get
External Data.
So I need help on what to do. I wish to export a record ot a text file,
then hopefully there is a way to ftp the file to a ftp server.
but the export to the file is first step....
|
4 |
21.09.2006 01:10:02 |