This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC5A.5035CF00
Content-Type: text/plain;
	charset="iso-8859-1"

Hi all,

I need to convert Access 97 to Access 2000.

How can I convert the DAO from 2.5/3.5 to DAO 3.6?

Are there any other precautions I need to take before the conversion process
takes place?

Thanks

Sam Rose

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC5D.443D3460
Content-Type: text/plain;
	charset="iso-8859-1"

Hi Sam,
 
90% of the time all you have to do is open the database in Access 2000 and
click 'convert'. For those that don't completely work, you need to go
through the code manually and it's as simple as changing the commands from
2.5/3.5 to their 3.6 equivelent.
 
check out:
 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/ht
ml/output/F1/D2/S5A331.asp
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/h
tml/output/F1/D2/S5A331.asp> 
 
for conversion examples and more of the microsoft
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/h
tml/output/F1/D2/S5A331.asp> knowledge base for information.
 
kind regards,
 
Wes.

-----Original Message-----
From: Sam Rose [mailto:Sam@d...]
Sent: Donnerstag, 25. April 2002 15:09
To: Access
Subject: [access] Converting Access 97 DAO to Access 2000 DAO



Hi all, 

I need to convert Access 97 to Access 2000. 

How can I convert the DAO from 2.5/3.5 to DAO 3.6? 

Are there any other precautions I need to take before the conversion process
takes place? 

Thanks 

Sam Rose 

--- 

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC5D.AE1A2FF0
Content-Type: text/plain;
	charset="iso-8859-1"

sorry thats first one is the wrong link : - / but you can look it up on the
knowledge base.
 
Wes.

-----Original Message-----
From: Fitzpatrick Wesley CHDI 
Sent: Donnerstag, 25. April 2002 15:30
To: Access
Subject: [access] RE: Converting Access 97 DAO to Access 2000 DAO


Hi Sam,
 
90% of the time all you have to do is open the database in Access 2000 and
click 'convert'. For those that don't completely work, you need to go
through the code manually and it's as simple as changing the commands from
2.5/3.5 to their 3.6 equivelent.
 
check out:
 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/ht
ml/output/F1/D2/S5A331.asp
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/h
tml/output/F1/D2/S5A331.asp> 
 
for conversion examples and more of the microsoft
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/h
tml/output/F1/D2/S5A331.asp> knowledge base for information.
 
kind regards,
 
Wes.

-----Original Message-----
From: Sam Rose [mailto:Sam@d...]
Sent: Donnerstag, 25. April 2002 15:09
To: Access
Subject: [access] Converting Access 97 DAO to Access 2000 DAO



Hi all, 

I need to convert Access 97 to Access 2000. 

How can I convert the DAO from 2.5/3.5 to DAO 3.6? 

Are there any other precautions I need to take before the conversion process
takes place? 

Thanks 

Sam Rose 

--- 

--- 

Just went through this myself so here's what I've learned.

Microsoft strongly suggested you split the database into a front end/back 
end situation. This can be accomplished after you convert the database. 

To update to the newest version of DAO you need to go include the last 
version of the DAO driver. Open one of your modules, and then choose the 
references off of the tools menu. Check the latest DAO driver. If your not 
going to use ADO, uncheck that. This way you won't have to go though all 
your code to make it Access 2000 DAO compatible.

Good luck.

> This message is in MIME format. Since your mail reader does not 
understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC5A.5035CF00
Content-Type: text/plain;
	charset="iso-8859-1"

Hi all,

I need to convert Access 97 to Access 2000.

How can I convert the DAO from 2.5/3.5 to DAO 3.6?

Are there any other precautions I need to take before the conversion 
process
takes place?

Thanks

Sam Rose