My Database crashes many times!! :(

[ashish_gr3at]

Hi,

I have made one access based workflow, in which I have place many controls on a user form. now my problem is that whenever I tried to update/add any new thing in vba code the access application crashes

I even imported all the tables, queries & forms to a new access database, but all in vain

I am using access 2003, and its a multi user tool placed on a shared drive.

Please provide your your expert advice on the same.

Regards,
Ashish

 

[ashish_gr3at]

Database crashes many times --Please help!!

Hi,

I have made one access based workflow, in which I have place many controls on a user form. now my problem is that whenever I tried to update/add any new thing in vba code the access application crashes

I even imported all the tables, queries & forms to a new access database, but all in vain

I am using access 2003, and its a multi user tool placed on a shared drive.

Please provide your your expert advice on the same.

Regards,
Ashish

 

[SOS]

Read this - it is important.

 

[SOS]

Re: Database crashes many times --Please help!!

FYI - It is bad manners to post the same question more than once on a forum.

Reported to mods/admins for deletion.

Original post here

 

[ashish_gr3at]

Re: Database crashes many times --Please help!!

Well I my apology!! actually i need the solution urgently and in a hurry i posted it in wrong forum link

 

[ashish_gr3at]

any advice please

 

[pegsus]

Re: Database crashes many times --Please help!!

Well I my apology!! actually i need the solution urgently and in a hurry i posted it in wrong forum link

There is something with your attitude that I am sure is the reason why people are not replying. Frankly, I believe a solution has already been posted. Sorry if you don't have the time to read it.

 

[ashish_gr3at]

pegsus, I am unable to find any post related to solution in this thread

 

[ashish_gr3at]

it seems you are referring to some other thread and posting in this thread!!

 

[Kryst51]

See Post #3, SOS posted a link that might help you.

 

[ashish_gr3at]

Kryst51, Very thanks for your reply. But that link is not opening here on my server

 

[Kryst51]

Type this in your broweser

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[ashish_gr3at]

Is there any other way besides spliting the datbase into code and data , this slowed the overall performance of the database.

Any way that was a nice piece of information. but i am greatful if you can provide me some other logic for this

Thanks again!!

You rocks!!

 

[Kryst51]

Is there any other way besides spliting the datbase into code and data , this slowed the overall performance of the database.

Any way that was a nice piece of information. but i am greatful if you can provide me some other logic for this

Thanks again!!

You rocks!!

That is the only right way to do it....

 

[ashish_gr3at]

Ok, thanks.

But how can I now fine tune the performance. tables are now there in other database. is there any other way to connect these two MDBs to have the faster performance?

 

[Kryst51]

I would suggest doing a google search on "speeding up a split access database"....I haven't worked with a split database yet (I am working on one now actually) so I can't give any advice. But here is an article I found, that I will probably implement into my own after some more reading around the net.

 

[pegsus]

Here is a bit more about how to split your database into front end and back end.

http://www.databasedev.co.uk/split_a_database.html

Some more hints: Split the database. Place the back end (the one with all the tables) on to the shared drive, and front end to your desktop.

The front end database will now have to be linked to the back end. and you should be set.


Let us know how it worked once you have tried it.