Error # 94 edit_user load

[brewerbill]

I see there is some information here already on this, however, it does not seem to fix my problem. I am needed to add user to the pagegate.mdb database in Access on not through PG Admin because I have over 5,000 users to add in and do not desire to do so manually in PG Admin. Whenever I create a new record in the users table however and then try to open it/ edit it in PG Admin I get an error: "error #94 Invalid use of Null in procedure edit_user load" These even occurs when I copy an "OK" record created in PG Admin and then Paste Append it to the table. The data should be the same (except I am change the user and id fields). In one post you say there can be no Null data for new entries? Please help me to understand how I can add these records in Access without receiving this error.

[Tech Support]

PageGate's database is very specific as to what information needs to go into what field. I'd recommend that you import the information instead of trying to add it directly to the database table.

If you would, let me know what carrier(s) you've configured in the program as well as how those carriers have been configured. Once I have that, I can post a template that you can use to create a text file that you can import.

[brewerbill]

Carrier (Name): MW
Protocol: TAP
Failover: [none]
Phone Number: [blank]
Baud Rate: 2400
Parity: Even
Data Bits: 7
Stop Bits: 1
Int String: [blank]
Max Chars: 240
Password: [blank]
Msg Limit: 0
Drop Non Print: Not Checked
Pulse: Not Checked

Please let me know if you need anything else

[Tech Support]

It's a little odd that you don't have a phone number and the carrier is configured as TAP. The TAP protocol requires a phone number to the carrier's terminal bank to deliver a message. Which carrier are you wanting to deliver your messages through?

[brewerbill]

I was provided these instructions by PageGate to setup a direct seriel connection with the paging terminal....this works and this is why it is setup like I described...

Instructions to set up PageGate with a direct serial connection (TAP) to an in-house paging terminal:

1.) Attach the paging terminal to the server/computer running PageGate with a serial cable. Note the Serial Port the cable is plugged into.

2. In the PageGate Admin select 'Connectors' - 'Dialer1' - 'Settings':
3. Type in the 'Init String': direct.
4. Leave the 'Dialing Prefix': blank.
5. Leave the 'Dedicated Carrier' set to (none).
6. Ensure the 'Serial Port' is set to the Serial Port the serial cable is plugged into.
7. Check Direct Connect.
8. Click 'Apply'.

9) In the PageGate Admin right-click on 'Carriers' and select 'Add'.
10) Type in any carrier name. Using a naming convention that is fairly straightforward may be convenient.
11) Leave the 'Protocol' set to TAP.
12) Leave the 'Failover' set to (none).
13) Leave the 'Phone Number': blank.
12) Click 'Apply'.

Create recipients in the PageGate Admin right-click on 'Recipients and select 'Add'. Right-click on 'Groups' and select 'Add' to create groups.

[Tech Support]

Oh! I didn't realize you had a direct connection to a terminal. If you do, that's the proper way to have it configured.

Since that's the case, here is how each line of the text file to import should look:

"401","recipient","FullName","ID\PINHERE","CarrierName","","240",#FALSE#,"999",#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,"0",#FALSE#,"",#FALSE#,"","","","","","","","","","","","","","","",#FALSE#,#FALSE#,#TRUE#,"",#FALSE#,#FALSE#,"",#FALSE#,"","","","",#FALSE#,"2/6/2007 10:00:00 PM","2/6/2007 8:00:00 AM"
"401","recipient2","FullName2","ID\PINHERE","CarrierName","","240",#FALSE#,"999",#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,"0",#FALSE#,"",#FALSE#,"","","","","","","","","","","","","","","",#FALSE#,#FALSE#,#TRUE#,"",#FALSE#,#FALSE#,"",#FALSE#,"","","","",#FALSE#,"2/6/2007 10:00:00 PM","2/6/2007 8:00:00 AM"

[brewerbill]

When I try to import the text file you provided I can an error "Field 'Field55' doesn't exist in destination table 'users' ."

I also did an export into text file from the table of a recipient that I built in PG Admin and it looks a little different....

"8761936","Brewer, William","8761936","","MW",240,1,0,"999",0,0,0,0,0,"",0,1,0,0,0,1,0,1,0,0,0,"","","","","","","","","","","","","","","","",0,0,0,"",0,"","","","",0,12/30/1899 22:00:00,12/30/1899 8:00:00

[Tech Support]

Ah, you don't want to import it directly from Access. You'll want to import it from the PageGate admin.

Go to the Database - Tools - Import - Recipients section to import the file structure I posted earlier.

[brewerbill]

Ah, didn't know you could do that....however...that worked perfect. Thank you so much for your help!