This is making me nuts... any help will be much appreciated.
I installed Office 2003 Pro at home and at the office.
In Access, the macro warning keeps coming up when
opening an .mdb.  At work I can get to the security tab from

Does anyone have any tutorials that explain ways to use the date/time field?
I use these fields often to document when users perform actions using the
Now() function.  I'd like to be able to query these fields for things like
just a particular date or between certain times of the ...

Good afternoon,
1. In-Line-Funtion on the criteria column I type BETWEEN dbo.iStdt() AND
dbo.iDate() doesn´t work
2. If I type BETWEEN '01/01/2005' AND '12/12/2005' it works. This option I

Has anyone organised a data transfer from a client computer running Access
to MySQL tables located on the web ISP server? Is this possible? Are there
indirect ways around it?
chris

Would a loss in a connection to the database server cause Access to close
without warning and without error message?
I'm using DNS name for the server and Windows NT Integrated security.
Thanks.

I'm getting ready to develop an ADP frontend / SQL backend app and would
very much like some feedback on the strengths and weaknesses of 2000 and
2003.
The app will have about 10 - 15 users on a LAN.  The SQL server will also be

This is not throwing an error but it is not running the stored procedure
either...any ideas?
Thanks.
           'Insert the apptSchdBuild record

I've recently upsized a MSAccess2000 database to an access database project.
The ADP links into a SQL2000 backend. I've got Chipman and Baron Microsoft
Access Developers guide to SQL server, which has been a great help so far.
I've got as far as converting all the queries to ...

My problem is :
I am trying to join multiple tables and list the only needed fields in the
query result
the query takes less time if  I join the tables wihout specifying any fields

Veriview E-Business Suite is a Web-based, three-tier, multiple-user database
application for small- and medium-sized businesses. It uses high-performance
Microsoft ASP.NET platform and SQL database to store and access your
business data. Veriview can be hosted on our standard ...

I am trying to create a data access page for a project I'm working on. When
I create the page, it works fine. I can save it to my web server - it works
fine and I can access the data from any web browser. As long as I don't
leave "design mode" I can continue to modify and save ...

I want to run the below code and then use the recordset after the update to
loop through and do necessary updates to the data that came through in the
stored procedure.  I'm getting some locking errors.  Any ideas would be
great.

Get ADP Custom Database Property - Document Number Value ** $100 To
Anybody Can Do It...  i don't care if it takes you 15 seconds...
We will pay $100 dollars to any programmer who can GET the Document
Number value from the Database Properties area of an ADP & ADE (Access

hi group!
i want to use the access runtime with an access 2003 ade-file. The problem
is that the application is slower with the runtime if i compare it with the
ade startet with the access full version!

For all of my previous Access .ADP applications, I've used a login screen
that the user uses to authenticate (a table stores usernames/passwords).
Once they've logged in, I store their login information in global variables.
The problem I've found is that sometimes when the ...