Split Database

[Beeyen]

Good Day,

I actually have two question:

1. I have a DB split with the FE and BE, everything works fine but when the
FE opens it slowly paints down the screen to the startup screen. Is there
anything I do to help speed can do to improve this performance?

2. Is there an advantage to converting my database to the 2002 - 2003 file
format?

3. Is there an advantage to having a MDE as opposed to the MDB?


Let me know

Thanks

 

[Allen Browne]

Answers in-line.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

1. I have a DB split with the FE and BE, everything works fine but when
the
FE opens it slowly paints down the screen to the startup screen. Is there
anything I do to help speed can do to improve this performance?

Depends what's going on when you open the database. If there's no code
running, the solution might be to get a faster computer, or one with more
RAM.

2. Is there an advantage to converting my database to the 2002 - 2003 file
format?

Probably not. Unless you need something supported by the A2002/3 file
format, you gain nothing, and you lose the ability to run the database on an
Access 2000 machine.

3. Is there an advantage to having a MDE as opposed to the MDB?

No advantage if you are the only one using thise database.

If other people are using your database, there are advantages in using an
MDE:

- They cannot open your forms/reports in design view, and mess them up.

- They cannot view or modify your code, and it cannot decompile (especially
important when opened under different versions of Access.)

Note that you will need Access 2000 to create an MDE if you use the A2000
file format.

 

[Beeyen]

Thank you Mr Browne

Answers in-line.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.



Depends what's going on when you open the database. If there's no code
running, the solution might be to get a faster computer, or one with more
RAM.


Probably not. Unless you need something supported by the A2002/3 file
format, you gain nothing, and you lose the ability to run the database on an
Access 2000 machine.


No advantage if you are the only one using thise database.

If other people are using your database, there are advantages in using an
MDE:

- They cannot open your forms/reports in design view, and mess them up.

- They cannot view or modify your code, and it cannot decompile (especially
important when opened under different versions of Access.)

Note that you will need Access 2000 to create an MDE if you use the A2000
file format.

 

[Armen Stein]

Depends what's going on when you open the database. If there's no code
running, the solution might be to get a faster computer, or one with more
RAM.

Also, is the FE on your local PC, or on the network? It will be
faster and more reliable on your local PC.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com