Identity_Insert won't turn off
Tue, 23 Sep 2008 13:22:01 -0700
I'm attempting to append data from an Access table to an SQL 2005 linked
table in Access (ODBC) that has an identity field. So I found that you can
run the following command in SQL Server Management Studio Express (SMSE) to
allow inserts to tables with an identity column:
SET IDENTITY_INSERT [dbo].[TableNa ...
|
Dumping Data into an Access Form using Datasheet view
Tue, 23 Sep 2008 12:09:01 -0700
Hi-
I created an Access form w/ certain fields that have dropdown picklists &
selected "Limit to List" option to Yes for these fields. When i perform
basic data entry & i try to add something not in the list, it doesnt allow me
to add it (which is what i want). But when i go to datasheet view or the
table ...
|
Linking Excel to Access via 'New Database Query' on a shared network
Tue, 23 Sep 2008 09:48:46 -0700 (PDT)
I'm linking Excel to an Access Database on a shared drive. I can
open
the excel spreadsheet and update external data without problem. What
appears to be happening to others, is they are using differenent
drive
letters to map to the same network location.
Linking through MS Query, my SQL is as follows:
...
|
Cartier Santos 100 Extra Large Steel Mens Watch W200737G
Mon, 22 Sep 2008 23:18:51 -0700 (PDT)
Cartier Santos 100 Extra Large Steel Mens Watch W200737G
Discount Watches Site : http://www.watchespurchase.com/
Cartier Santos 100 Extra Large Steel Mens Watch W200737G Link :
http://www.watchespurchase.com/Cartier-W200737G.html
Cartier Santos 100 Extra Large Steel Mens Watch W200737G
Information :
Bran ...
|
Cartier Santos 100 Diamond 18kt Rose Gold Burgundy Ladies Watch
WM502151
Mon, 22 Sep 2008 23:18:33 -0700 (PDT)
Cartier Santos 100 Diamond 18kt Rose Gold Burgundy Ladies Watch
WM502151
Discount Watches Site : http://www.watchespurchase.com/
Cartier Santos 100 Diamond 18kt Rose Gold Burgundy Ladies Watch
WM502151 Link :
http://www.watchespurchase.com/Cartier-Santos-100-Ladies-Watch-WM502151.html
Cartier Santos 100 Di ...
|
toll bars
Mon, 22 Sep 2008 17:51:01 -0700
In saving a 2000 db in Access 2007 the custom menu/tool bar was not created.
How can I import the toob/menu bar into Access 2007 from an older version.
Access 2000
sandrao ...
|
Adding tables to a split database
Mon, 22 Sep 2008 13:19:05 -0700
I split a database and now want to add a new table to the BE that is linked
to the FE. Could someone tell me how that is done? Thanks! ...
|
|
|
Table linking problems - Access 2002
Mon, 22 Sep 2008 09:13:01 -0700
I'm still using Access 2002. I have a front end database that is linked to
back end on our department server, Novell network. I recently added a new
table, and now when I try to change the link to the tables Access just
returns me to the finder dialog and won't change the link if I have all the
tables sele ...
|
Converting Publisher2007 Web Site to Front Page...
Mon, 22 Sep 2008 08:17:01 -0700
Please tell me there is an easier way for an html-challenged Website Owner to
convert a Publisher 2007 Site to Front Page, OR any other more involved Web
Design Software...without HARMING SOMEONE IN THE PROCESS? ...
|
transfertext starting from a certain row
Mon, 22 Sep 2008 07:10:01 -0700
Hi,
I am transfering data from a csv file into access database. The top 4 rows
are explainatory texts and should be ignored. Does transfertext function
allow me set the start row somewhere?
Thanks.
Lydia
--
Access/VB Programmer
...
|
