Error messages

[cdacey]

I have two questions that I am stumpped on.

I have developed a somewhat extensive database, which has worked perfectly with no errors except for these two:

1. I have tried on several occasions to split my database and keep getting the same message; "Subscript out of range" . The splitter wizard does create a duplicate table database but dosn't link anything. My first thought is that I may have deleted a table that an old form was connected to, but all of my queries, forms, and macro's seem to run fine. I am stumpped ?

2. I have this same database running on a LAN (unsplit), which has been working fine. However, one user uses a fujitsu tablet on the wireless lan, which seems to work fine, except he occasionally gets the following error : " the operation is not supported within transactions" he cancels the error box, and it pop's up again, and again, untill he closes the program. I have no idea whats causing it. No other user on the hard-wired lan ever has this error appear. ?

If anyone has any thoughts or direction on either of these errors I would greatly appreciate.

Thanks Chris

 

[jfgambit]

Ok, let's see how much of my ISP knowledge I remember...

I assume he is running an 8211.B card to a central antenna in the office. Is it a Cisco Router, Motorola or one of those "off the shelf models"? In any case he should have signal tester software which was installed when he added the 8011.B card software and drivers. When he gets this error have him check the signal to ensure that he has not lost it and gotten disconnected from the database while running the query. Also, are you connected to an Oracle back-end through ODBC? If so, the slightest signal drop or loss of signal will cause you to disconnect and lose processing during a query run.

As for splitting the database, have you considered doing it manually, and quickly. it sounds like there are a number of people tapping into the same database at the same time. You want to make sure that if one of them causes a problem it does not affect the others.

MS has the following article on Manually Splitting:

Manually Split DB

HTH

 

[cdacey]

hth,

Thanks for the info on manually splitting. I will persue that. I was just wondering if that error "the operation is not supported within transactions" specifically indicates a lack of contact with the database ? I will also check the signal strength on the tablet.

Thanks again,
Chris