Makimg ACCDE (1 Viewer)

K

Kundan

Registered User.

Local time

Today, 08:44

Joined

Mar 23, 2019

Messages

118

• Oct 21, 2019

• #1

My DB is 6404 KB Access is unable to create accde. Is there a way out?

 

June7

AWF VIP

Local time

Today, 07:44

Joined

Mar 9, 2014

Messages

5,470

• Oct 21, 2019

• #2

Access file size limit is 2GB, see no reason why cannot create accde since file size is way under that. Very odd. Be sure to run Compact & Repair. Try decompile, Debug>Compile and C&R again. http://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp

 

Last edited: Oct 21, 2019

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 01:44

Joined

Jan 20, 2009

Messages

12,852

• Oct 21, 2019

• #3

Often the problem is that Access cannot create accde if the VBA code won't compile. Try compiling the code and see where it throws errors.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 08:44

Joined

Oct 29, 2018

Messages

21,468

• Oct 21, 2019

• #4

Hi. Just in case you don't know how to "compile" your project, try the following steps:


Hit Alt + F11, then from the top menu, select Debug > Compile ...



Hope that helps...

 

K

Kundan

Registered User.

Local time

Today, 08:44

Joined

Mar 23, 2019

Messages

118

• Oct 22, 2019

• #5

June7 said:

Access file size limit is 2GB, see no reason why cannot create accde since file size is way under that. Very odd. Be sure to run Compact & Repair. Try decompile, Debug>Compile and C&R again. http://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp

Click to expand...

I removed the compilation errors and succeeded. Thanks. GOD BLESS YOU!!!!!

 

K

Kundan

Registered User.

Local time

Today, 08:44

Joined

Mar 23, 2019

Messages

118

• Oct 22, 2019

• #6

Galaxiom said:

Often the problem is that Access cannot create accde if the VBA code won't compile. Try compiling the code and see where it throws errors.

Click to expand...

I removed the compilation errors and succeeded. Thanks. GOD BLESS YOU!!!!!

 

K

Kundan

Registered User.

Local time

Today, 08:44

Joined

Mar 23, 2019

Messages

118

• Oct 22, 2019

• #7

theDBguy said:

Hi. Just in case you don't know how to "compile" your project, try the following steps:


Hit Alt + F11, then from the top menu, select Debug > Compile ...



Hope that helps...

Click to expand...

I removed the compilation errors and succeeded. Thanks. GOD BLESS YOU!!!!!

 

theDBguy

I’m here to help

Staff member

Local time

Today, 08:44

Joined

Oct 29, 2018

Messages

21,468

• Oct 22, 2019

• #8

Kundan said:

I removed the compilation errors and succeeded. Thanks. GOD BLESS YOU!!!!!

Click to expand...

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.