Slow database and splitting

[Guest]

Hi!

I made a test database on my own computer. It takes a couple of minutes to
run through all the code I have. When I move this database to a network
drive, it takes an hour to run the code. Why? Could scanning for viruses be
an issue? Or the fact that data has to be moved from the network drive to my
computer?

Well, I tried to solve this problem by splitting the database. When running
the code I get an error 3611 "Cannot execute data definition statements on
linked data sources." I try to do an ALTER TABLE -command with docmd.runsql.
How can I fix this? I tried db.excecute, but it gives me the same error. Is
there any other things I need to know about possible errors with splitting?
This is the first time I have ever tried to split a database.

- Beginner -

 

[Alex Dybenko]

Hi,
splitting - is a good idea, but right - you have to change data definition
statements execution. you have to open database with tables (backend, BE)
and then use execute method:

dim dbBE as database
set dbBE=opendatabase("<path to BE>"
dbBE.Execute "ALTER TABLE ...", dbfailonerror


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Hi Alex!

Thaks for the advice, there seems to be always something I don't understand
to think about!

- Beginner -

 

[Roger Carlson]

Check out Tony Toew's Performance FAQ for more suggestions:
http://www.granite.ab.ca/access/performancefaq.htm