client server setup
Sat, 24 Sep 2005 14:58:16 GMT
I asked the following on a mysql newsgroup, after reading all I want to know
here is this:
Can I remotely (from another city, state) connect to mysql or ms sql with
linked tables in ms access? If so how is it done? I have a small 5
computer network now that works good with linked tables to mysql. All data
...
|
UNICODE error message when opening a table
Thu, 22 Sep 2005 10:13:22 -0400
Hello
I get this message: The width of a Unicode text column must be an even
number of bytes
Thats when I try to open a linked table in Access.
Any idea why? I can open all the other linked tables but this one (and of
course thats the one I need ;( )
...
|
Drop Table on SQL Server through Access
Tue, 20 Sep 2005 09:13:35 -0500
I have a table in Access that I want to push to SQL Server (Enterprise
Edition) but I can not do it daily until I go to the server and do a "drop
table" command. Is there any way to pass this command to the SQL server
from Access, or do I have to do a delete of all records and then
re-populate?
Any help wo ...
|
Setting ODBCConnectStr property in an ODBC Pass-through query
Mon, 19 Sep 2005 12:18:03 -0700
I am trying to write a very simple VBA routine (attached below) and reset the
ODBCConnectStr property in an ODBC pass-through query. The routine runs fine
until the last line. I keep getting an error message "the expression you
entered refers to an object that is ether closed or doesn't exist." when the
la ...
|
Incompatibility across the board!!!!!
Fri, 16 Sep 2005 10:50:05 -0700
Help anyone,
I have setup a stock inventory system for a department and have
finished testing on my end with a couple of users. The bulk of the users are
in another building and I get errors on their machines that don't happen over
here. This is an Access system connected to a SQL Server database via ...
|
many connections from Access to SQL through ODBC
16 Sep 2005 04:31:33 -0700
How to limit number connections from Access to SQL Server?
It is look like that all bound comboboxes and subforms makes new
connections. How to prevent this?
Also, when I monitor activity on SQL Server through SQL Profiler I can
see that Access send many stataments when activate event of form is
triggered. ...
|
New SQL version = errors
Wed, 14 Sep 2005 08:24:09 -0700
I have an Access frontend linked to a SQL tables.
We are running a Windows NT 4.0 Server.
Recently updated from SQL 7 sp 3 to SQL 2000 sp3.
I'm having problems with one form/table. The form takes Order ond Lot
information entered by the EU and places it into a SQL table using the
DoCmd.RunSQL com ...
|
|
|
ODBC: Driver's SQLSetConnectAttr failed?
Wed, 14 Sep 2005 16:23:31 +0200
Hi,
I've got a very weird ODBC problem and the log file mentions this: DIAG
[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed (0)
The situation is the following:
* I've got several Windows 2000 and Windows XP PCs. Each PC has Access
2003, some also Access 2000.
* I've one l ...
|
Query Problem Form's Control Source
Tue, 13 Sep 2005 14:45:46 -0700
I have a master form that shows the parent record and a subform on the main
form with the child records of a one-2-many relationship. Basically Stock
Items and Stock Transactions in the subform. The Master form contains a
query that selects all the fields I want displayed on the master with the
subform h ...
|
ODBC connection to deleted records!
Tue, 13 Sep 2005 14:43:15 -0700
I created an ODBC connection to tables in Oracle 9i database.
I am loading the tables and in refining the load I delete all records and
reload.
Access is apparently storing the table data because even when the tables are
empty I can still see data. I call these phantom records.
I refreshed the tables an ...
|
