Convert Access 2.0 Code to Access 2000 
Author Message
 Convert Access 2.0 Code to Access 2000

Hi there,

I have a simple question:
How do I write my old Access 2.0 Code with Access 2000 ?

Access 2.0:
Dim db_fc       As Database
Dim ds_fc       As Dynaset
Dim str_sql     As String
Set db_fc = CurrentDb()
str_sql = "select count(*) as Cnt from [table]
Set ds_fc = db_fc.CreateDynaset(str_sql)
ds_fc.MoveFirst
FCountAdressen = ds_fc.prsCount
ds_fc.Close

Access 2000:
???

Thanks for help
Joerg Reimer



Fri, 28 May 2004 17:42:33 GMT  
 Convert Access 2.0 Code to Access 2000
You'll get better Access answers by asking in comp.databases.ms-access or
one of the Microsoft-sponsored newsgroups, microsoft.public.access...

You did not say what problem you have encountered, but my guess is that you
are having difficulties because the default library checked in new Access
2000 databases is the ADO library, rather than the DAO library. Both are
available and there is some advantage to continuing to use DAO for Jet
database Access.

Open any module, Tools | References and check the Reference for DAO 3.6,
then, just to be certain, move it _above_ the ADO reference in the list.

If that doesn't solve the problem, first read
http://www.mvps.org/access/netiquette.htm for good suggestions on effective
use of the newsgroup and ask specific questions in comp.databases.ms-access.

This newsgroup is for the Visual Basic product, which does also use Jet
databases, but it's only by chance that you find users here who are familiar
with both VB and Access.

Quote:
> Hi there,

> I have a simple question:
> How do I write my old Access 2.0 Code with Access 2000 ?

> Access 2.0:
> Dim db_fc       As Database
> Dim ds_fc       As Dynaset
> Dim str_sql     As String
> Set db_fc = CurrentDb()
> str_sql = "select count(*) as Cnt from [table]
> Set ds_fc = db_fc.CreateDynaset(str_sql)
> ds_fc.MoveFirst
> FCountAdressen = ds_fc.prsCount
> ds_fc.Close

> Access 2000:
> ???

> Thanks for help
> Joerg Reimer



Sat, 29 May 2004 00:10:58 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Convert access 2.0 to access 2000 database

2. Code from Access 2.0 not working in Access 2000

3. Converting Access 2.0 DB to Access 97 DB in VB code

4. Importing an Access 2000 table into another Access 2000 database with VB Code

5. Upgrade Access 2.0 to Access 2000

6. Converting from Access 97 to 2000 - Visual Basic Code

7. Convert an Access 2000 MDB to ADOX creation code

8. Convert an Access 2000 MDB to ADOX creation code

9. Convert Access 97 db to Access 2000 db in VB6

10. Using VBA to Convert Access 2000 database to Access 97

11. Access 2000 converted to Access 97 report query data type errors

12. Converting Access 97 to Access 2000 via VBA

 

 
Powered by phpBB® Forum Software