Using Access with Sql Express?

[Chris Hayes]

Using Access with Sql Express?

Can you do this?

Is it worth doing?

Here's the situation:
- Non Profit Database in Access 97
- They upgraded software to Access (Office) 2003
- Database is believed to be mdb and not split on a server shared (3 to 4
users)
- 25000 contact records plus related records
- Database runs sluggish and some applications do not run or crash
application.


I want to help these folks, but this may be out of my range of experience.
I'm a good user with some design experience but on a light scale.
--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name who
wrote that song about "Spam"]

 

[Tom Wickerath]

Hi Chris,

You might want to review the list of suggestions that I have compiled here,
before deciding that you need to migrate the data to SQL Express. You most
definately should split the application; each user should be running their
own copy of the FE database. The three most important things that you can
check for include 1.) Turn off Name Autocorrect, 2.) Set all table
SubDatasheets to [None] and 3.) make sure you are establishing a persistent
connection to the BE database. But, there's lots of other tips in this
article as well, such as adding appropriate indexes and not opening bound
forms to huge recordsets, etc.

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Chris Hayes]

Thanks Tom

I'll read it over and see what we can do.


--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name who
wrote that song about "Spam"]

Hi Chris,

You might want to review the list of suggestions that I have compiled here,
before deciding that you need to migrate the data to SQL Express. You most
definately should split the application; each user should be running their
own copy of the FE database. The three most important things that you can
check for include 1.) Turn off Name Autocorrect, 2.) Set all table
SubDatasheets to [None] and 3.) make sure you are establishing a persistent
connection to the BE database. But, there's lots of other tips in this
article as well, such as adding appropriate indexes and not opening bound
forms to huge recordsets, etc.

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Using Access with Sql Express?

Can you do this?

Is it worth doing?

Here's the situation:
- Non Profit Database in Access 97
- They upgraded software to Access (Office) 2003
- Database is believed to be mdb and not split on a server shared (3 to 4
users)
- 25000 contact records plus related records
- Database runs sluggish and some applications do not run or crash
application.


I want to help these folks, but this may be out of my range of experience.
I'm a good user with some design experience but on a light scale.
--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name who
wrote that song about "Spam"]

 

[Tony Toews [MVP]]

- 25000 contact records plus related records
- Database runs sluggish and some applications do not run or crash
application.

What Tom said. 25,000 records isn't even starting to warm up Access.

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