|
|
Hi,
I'm just learning about splitting an Access database for a multi-user
environment. I went through the process using the database splitter and
everything works fine with the FE on my local desktop and the BE on a network
file server. I read that the next thing to do is to save the FE as an MDE
file and distribute that to the users. But, when I click Make MDE file..., I
get an error, "Unable to make MDE file". I googled the error message and it
sounds like I have too many objects in the database. Is there any way around
this error? The make MDE feature seems kind of useless if you're restricted
as to how many objects you can have in the db. The .mdb file is 4mb and I'm
using Access 2003. I appreciate any advice.
--
Thanks,
Jeff
Jeff
|
|
Hi,
It's very unlikely. Most problems are due to referances, mispelled control,
variables...
I would you to start by checking the codes, forms, reports etc.... before
making a MDE.
Jeff Stroope wrote:
[Quoted Text] >Hi,
>
>I'm just learning about splitting an Access database for a multi-user
>environment. I went through the process using the database splitter and
>everything works fine with the FE on my local desktop and the BE on a network
>file server. I read that the next thing to do is to save the FE as an MDE
>file and distribute that to the users. But, when I click Make MDE file..., I
>get an error, "Unable to make MDE file". I googled the error message and it
>sounds like I have too many objects in the database. Is there any way around
>this error? The make MDE feature seems kind of useless if you're restricted
>as to how many objects you can have in the db. The .mdb file is 4mb and I'm
>using Access 2003. I appreciate any advice.
>
--
Message posted via http://www.accessmonster.com
|
|
Adding on to this:
Indeed, the number of objects is very rarely the issue! In the vast
majority of cases, the problem is an error somewhere in the code, that
will not allow the code to be compiled. To locate it, open any module in
the Visual basic editor, and go Debug -> Compile <Your Project Name>
from the menu. The process will highlight the first error found; fix it
and repeat, until you get no more errors, then you will be able to make
your .mde.
HTH,
Nikos
AccessVandal via AccessMonster.com wrote:
[Quoted Text] > Hi,
>
> It's very unlikely. Most problems are due to referances, mispelled control,
> variables...
>
> I would you to start by checking the codes, forms, reports etc.... before
> making a MDE.
>
> Jeff Stroope wrote:
>> Hi,
>>
>> I'm just learning about splitting an Access database for a multi-user
>> environment. I went through the process using the database splitter and
>> everything works fine with the FE on my local desktop and the BE on a network
>> file server. I read that the next thing to do is to save the FE as an MDE
>> file and distribute that to the users. But, when I click Make MDE file..., I
>> get an error, "Unable to make MDE file". I googled the error message and it
>> sounds like I have too many objects in the database. Is there any way around
>> this error? The make MDE feature seems kind of useless if you're restricted
>> as to how many objects you can have in the db. The .mdb file is 4mb and I'm
>> using Access 2003. I appreciate any advice.
>>
>
|
|
here some ideas and links:
http://alexdyb.blogspot.com/2005/10/microsoft-access-was-unable-to-create.html
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Jeff Stroope" <JeffStroope[ at ]discussions.microsoft.com> wrote in message
news:8FC9CEBE-F6E7-41C5-A2F8-A5C10103FD01[ at ]microsoft.com...
[Quoted Text] > Hi,
>
> I'm just learning about splitting an Access database for a multi-user
> environment. I went through the process using the database splitter and
> everything works fine with the FE on my local desktop and the BE on a
> network
> file server. I read that the next thing to do is to save the FE as an MDE
> file and distribute that to the users. But, when I click Make MDE
> file..., I
> get an error, "Unable to make MDE file". I googled the error message and
> it
> sounds like I have too many objects in the database. Is there any way
> around
> this error? The make MDE feature seems kind of useless if you're
> restricted
> as to how many objects you can have in the db. The .mdb file is 4mb and
> I'm
> using Access 2003. I appreciate any advice.
>
> --
> Thanks,
>
> Jeff
>
> Jeff
|
|
"Tom Wussernark [MSFT]" <tw[ at ]microsoft.com> wrote:
[Quoted Text] >consider yourself lucky
Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
|
|
|