Hey bob,
thnx for all that! I figured that they were seperate issues after looking up some things. I do have all the libraries refereced as you said. I have office 9.0 lib instaleld so im using that. Everything works fine in access 97 but in access 2000 i keep getting problems with the custom commandbar. It does compile but doesnt run when you open a form. And I have access 97 and access 2000 installed. I didnt know that could give me a problem, does it???

thnx,
Sam

Hey,

I figured out my problem. The person who designed the access 97 database created a custom menu bar which was not converted correctly so for the commandbar's to work i recreated the menu bar in access 2000. Thanks Bob for all the help.

I have an issue converting DAO to ADO though, if anyone can help? how does DAO's workspace convertions look like in ADO???

thnx,
Sam

Sam Gharnagh
Jr. Programmer Analyst
Comp Sci at UofW

Hi Sam,

Glad to here you got it going.

In ADO the Connection object does double duty compared to DAO.

In DAO the Workspace object defines the session for a user and the Database object defines a data source.

In ADO the Connection object does both. It defines a session for a user for a data source. The conversion looks like:


' DAO
Dim dbs as DAO.Database
Set dbs = DBEngine.Workspaces(0).OpenDatabase(".\Northwind")


' ADO
Dim cnn as New ADO.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\Northwind.mdb;"

(though there are several ways to write these statments)

HTH,

Bob