Need some help

[Msloujon]

Ok I designed this database and now other users want to view the data and the
IT guy showed me how to make it a .mde now others can see or run reports.
But when I go into the .mdb and make change and updates and (this is where
the IT guys has told me to make my changes) when I try to do this it is
stalling with this message at the bottom (MDE/ADE) and just sit there and NO
RESPONSE so then I have to close it out, but it will create a db1.mdb file.
What am I doing wrong? The IT guys is only part-time and he could only
remember how to make the .mde change. By the way I am using ACCESS 2003
thanks. Help

 

[Damon Heron]

You should have two dbs - one an mdb and one an mde. The mde isn't strictly
necessary - it just allows you to restrict the users access to certain parts
of the program, etc. The mdb is where you can make changes and do your
updates.
?1 - is the db split?
?2 - do you compile your code after you make changes - its in the VB window,
under debug.
?3 - Delete any .ldb files you see in the folder when your db is closed.
As a last resort, open a new blank db and import all your tables, forms and
reports into the new db.
Then split the db, compile it, and make your new mde.

Damon

 

[Msloujon]

I've tried what you are suggesting but I'm a little slow at this. I did
split the db but compling the db is where I got lost. Had VB many moon ago.
If you have time maybe I can get more help from you or someone else. Thanks
so far

 

[Damon Heron]

From main screen, with your db loaded, go to VB window by keying Alt + F11.
Then select Debug from the top menu, and first selection "Compile..."
Your db will not compile if you have any errors, and it will stop at those
errors and give you an explanation....
From those, you can ask further questions of the newsgroup.
If all compiles okay, then you need to tell us what problems you are having.

Damon

 

[Rich Wonneberger]

Damon,

Few quick questions if I may.
When you split the db and compile, what are you compiling, the front end
or the back end?

If I have queries in the f-end do they compile?

Will the end user be able to modify the queries, or forms?

Will the end user be able to create their own queries or forms?

Is the compiler included in Access 2003?

TIA
Rich W.

 

[John Spencer]

1) Normally, you will be compiling any VBA associated with the
front-end. The backend normally contains nothing but the data (tables).

2) No, the queries do not compile.

3) Yes, the use will be able to modify queries and forms - unless you
don't allow them to access them or control their access with user-level
security. If you make the database (front-end) an mde then the user
won't be able to modify the forms.

4) Yes, to creating queries. No for forms, if the database is an mde.

5) Yes, compile (vba code) is included in Access 2003 - it is there for
all versions of Access (at least since Access 97, I don't know about
versions prior to Access 97.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Rich Wonneberger]

John,

Thanks for the info.

Rich W.