small DB won't complie to ACCDE 1

[1DMF]

Hi,

i have a small application which has been converted from MDB to ACCDB no problem, it also compact and repairs no problem, but refuses to compile to ACCDE.

What could be the problem as it certainly isn't due to table id's as the help implies there are only 16 forms and 15 tables, 13 are linked to SQL?

How do I track the reason for it failing to create an ACCDE?

Thanks,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

i went to the module and compiled, where it showed me the error and reason for not compiling.

Though i don't understand the reason.

Why can i not perform an edit against a record set?

Do While Not rs.EOF
    rs.edit
   ....
Loop

It says edit is not a member, where has it gone?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[RuralGuy]

Do you have any issues with your References? Do you disambiguate your libraries "Dim rs As DAO.Recordset"

(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro
Please respond to this forum so all may benefit

 

[1DMF]

nope, is that why i'm getting other odd errors with record sets?

Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("SELECT [Class],[Description] FROM [Comp_Classes] WHERE " & sSQL)

where

sSQL = "[Class] = 'A2' OR [Class] = 'A3']"

Is giving me a

Error 13, Type Mismatch

this was working fine in Access 2003?



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

yup, changed that declaration to

Dim rs As DAO.Recordset

and now it is running fine!

Do I need to change all my recordset declarations to DAO?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[RuralGuy]

It is always advisable to declare the library when defining Recordset variables as there are duplicate properties in the DAO and ADO libraries. The problem arises when both libraries are included in your References. I would suggest that unless needed you only include the library you are using (in this case the DAO library). Access will defaulting to using the first library in the list of References so you can change the results by simply changing the order they appear in the References. As I said, it is simply better to call your library and remove this as a potential problem.

(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro
Please respond to this forum so all may benefit

 

[1DMF]

How do I remove the reference to bot librarys?

which reference is for ADO?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[PHV]

which reference is for ADO
Microsoft ActiveX Data Objects x.y Library

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

Thanks PHV,

We had 2.1 referenced, any idea why the DB would have that reference in the first place?

Is DAO better than ADO?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[PHV]

Is DAO better than ADO
DAO is better for Jet.
ADO is better for any non MS db.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

Right so as we connect to MS SQL Server, DAO is the best way to go.

As usual PHV you're a star! , shame I can only give you one :-(

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[PHV]

we connect to MS SQL Server
Sorry, ADO is best suited for SQL server.
But, if you're satisfied with your actual DAO code, don't break it !

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

sorry, little confused as you said ADO was best suited for 'non MS db', but we have MS SQL.

How would I break it by changing the DAO.recordset declarations to ADO.recordset.

If using ADO will improve speed if it is mor efficient , then I'm happy to implement that change while i'm compiling it to work with the Access runtime and late binding.

But i don't want my wild cards and other syntax to have to change?

Does ADO / DAO affect if '%' or '*' is used?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[PHV]

DAO: '*'
ADO: '%'
As I said, don't break working code ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[1DMF]

hmm that's what I thought, so i won't be fixing it.

Unless there are significant performance benefits in doing so!

Thanks PHV good job one of us knows what we are doing, and it aint me -

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts