Search results for query: *

Cannot install option pack 4 (want to install iis 4.0) onto server or workstation. First receive message that option pack has not been tested on os with service pack > 4( I have sp6a). I click Yes to proceed with the installation. Then I receive the message that Invalid program arguments were...

Hi, I upgraded my machine from win nt 4.0 workstation to server. In thec process I was able to save my original configurations were saved. More specifically, the registry was unaffected. Now, I need to reverse the process, and downgrade nt server to a workstation. I was wondering if there is a...

Hi, I have a MS Accress project (adp) databae as the front-end and SQL server as the back-end. When I try to access a specific report, I get the message that there is a problem connecting to the OLE server. Then the mesage lists the possible fixes. I haven't tried htem as yet, since I dont'...

Does anyone know of a way to view objects of another Access datbase within an Access Database? Right now, we have it so that when the users click on a button, it opens up the other Access database. WE want it so that the user can view the items (e.g. reports) of the other database within the...

We have an access project (adp) front-end, and a SQL Server back-end. WE've implemented field-level security module which uses the user's login name when they first login into the system. The problem we're having is how do we persist security such that the connection to SQL Server does not...

Hi, We have 16 users who are plannign to use a centralized MS Access Porject. Is there a way to do this, so that we don't get the message that the database is read-only. Also, what does this meesage mean? DOes this message mean that users can still insert, delete, edit the data, but cannot do...

is there a way to use an Access project in a multi-user environemtn from a centralized location without getting the warning message about the database being read-only. Users will only be accessing the data, adding new data, deleting, etc. and not changing any design objects. Thanks in advance.

We are building an Access to SQL Server ADP application. We have installed SQL Server 2000 not using default naming conventions. Therefore, the name of the server has ended up with what lools like the (prompted for) directory in the path (CAL_SQL\DDSQLSERVER). Thus, the Data Source property...

I found the following excerpt in another forum posted by somenoe named Miguel. Thought it best described the situation I was having as well. No one has replied as yet, and was wondering if anyne can help me out with this problem: "I use DoCmd.OpenForm to open a form from another form. To...

I found the following excerpt in another forum posted by somenoe named Miguel. Thought it best described the situation I was having as well. No one has replied as yet, and was wondering if anyne can help me out with this problem: "I use DoCmd.OpenForm to open a form from another form. To...

I want my form to look up a record, using the recordsetclone, based on multiple criteria. I know I can do the followign with one criteria: Set rst = frm.recordsetclone rst.find "item = " & itemfound frm.bookmark = rst.bookmark WHat about multiple criteria in the rst.find line? I keep...

I've built a listbox, whereby a user can select one or multiple items, and then a filtered form opens up with the criteria specified. I'm doing this in an access adp. However, it seems like the serverfilter property of the form will not clear out when i close the form. I even added the...

Does anyone know of any product/utility out there that offers field-level security? We have a front-end access prject (adp) using a SQL server 2000 back-end. Thanks in advance.

DOes anyone know how to change DAO workspace to ADO?? Here's a snapshot of the code I want to change: Dim I As Integer Dim J As Integer, K As Integer Dim N As Integer Dim wks As Workspace Dim dbs As Database Dim rst As Recordset On Error GoTo ErrorHandler N = 0 Set wks =...

Is there a way to assign an ADO-based recordset to an form recordsource (an Access 2000 form - not an ADP)?

We are converting an Access database to a SQL Server back end. In doing so, we have found that our DAO method of referencing an index when opening the recordset is not supported with SQL Server. We have gotten to the point that we have to use an "Order By" clause in our ADO-based...

We are converting an Access database to a SQL Server back end. In doing so, we have found that our DAO method of referencing an index when opening the recordset is not supported with SQL Server. We have gotten to the point that we have to use an "Order By" clause in our ADO-based...

Hi, Does anyone know of a way of referencing an index using ADO? I have a front-end Access datbase , with SQL Server 2000 back-end tables. I'm using the following, rstCaleaADO.Index = "Master" See snapshot of code: Set conCaleaADO = New ADODB.Connection With conCaleaADO...