Windows 2003 System DSN not found (but User DSN works)
26 Oct 2005 12:08:38 -0700
We just setup a new Windows 2003 server and we can't use System DSNs.
If we setup user DSNs they work just fine, but everytime we try to use
a System DSN it can't be found.
Does anyone have any suggestions?
Josh
...
|
ODBC Wizard Problem
Tue, 25 Oct 2005 05:18:02 -0700
I’ve run into an issue with a user trying to make an ODBC connection to an
SQL Server database and I have no clue as to why this one thing happens (or
more precisely doesn’t happen). She logs on to her PC with her Id. She can
make a connection to a database on one server with no problem. However when
she t ...
|
Retrieving open connections to an access database
Tue, 25 Oct 2005 01:44:04 -0700
Is there a way of retrieving any open connections to an Access Database. And
if so can the computer name from which these connections are established
from, also be retrieved or not?? Say for instance there are 3 computers
connected to a single access database located on a server, is there a way to
retrieve ...
|
Access to Visual FoxPro - ODBC vs OLE DB
Mon, 24 Oct 2005 09:15:03 -0700
Can someone give me the differences and/or reasons of using the ODBC vs OLE
DB connection between Access 2003 and Visual FoxPro database? I'm using ODBC
right now, but the speed is terrible. Someone asked about OLE DB. I'm just
starting the research but am not quite sure of the differences. Thanks in
a ...
|
importing Informix DB/tables into M$ Acess 2000
21 Oct 2005 08:47:02 -0700
Does anyone know how i could create a link in M$ Access 2000
to my Informix Database and/or tables ..
Thanks.
...
|
SQL - Access2000 - ODBC Record Locking
Thu, 20 Oct 2005 11:29:13 +0200
Hi,
Maybe someone knows the answer
SPECS:
- Windows 2000 Server SP4
- MDAC 2.8 SP1
- Jet Service Pack 4
- MSQL 2000 Standard
- Office2000
Problem:
When linking to an table from the SQL machine with standard Access and
adding new records using forms the record can not be changed
afterward.
It alm ...
|
record locking access 97 front end SQL back end
Tue, 18 Oct 2005 19:01:02 -0700
I have an application using ODBC linked SQL tables to access 97 front end
application and am experiencing problems with access not recognising that a
record is currently being editted by someone else until the entire record is
to be updated and then the user is told that they are going to loose their
chang ...
|
|
|
Insert data through ODBC
18 Oct 2005 06:49:17 -0700
I trying to use an ODBC connection and insert data into a database. I
got a script for excel help with I'm trying to modify to my uses.
The scprit call out :
Dim wrkODBC As Workspace
Dim cnWERP As Connection
Dim rsLIMS As Recordset
But VBA dose not recognize, Workspace, Connection, or Recordset -
Co ...
|
First time opens--> problem, second,third... time opens-->OK
Mon, 17 Oct 2005 06:01:05 -0700
a)I have an mdb file on the server (Windows NT 4.0) Other pc on the net have
Windows XP Pro. Each pc has a shortcut (\\Servnt1\statistics\file.mdb) on the
desktop. When the file opens from a pc for first time user must do two times
double click on the shortcut, if it opens for second, third... time it opes
...
|
SQL Table Autonumber errors
Sun, 16 Oct 2005 13:11:03 -0700
Hi All,
I upsized to a SQL server with an Access FE. Many of my Access tables had
Autonumbers to create their Primary keys. Converting them to SQL didn't
create any problems. All forms work fine and create new records as needed.
There's one table though where I just appended a number of new records fr ...
|
