work localy with database

[refaeldakar]

hello,

i have a database on the network and when i run a function with many queries it works really slow.

is there a way to copy the database to the local computer, make the queries and continue working on the database on the network?

other users also work on the network database so it's important that the file stays linked to that DB.

note that i got some suggestions to convert to SQL Server. Is it the only way? how do i do that?

please help...

refael

 

[bonekrusher]

make a replica of the db.

 

[refaeldakar]

make a replica of the db.

i don't know how

 

[Imdabaum]

How many people are using the database? If it's feasible you should be able to go into tools and run a replica wizard from the one on the network, install the replica on your local drive and then make sure everyone else gets a replica.

 

[refaeldakar]

How many people are using the database? If it's feasible you should be able to go into tools and run a replica wizard from the one on the network, install the replica on your local drive and then make sure everyone else gets a replica.

thanks for your reply,

the database is used by about 10 people simultaneously. the database is being updated all the time.
i will have to make an automation of the replica generation is it possible?

thanks

 

[KeithG]

If you have multiple users you should split the database into a Front End and Back end.

 

[refaeldakar]

If you have multiple users you should split the database into a Front End and Back end.

what do you mean?

 

[KeithG]

Have a database in your shared folder with just the tables in it. Then create a another database on each users machine with all of the Forms,Modules,Macros and reports and then link the tables from the database on your share to the one on the users PC.

 

[Imdabaum]

By having the data table replicated if your employees/ co-workers need to input data or work away from the office they can have a replica (copy) of the BE on their machine and FE linked to that one. Then when they come into the office and regain access to the shared folder they can then synchronize. The data changes since last time they were in the office.