Relationships gone after upsizing
Thu, 25 May 2006 13:20:02 -0700
I just upsized my Access 2003 mdb to use SQL linked server tables. Most
things are working fine, with some minor code adjustments. I did notice
however that all my relationships are gone. Do I need to re-establish them?
Or is not necessary anymore? ...
|
Upsizing Access to Sql
Tue, 23 May 2006 09:01:02 -0700
I have just attempted to upsize an Access database (for the first time) to
connect to a sql backend. I followed the instructions from the white paper
"How to Migrate from Access to SQL Server 2000". I am in the process of
converting the code from DAO to ADO.
I keep getting the same error as mentioned in ...
|
Earn up to 1000 $ per month only for reading your Mails!!!!!!!!
Tue, 23 May 2006 16:17:29 +0200
...
|
Calling Oracle's SYS_GUID() from MS-Access
22 May 2006 04:36:21 -0700
Hello,
I'm using the return-values of Oracle's SYS-GUID()-function as
primary-keys of my tables.
But now, I have to build an MS-Access-Application, to allow users to
insert datasets.
Of course, there is no such function as "SYS_GUID()" in MS-Access...
Because of this, I created a Pass-Through-Query, usin ...
|
Sharing an ODBC connection
Thu, 18 May 2006 14:09:02 -0700
My organization is trying to limit ODBC connections attaching to the main DB
from satellite sites to 1 per site. They are proposing that users (about 30)
needing to query the DB use terminal services on a server with the
appropriate ODBC driver installed and do their queries.
Is there a way to:
1. "share ...
|
Comminications link failure (ODBC)
18 May 2006 07:25:03 -0700
Hello
We are using Access 2003 (SP2) to access a remote SQL 2000 database,
linking the tables with ODBC with MDAC 2.8.
This is an intermittent problem and it occurs on all the clients
(mostly winXP Pro)
The problem is that from time to time, the ODBC connection fails and we
get one of several errors: ...
|
Query to MS SQL Server 2000??
Mon, 15 May 2006 13:01:19 -0500
Hi,
I'm trying to use Acccess to get data fom MS SQL Server. I linked a table
and made a query, but the data appears as "DELETE" every where. I tried a
pass through query to the same table and it seems to work OK????
Can the SQL and Where be set with VBA for a pass through query?? Any
examples??
Tha ...
|
|
|
What's wrong?
Sun, 14 May 2006 23:27:36 +0200
http://s3.bitefight.pl/c.php?uid=45955
here's the screenshoot
...
|
MSAccess and DSN-less connections
9 May 2006 06:09:38 -0700
Access 2000 linking to SQL Server 2000 (soon to be 2005). There's a
great article here http://www.accessmvp.com/DJSteele/DSNLessLinks.html
about creating a DSN-less connection from Access. For me the downside
is that the server name is hardcoded into the connection string. We use
DSNs which are pointing at DNS ...
|
MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
Fri, 5 May 2006 15:05:51 -0700
I am using MSAccess 2003 as my DB, ASP page my front end. My access file is
in the temp folder which ahs IUSR_Machine permissions. My asp page works
fine, connects to DB and retrieves what I want. Now, when I open my db file
in Microsoft Access in Exclusive mode my ASP page doest establish a
connection w ...
|
