Search results

How to code to connect to SQL server using odbc, SQL authentication mode? There are about 500 tables in it.

I use dsn file as below from Access to link to SQL server via ODBC. From Access, I use this file but list all tables including system tables. How to restrict system objecs? [ODBC] DRIVER=SQL Server UID=aspfun Trusted_Connection=Yes DATABASE=credent WSID=aspfun_ws APP=Microsoft Data Access...

I splited program and database as two mdb file, app.mdb and data.mdb. All tables are stored in the data.mdb file. How to use code to link all tables in the data.mdb whe app.mdb open every time?

number, Integer

I have a table like below. How to add sequential number that will reset to 1 whenever the name changes? Name Date SeqNum ------------------------------ AAA 1/10/2007 AAA 1/12/2007 AAA 1/15/2007 BBB 2/10/2007 BBB 2/13/2007 CCC 3/1/2007...

I used Access to link to a table in SQL server. After linking, a bit data type in SQL server became "yes/no" column in Access but only list "-1" or "0", missing "null". How to list "null" in Access linked table?

Thank you, Dr. data, you gave me a point. "General number" did not work but "fixed number" work.

I used Access to link to a table in SQL server. A column in SQL is uniqueid but in Access became scientific number(if number is bigger, e.g. more than 11 digital numbers). How to void it and always display standard number? for example, 10001000084 4.81531400018E+11 //can void it??? 10001800006

How to use code to link to a table in another Access mdb file?