I wonder if any of you Access geniuses might be able to help me with a
problem:
We have a large COM based application (C++ and VB) that uses a single
Access mdb database to store data.  What we are seeing is,

I haven't written ASP code to update an Access DB in years. Having a
permission problem. Been working on it for hours, time to get some help.
Running IIS 5 on an XP Pro system. ASP code to update an Access 2002 table
via ODBC. Receive the following error:

I have an application that uses MS-SQL Linked tables.  I have a utility
routine that drops all links and re-establishes them.  It works great
when my connection string is a DSN connection but I would like to
change it to DSN-Less so users don't have to set up ODBC connections on

I've got my regular query which I normally run from the Queries window
in Access. However, I'd like to run the sql query from a form I've
written in VB. The problem is the query itself accesses another query
- Is there a way to call a query from within another query using VB -

help!!
I have a form which contains 6 subforms, with check boxes which run
events that then update data on all the forms.  the data is all on 1
table in a backend data base and the user works the form in the front

I need to bring the ssn's into UniqueSups (supervisors) from
tblNonNormalized.  My inherited DB is not normalized and I find it
extremely irritating due to the workarounds needed.
I created tblUniqueSups by doing a select Distinct Supervisor Name.

Has anyone coverted this to A2000 yet? I am having problems coverting
it, I seem to have lost the USysRegInfo table.
Can anyone help or send me a copy?
Thanks

Hello everybody, your help will be very very welcome on a very classic
question...
I have some Excell Macro background, a little bit of VBA knowledge.
I import daily from Internet series of data. They are setup as follow,

Using Access 2002, the application frequently shuts down with no warning
when I use the toolbar buttons to switch between Form and Design views for
forms.
I have no opportunity to save design changes, and it can happen on any form.

I have a form with a button, now when I click the button it uses one
combo box to filter a new form that the button opens.
What I need to do is have the form filter by two of the combo boxes on
the first form.

Hi
I have the code below that allows me to test the result of a query
The query is a crosstab and pivots on months
what i want to do is check if the field december is different to blank

We have a large MS Access system made up of many large MS Access
applications.  They run against a SQL Server.  We are going to do a
conversion of this systim into VB.NET.  We have a number of issues to
resolve.  But, probably the biggest is the use of "Temp Tables".

I've a requirement for a treeview control to display a master-detail view.
So instead of the old the old 'ActiveX + 1,000 lines of code' method
that I've used in the past. I decided to try a different approach.
This is a very simple idea so I'd be surprised if it hasn't been done

Where can I find a good source (book, website etc) for best practices
for programming database applications?    I inherited a c# distributed
application using OleDB/ADO.with an Jet backend and am puzzled by some
of the choices that wer made.  The Jet database initially made a good

When I attempt to import/link a text file, I select the type of file as
TextFiles, select the text file, and hit the Import or Link button.  No
specification file is presented and nothing gets linked or imported.
Any idea what I did to hose the ability to import text files?