By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,797 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Can i use the reference Jet 2.5/3.5 in Access 2003 without any problems?

P: n/a
Hi to you all,

I have some questions.

I just converted my Access 97 database to Access 2003.

To let it still work i referenced the Jet 2.5/3.5 jet engine in my
database.
Is this oke?

Is there anybody who did the same without changing any code?
I have a huge database with lots of forms and code behind them and
modules full of code. I do not have the intention of changing the
code.

I tried using 3.6 but i found problems referring to fields in the
recordset object when i use rec.fieldname. Perhaps it should be
rec.fields("fieldname").
I am aware of using a ! for refering to fields on a form.

Also had a problem with Workspaces(0).
Should i use DBEngine() instead?

Anybody found more of these problems?
Greetings Patrick
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
pa****************@fortis.com (PatrickO) wrote:
To let it still work i referenced the Jet 2.5/3.5 jet engine in my
database.
Is this oke?
No idea. I certainly wouldn't do this.
Is there anybody who did the same without changing any code?
I have a huge database with lots of forms and code behind them and
modules full of code. I do not have the intention of changing the
code.
Bite the bullet. It's a bit of tedious work but you'll feel better once you're
finished. <smile>

Access 2.0 and Access 97 to Access 2000/2002 conversion problems
http://www.granite.ab.ca/access/conversionproblems.htm
I tried using 3.6 but i found problems referring to fields in the
recordset object when i use rec.fieldname. Perhaps it should be
rec.fields("fieldname").
I am aware of using a ! for refering to fields on a form.
You can also use rec!fieldname.
Also had a problem with Workspaces(0).
Should i use DBEngine() instead?


I think so. What are the lines of code?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #2

P: n/a
"PatrickO" <pa****************@fortis.com> schrieb im Newsbeitrag
news:87**************************@posting.google.c om...
Hi to you all,

I have some questions.

I just converted my Access 97 database to Access 2003.

To let it still work i referenced the Jet 2.5/3.5 jet engine in my
database.
Is this oke?
Danger: I wouldn't try that. There is no reason for it!
Is there anybody who did the same without changing any code?
I have a huge database with lots of forms and code behind them and
modules full of code. I do not have the intention of changing the
code.
This should be less work than you expect...
I tried using 3.6 but i found problems referring to fields in the
recordset object when i use rec.fieldname. Perhaps it should be
rec.fields("fieldname").
I am aware of using a ! for refering to fields on a form.

Also had a problem with Workspaces(0).
Should i use DBEngine() instead?


I say yes, the OH say's no-;)

Peter
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.