make ACCDE

[zambam737]

Dear all,

i recently converted an old 2003 DB into 2007 and am trying to make an executable file to run on PCs without Access 2007 installed. When I tried making an ACCDE file - I received the following error:

This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

I am working through all the differences of 2007, but cant seem to make this work.. if anyone can put me out of my misery........

thanks, mark

 

[pbaldy]

The most common problem when making an MDE/ACCDE is code that won't compile. Have you compiled the code (and hopefully Option Explicit appears at the top of each module)?

 

[zambam737]

Thanks a mil Paul

I have been working - and compiling this for weeks successfully.. i had no idea it was failing the compiler... it created the ACCDE instantly - youre a legend, thanks a million

mark

 

[DJkarl]

Dear all,

i recently converted an old 2003 DB into 2007 and am trying to make an executable file to run on PCs without Access 2007 installed.

thanks, mark

I'm glad you got it to work for you, however I would point out that it is impossible to make an Access database into an executable. You will always need Access installed on the host machine...or at the very least the Runtime version of Access.

 

[zambam737]

Thanks for the reply and help DJ.. but Im a little confused.. Back in the day - using Access 97 and 2000.. we used to use the Access Developers kit to create a runtime version of the program - to run on machines without Access installed.. This kit created a self extracting package which placed all the necessary components to run your program.. Then, when 2003 version came out - the Access Developers toolkit was included in Access. I havent used Access for some time, so 2007 is fairly unfamiliar to me but I was sure that this feature would still exist...???

any advise welcome.. thanks a mil

 

[pbaldy]

Nothing has really changed. DJkarl's valid point is that you can not create an executable, defined as something that runs on it's own like an exe. The package you created for 97 and 2000 installed a "runtime" version of Access on those PC's. Your MDE always ran under Access, as will your ACCDE. More info here, in particular the last item in the "what's good" section:

http://allenbrowne.com/Access2007.html

 

[zambam737]

thanks Pbaldy

I really appreciate your time and help with this.. I went to the site you recommended and read some hints etc from the solution centre also - which is great.. Can I ask your advise though, as Im not a full time developer anymore and need to save time where I can.. what is your recommendation towards delivering my program to multiple users world wide from a website... do they need to all have Access 2007 installed on their machines..? Im sure so many have earlier versions..

perplexed

 

[pbaldy]

If you create an ACCDB/ACCDE, they will need 2007. You can also save your application as an MDB in 2002/3 or 2000 format, but of course you can't use features unique to 2007. If it needs to be in 2007 format, you can simply direct them to the MS site where they can download/install the runtime version for themselves, and thus be able to run your application.

 

[zambam737]

Thanks so much Paul... what a joy it is to have people like you on here to guide us.. thanks very much indeed, i really appreciate you taking the time.. have a great day

Mark

 

[pbaldy]

No problem, Mark, happy to help. Good luck with your project!

 

[KenHigg]

No problem, Mark, happy to help. Good luck with your project!

'a legend' ?

 

[pbaldy]

As the self-deprecating expression goes:

A legend...in my own mind.

 

[KenHigg]

You all been hot the last few days huh? Saw 110 somewhere out west - Ouch!?!

 

[pbaldy]

Yeah, it's been around 100 here (I'm at around 4,500'), but at least it's a lot drier than the south. The humidity in the south and east just kills me when I go there.

 

[zambam737]

Active X control - value doesnt work

Dear Paul,

hello again, about a year ago you helped me out a lot and right now I have a problem that has been vexing me for a day or two.. cant fix it... so thought I'd ask you - hope you don't mind......??

I have a form with an active x calendar control and a list box.
The listbox is populated with a query that uses the selected date from the calendar to filter the query. The query returns appointments made for that calendar date.

When i select the date, i hit a button that runs this code:

Private Sub ActX_Calendar_Enter()
[Forms]![frm_DailyPlanner]![fld_SelectedDate] = Me.ActX_Calendar
Me.lbx_DailyPlan.RowSource = "qry_DailyPlanner_SelectedDate"
Me.lbx_DailyPlan.Requery
End Sub

it works fine... BUT, what I want is for the listbox to requery itself each time I select a different day...

I have a txt_box which shows the date supposedly selected on the calendar (normally hidden and only used for the query)

The problem is..... when i select any given day on the calendar, it does NOT register.. and when i step thru the breakpoints... it does not pickup that I have selected a different day. I used the same code as above on the On_Click function of the activeX control.. just doesnt work..

and like i said.. after selecting a different day, and hitting my button , it does register the date selection..

any ideas please...?

thanks again, Mark

 

[josephbupe]

Your name "Zambam", hmm...interesting. Can't you just round it off to "Zambia?"

 

[zambam737]

very good.. I am from Zambia actually....

nickname is a long story..

 

[josephbupe]

Glad to meet you here country man. How many are we here anyway? Could you know?