Search results for query: *

Hi... I am wondering what other problems you have had with connecting Access to SQL Server 7. I will have to make a decision with the week on whether to modify a clients Access 2000 app to SQL Server 2000, or to continue it on in Access. How do you link to the SQL Server DB? All comments...

Dim ac As Access.Application Set ac = New Access.Application ' put the path to your database in here ac.OpenCurrentDatabase ("c:\myfolder\mydb.mdb") ' by default, the OpenReport method of the ' DoCmd object will send the report to the printer ac.DoCmd.OpenReport...

There is an answer to this question on this webpage: Joe Garricks VB website... http://www.citilink.com/~jgarrick/vbasic/qa/answers/q00005.html hth Perogy

have you tried right-clicking and refreshing your Command, and everything else involved? This sometimes helps... Darryl

Hello: Does anyone else, besides me, think that the DataReports in VB6 are bad? They're ok for simple reports, and even slightly complicated ones, but you try to do anything complicated and it's a no-go. I've been pointed to Active Reports to use as an alternative, and I'm considering it. Darryl

Hello: I am having problems with VB6(SP3) and ADO using an Access 2000 database. I cannot seem to have >1 user in certain forms of my system at once, or I get various errors when users update the database (thru that form) I'm using the DataEnvironment to open the recordsets. I'm not sure how...