Copied Access Database Issue

[Volk72]

I have an Access Database that I have copied to another machine for testing
purposes. I had to create a partition to act as the same drive letter as our
server since that is the way some of the code is written and I did not want
to have to go through and change the code. I am able to edit everything
except for the forms that were created. I have to test some changes and do
not want to do it to the actual database. I appreciate any assistance you all
can provide.

Thank You
Volk72

 

[Arvin Meyer [MVP]]

You can use a Conditional statement, like:

In your Declaration section:

Const fDebug As Boolean = 0

Then in your code:

If fDebug = True Then
If FileExists("S:\Customers\Bid_Crosstab_ByTrade.xls") Then '...
Else
If FileExists("X:\Bid_Crosstab_ByTrade.xls") Then '...
End If

All you need to do is to change the fDebug constant from false (0) to true
(-1), and everything in the database will work the way you want..