Access 2003 database in 2007, Rename not working
Tue, 28 Oct 2008 06:31:06 -0700
DoCmd.Rename on a linked table does not rename the table. It does not raise
any errors either. This happens with Access 2007 runtime only. It works as
expected with Access Retail.
Is there a workaround for this issue?
Thanks ...
|
2 questions on table updating
Thu, 23 Oct 2008 19:20:00 -0700
Two questions on Access 2007:
First question:
I have a single table containing unique ID and name of performing artists
(ArtistID, ArtistName). A Recordset - artistRS - that is populated with a
simple "SELECT a.artistID, a.artistName FROM Artist as a ORDER BY
a.artistID". artistID is an auto-number
I ...
|
SEEK characters limitation
Wed, 22 Oct 2008 06:45:01 -0700
I am using DAO360 and Seek command on table with MEMO field. It seems that
Seek command searches only for 255 characters, not more. Am I right ?
Is it a bug ? Because in documentation of Seek I did not find limitation in
characters to be searched...
Thanks a lot in advance! ...
|
ADO Transaction with linked MDB file?
Wed, 22 Oct 2008 00:52:01 -0700
I get 'Operation Not available for this object'
when I try these lines:
Public cnMain As New ADODB.Connection
' fails here ----> Set cnMain = CurrentDb.Connection
'my intent is to do transactions that I normally would with this line
Set cnMain = CurrentProject.connection (in an ADP)
.
.
.
cnMain.Begi ...
|
LDAP Is it possible to read the Active Directory within an Access
Fri, 17 Oct 2008 13:03:02 -0700
Is it possible to read the LDAP Active Directory within an Access Form? ...
|
Error when trying to use ADO
Fri, 17 Oct 2008 02:30:07 -0700
I am new to Access and maybe I missed something. When I use the ADO syntax I
get a message that I am trying to use an undefined user type. So I have been
using the DAO syntax instead. Is there a pre-step where I set up Access 2007
to see the ADO library? Thanks. ...
|
LastUpdated value needed
Thu, 16 Oct 2008 11:12:00 -0700
does anyone know where to find the date of a module? I tried this but I get a
way to old value:
db.Containers!Modules(strModuleName).LastUpdated
and this didnt fix it either:
Set ctr = dbs.Containers("Modules")
Set doc = ctr.Documents(strModuleName)
...
|
|
|
"Restore" Query Results via VBA?
Thu, 16 Oct 2008 10:50:15 -0700
A button on a form runs a select query that produces a list of names.
Because the form is maximized, the query results are maximized too. How can
I display the query results "restored" to not fill the entire screen?
Haven't been able to find any arguments in DoCmd.OpenQuery that would give me
what I want. ...
|
ODBC Relink via File DSN
Mon, 13 Oct 2008 16:52:01 -0700
Hi Everybody,
I've an Access application which links to an ODBC data source.
Currently, I'm using File DSN for ODBC access.
I've opened the DSN file and changed the server IP address, from
'SERVER=192.168.0.2' to 'SERVER=192.168.0.1' . Unfortunately, the Access
application is still refering to the old se ...
|
Table size and network response time
Mon, 13 Oct 2008 14:54:01 -0700
I need a table with 4 fields, one date, three texts and one autonumber that
is also a unique number for a barcode ID.
The problem is that the table will have over 1 million records. I am
wondering how MS Access will cope and whether the users will be affected on
the LAN.
Does anyone use that sort of s ...
|
