Access Databases and AccessDataSource Control

Re: Converting 2003 mdb's to 2007 accdb's..MDE's and .AccDE's

Mikesdotnetting — Thu, 02 Jul 2009 14:33:54 GMT

BGriffin_TPA:
What if I'm using it as the backend of a website?

Stick with the mdb format.

BGriffin_TPA:
can you suggest a site (provide a link)?

http://www.utteraccess.com

(I preferred the old smilies...)

Re: Converting 2003 mdb's to 2007 accdb's..MDE's and .AccDE's

hans_v — Thu, 02 Jul 2009 13:15:50 GMT

BGriffin_TPA:
What if I'm using it as the backend of a website?..

You almost convinced me

In the past I found http://www.tek-tips.com/threadminder.cfm?pid=181 very usefull, I don't know what the quality is nowadays...

Re: Converting 2003 mdb's to 2007 accdb's..MDE's and .AccDE's

BGriffin_TPA — Thu, 02 Jul 2009 13:12:20 GMT

What if I'm using it as the backend of a website?..If still No, then can you suggest a site (provide a link)?

Thanks....

Re: Converting 2003 mdb's to 2007 accdb's..MDE's and .AccDE's

hans_v — Wed, 01 Jul 2009 20:39:10 GMT

This is not the right forum to ask, because there's no connection with ASP.NET whatsover....

Converting 2003 mdb's to 2007 accdb's..MDE's and .AccDE's

BGriffin_TPA — Wed, 01 Jul 2009 18:59:57 GMT

I did my homework before posting this:

http://support.microsoft.com/kb/814858

http://support.microsoft.com/kb/283788

http://forums.asp.net/search/SearchResults.aspx?q=.mde&o=Relevance

http://forums.asp.net/p/534309/534309.aspx#534309

I upgraded from Office 2003 to Office 2007, installed SP1 and SP2 and several other reccomended D/L's from the site onto my XP Pro laptop and can run MDB's in native mode on Access 2007, but it won't let me.MDE them..

"Can't create the file...If the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."

...ok..no problem..I'll just convert it to an Access 2007 .AccDB..that happened ok..so now I'm almost home!!..Now, I'll just convert the .AccdB to an .AccdE..no, actually you won't..SAME MESSAGE..well, what the ?..does a new .Accdb convert?

I created a new .Accdb project, threw a text, list, combo on a form..now..convert to an .AccdE..works fine..

Conclusion:

the Access 2007 conversion facility won't MDE an earlier product, and the .AccDE facility wont create one from a converted earlier version, either.

Bummer....thanks for any assistance...